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
ChoppAsked:
Who is Participating?
 
mlmccCommented:
That may be a limitation of charts.

I don't use charts very often and when I do they are small.

The only thought I have would be to use subreports in the report footer that limit the number of bars in a chart to a reasonable (viewable) number.

You would have to have enough subreports so all data is accounted for.

mlmcc
0
 
ChoppAuthor Commented:
Additional note, the font size which is set to 4, does not appear to actually be displaying as size 4.  The text looks larger than size 4 even though the settings show it is set to 4.
0
 
mlmccCommented:
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
0
 
ChoppAuthor Commented:
Hello mlmcc,

Yes, the chart and the report footer section are taller than a page.  The chart only displays on a single page.

~Chopp
0
 
ChoppAuthor Commented:
Thank you, mlmcc.  That is also the conclusion I have come to.
Apparently the Crystal Reports bar charts cannot extend to multiple pages.
~Chopp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.