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

Posted on 2014-08-02
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

    Author Comment

    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 100

    Expert Comment

    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

    Hello mlmcc,

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

    LVL 100

    Accepted Solution

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    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…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now