How to show sub report values in chart in main report

building reports crystal reports
1

Hi,

I need to show the subreport Month on month values in main report chart.
Can any one tell me the process to achiev this?

Thanks in Advance

leninreddy19 (BOB member since 2011-06-21)

2

You can’t show data from the subreport in the main report unless you can pass the data in a shared variable. From what you’ve written, that’s probably not going to work for you.

-Dell

hilfy :us: (BOB member since 2007-04-16)

3

Thanks Hilfy for replying

I linked subreport with month object and created a shared variable in subreport and i called that variable in my main report it is working fine in details section when i place that variable in header or footer its giving either first value or last value and not able to show data in chart in main report.Is there any way to show the data in chart using shared variable?

Thanks in Advance

Regards,
leninreddy

leninreddy19 (BOB member since 2011-06-21)

4

No. If I understand correctly what you’re trying to do, you want to bring the entire data set from the subreport into the main report. There is no way to do this. Shared variables will get you only a single value.

Could you put the chart in the subreport?

-Dell

hilfy :us: (BOB member since 2007-04-16)

5

It is not allowing me to place the chart in subreport.only body section is available remaining sections are hidden.If i could place the chart in subreport how can i show that in my main report? My requirement is to compare month on month actual(Main report) and plan(Subreport) values in one line chart which are coming as two different data providers.

Regards,
Leninreddy

leninreddy19 (BOB member since 2011-06-21)

6

You’re going to have to find a way to get both sets of numbers in the main report. You’ll probably have to write a command (SQL Select statement) to get the data in a format that you can use.

-Dell

hilfy :us: (BOB member since 2007-04-16)

7

I am using crystal reports for enterprise 2011.universe is the data source i can not get those values in one single query and that too Crystal is not supporting multiple queries…

Any solution for this?

Regards,
Leninreddy Sunkara

leninreddy19 (BOB member since 2011-06-21)

8

Write the SQL Query in the Sub report by pulling the months and other field to display as the chart. create a chart in the sub report itself. Then place this chart into into the main report either in the group headers or the group footer or page headers or footer but not in the detail of the main reports based on the requirements.

Hope understood…

rizwan syed :us: (BOB member since 2010-07-08)

9

Thanks Rizwan for replying.
how can i place subreport chart in main report?it is not allowing me to place the chartin main report.could you elaborate please?

Regards,
Leninreddy

leninreddy19 (BOB member since 2011-06-21)