Not possible to use a Shared NumberVar from Surbreport in a chart in m

[eo]

Not possible to use a Shared NumberVar from Surbreport in a chart in main report.

CR10:
Staked Bar Chart in the report header:

1) Different bars 'On change of Group Header 1'
2) Some stacked bar section totals generated in the group 2 footer of the main report
3) The other stacked bar section totals generated in the group 2 footer of the sub report (as shared variables)
4) The subreport placed in Group 2b footer of the main report
5) The shared variables as per (3) above called in Group 2c footer of the main report

Any idea why the shared variables called as per (5) above is not available in the chart, and how I can tweek the report to include them in the chart?

Thanks in advance

Etienne Oosthuysen
Hertfordshire, England

 

[GJParker]

Try placing the chart in the report footer, to see if the the subreport values become available.

I suspect the values from the subreports aren't available because of the order in which crystal evaluates sections.

Post back and let me know.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[lisanguyen]

Shared variables evaluate too late to be used in your situation. You can sneak around this by creating another subreport (which will be used to chart on) and then pass the shared variables into this chart using the subreport links but unlinked to any fields. If you have more than one valule then you have to roll these values up and then pass the formula through subreport links. It's a lot of manipulation and often not worth the hassle.

 

[eo]

I think I should resign myself to the fact that it is probably NOT woth the hassle, the user will simply receive two charts as opposed to one single chart.

Thanks for the efforts anyway

Etienne Oosthuysen
Hertfordshire, England