Learn how to a build a cloud-first strategyRegister Now


Format Bar Chart in Crystal Reports to Grow as Needed to Display Data

Posted on 2014-08-02
Medium Priority
Last Modified: 2014-08-04
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
Question by:Chopp
  • 3
  • 2

Author Comment

ID: 40237346
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.
LVL 101

Expert Comment

ID: 40237382
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?


Author Comment

ID: 40237578
Hello mlmcc,

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

LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 40239021
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.


Author Comment

ID: 40239075
Thank you, mlmcc.  That is also the conclusion I have come to.
Apparently the Crystal Reports bar charts cannot extend to multiple pages.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses
Course of the Month21 days, 6 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question