Pie Chart (negative values) calculating as positive in the LEGEND

Posted on 2006-03-20
Last Modified: 2012-05-05
Product: Crystal Reports XI Enterprise

I have a pie chart that is displaying values of the slices in the legend. The total that is represented is adding a negative as a positive even though the legend is displaying the figure as a negative. Here is what is being displayed:

Country A       $115,745
Country B       $8,400
Country C       $100,800
Country D       $9,050
Country E       $0
Country F       $44,475
Country G       $45,000
Country H       $22,050
Country I        $28,440
Country J        ($24,140)
Country K       $12,240

Total             $410,340

The correct Total should be $362,060 which displays correctly in the Report Footer Grand Total. Country J is a negative and the report details represent this, it is only in the legend that the sum figure incorrectly.

Any help would be greatly appreciated.

Question by:atricure
    LVL 100

    Expert Comment

    WHere is the total?  How did you place it?


    Author Comment

    The correct total, Grand total is in the Report Footer. Group totals are in the group footers. All totals are displaying correctly in the rport itself just not in the LEGEND of the Pie Chart.

    Author Comment

    Pie Chart Grand Total is calculating country J as a POSITIVE not a NEGATIVE
    LVL 100

    Accepted Solution

    I don't know unless because a pie chart is used to show how much it can't handle or handles negative values incorrectly.

    LVL 8

    Assisted Solution

    atricure, The concept of Pie Chart is to handle only positive value, which will display the percentage of each item participate in the circle. Imagine that you have a negative value, how are you going to display it using pie chart?
    If you have negative value in your chart, pie chart is certainly not suitable in your case, use bar char instead.


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    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…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    732 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

    17 Experts available now in Live!

    Get 1:1 Help Now