asked on

Can a bar chart span multiple pages in Crystal Reports XI?

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,
Bob

ASKER CERTIFIED SOLUTION

theomysh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

To answer your question - Can a bar chart span multiple pages in Crystal Reports XI?

No. Only a cross tab can span pages horizontally.

mlmc

wanderingbob

ASKER

Mimcc,

Thank you for the information. I see that I should have been more specific - I don't want the width of the bars in the horizontal bar chart to span more than one page horizontally; rather, if 20 bars (representing 20 part numbers) can fit on one page, I would like the bar chart to be extended vertically over a total of five pages (for example) for 100 part numbers, like this:

(Page 1)
Product 1 --------------------
...
Product 20 -

(Page 2)
Product 21 --------------------
...
Product 40 -

Bob

Thank you,
Bob

wanderingbob

ASKER

Thank you Theomysh! This worked exactly as you said to extend the horizontal bar chart over multiple pages. I used TRUNC((ROWNUM - 1)/20) + 1 AS GROUP_NO to create the group numbers.

napoleontan

I tried to do the same thing using the Accepted Solution of theomysh.

However, the chart did not separte on group number. What happened in my result was:

(Page 1)
(Group Number - Page Break)

(Page 2)
(Group Number - Page Break)

....

(Page N)
Chart in tack and not separated by group (All data in one graph.)

Is it even possible to separate the Chart data even if we can onlyplace it in either Report Header/Footer only?

Mike McCracken

You may want to open your own questiion.

Are you trying to get several charts but have them all in the report footer?

mlmcc

napoleontan

no, i have one bar chart. but the bar chart has too many data in such a way that the data are so small to see. i was wondering if i could break the bar graph/chart to every page for every N record. say every 30.

theomysh

Then add another group by field and have the first 30 values for this group field as 1, the second 30 as 2 and so on.

Mike McCracken

I don't think you can in the report footer except by using a subreport

mlmcc