Chart based on the formula and group 1

[russula]

Hi to All,

I have CR XI and problem with chart.

The data are grouped by month. For each month (for each group) I create array and calculate in the group footer Maximum for this array. The formula for it is following:

whileprintingrecords;
evaluateafter ({@CreateArray});
numberVar array MyArray;
Maximum (MyArray);

And then I would like to build the chart to show Month-Maximum (or Maximum for each group). The problem is – I can’t choose this formula from the list from creating chart, it is simply not in the list.

Could you please advise me how to create chart based on grouping and result of calculation?

Thanks,
A.

 

[lbass]

Are you sure you need to use arrays for this? Using these types of formulas, you would need to read and follow the approach in the Business Objects whitepaper called "Charting on Print-time Formulas".

-LB

 

[russula]

Ibass, thank you for link to this whitepaper - it was realy very useful, not only for this case .