Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Spanning simple chart across pages

Hi,

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?

thanks, Eddie

replied

Eddie,

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;

WhileReadingRecords;

numbervar x:= x + 1;

numbervar y;

if remainder( x, 15) = 0 then y:= y + 1 else y

Group on this formula and then insert the chart in the Group Header

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question