Format Bar Chart in Crystal Reports to Grow as Needed to Display Data
Hello Experts,
The report I am working on contains a horizontal bar chart in the report footer. At this time, I can only get the chart to display on a single page. My problem is that there are too many bars/data to fit well on a single page, the axis label displays in a font too large and the values overlap, and therefore do not correspond with their associated bar.
Can you help me with a method to either get the chart to grow to additional pages as needed to display the axis labels and bars better, or how to display the axis label in a font small enough so it does not overlap with the labels above and below?
The font size is already set to the smallest available size of 4 in the 'format axis label' options. The section containing the chart has 'keep together' deselected in the options. The format chart editor has 'keep object together' deselected.
Is there a custom 'page setup' that would allow the report footer to be vertically longer and thus allow for more horizontal bars to display?
I will appreciate any ideas.
Respectfully, Chopp
The report I am working on contains a horizontal bar chart in the report footer. At this time, I can only get the chart to display on a single page. My problem is that there are too many bars/data to fit well on a single page, the axis label displays in a font too large and the values overlap, and therefore do not correspond with their associated bar.
Can you help me with a method to either get the chart to grow to additional pages as needed to display the axis labels and bars better, or how to display the axis label in a font small enough so it does not overlap with the labels above and below?
The font size is already set to the smallest available size of 4 in the 'format axis label' options. The section containing the chart has 'keep together' deselected in the options. The format chart editor has 'keep object together' deselected.
Is there a custom 'page setup' that would allow the report footer to be vertically longer and thus allow for more horizontal bars to display?
I will appreciate any ideas.
Respectfully, Chopp
The report footer can grow to as large as you need it. Have you made the chart itself a full page tall?
Can you make it taller than a page?
mlmcc
Can you make it taller than a page?
mlmcc
ASKER
Hello mlmcc,
Yes, the chart and the report footer section are taller than a page. The chart only displays on a single page.
~Chopp
Yes, the chart and the report footer section are taller than a page. The chart only displays on a single page.
~Chopp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, mlmcc. That is also the conclusion I have come to.
Apparently the Crystal Reports bar charts cannot extend to multiple pages.
~Chopp
Apparently the Crystal Reports bar charts cannot extend to multiple pages.
~Chopp
ASKER