Crystal Reports - Creating a Pie Chart

Posted on 2005-04-27
Medium Priority
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

Accepted Solution

DataSenser earned 2000 total points
ID: 13879703
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.


Expert Comment

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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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 …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month13 days, 16 hours left to enroll

809 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