Spanning simple chart across pages
I want to clean up some formatting on a report with a simple chart plotting a formula result against customer names.
The first chart contains the top 15 customers sorted top down using the Top N =15 option in chart group sort.
However, how can I display the next 15 customers on the second page?
Is it easier to do this via subreports? or if there a function that I can use?
Graham Cunningham replied
If you can perform the grouping and aggregation on the database and in the order you need this would be fairly simple as you could then set up a WhileReadingRecords formula that groups every 15 records together;
numbervar x:= x + 1;
if remainder( x, 15) = 0 then y:= y + 1 else y
Group on this formula and then insert the chart in the Group Header