Using Crystal Reports XI, I am developing several reports that display the top N part numbers by quantity sold, revenue, gross margin, etc. The data sources for these reports are SQL commands that operate through a connection to an Oracle 10g database. The SQL commands represent summary type query statements, and the user can specify the number of parts to include in the report using a parameter.
The results are displayed in a bar chart in the report, with one bar for each part number. If I minimize the report header and report footer and make the bar chart as large as possible on the page, a readable chart for about 20 part numbers can be displayed on one page.
If it was possible to make the bar chart extend over multiple pages, then any arbitrary top N part numbers could be displayed, i.e. top 50, top 100, etc.
is there any way to make a bar chart extend over multiple pages?
Thanks in advance,