Solved

# Crystal Reports - Creating a Pie Chart

Posted on 2005-04-27
539 Views
Hello,

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!

John
0
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.

HTH,
DS
0

LVL 1

Expert Comment

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

## Featured Post

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.