Crystal Reports - Creating a Pie Chart

Posted on 2005-04-27
Last Modified: 2010-05-18

I have selected a range of columns in Excel and created a crystal report.  I have summed a few of the columns in Crystal and wish to create a pie chart of those fields.  I am having problems though.

Here is an abrieviated list of what I am trying to use for the chart:

1) Count of Column called "Assessment Number" = 608 - This tells me the number of applications assessed
2) An equation based off of "count of total number of applications - # of applications assessed" which give me the total number of applications not assessed = 2400

I now want to creat a simple pie chart showing the two numbers (608 and 2400).

Within Chart expert, I add these two fields to the "show values" area; but what do i put in the "on change of record" area?

Thanks in advance for the help.  I am new to Crystal so you will see a lot of me around here for a while!

Question by:jz1english
    LVL 3

    Accepted Solution

    I don't think you can plot 2 seperate measures in a pie chart so you will need to rearrange your data.  If you devise some kind of indicator (maybe based on the existence of an Assessment Number) you could add the count of application to the "show values" area and put the indicator in the "on change of record" area.

    LVL 1

    Expert Comment

    On change of record applies more to a database record.  Can you leave it blank?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    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…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now