Solved

Displaying a gender pie chart in Crystal Reports XI

Posted on 2011-10-01
4
335 Views
Last Modified: 2012-05-12
I am returing data from an MS SQL Server database where each row represents a patients visits to a hospital and clinic.

A patient can make many visits so they can be represented by more than one row in the dataset.

I need to count the number of patients. Easy! A distinct count of the patient id field.

I also need to show the percentages of men and women.  And then i need to show this in a pie chart.

This is cause me problems.  

It must be a pretty standard problem.  I have tried using running totals, but then i cant show them in the pie chart.

Anyone any ideas how to solve this?
0
Comment
Question by:soozh
  • 2
4 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 36897479
Try this idea

Add a formula

If {GenderField} = "M" then
    {PatientIdField} & " MALE"
ELSE
    {PatientIdField} & " FEMALE"

You should be able to use a distinct count on that

If the Patient Id is numeric

If {GenderField} = "M" then
   CStr({PatientIdField},0,"") & " MALE"
ELSE
   CStr({PatientIdField},0,"") & " FEMALE"

mlmcc



0
 

Author Comment

by:soozh
ID: 36897547
hej... thats quite clever... let me check it out.
0
 
LVL 6

Expert Comment

by:Metallimirk
ID: 36899861
Another note: if you need a math formula, the equation is below:

Distinct Count of Males / Distinct Count of Patients = % of Males
Distinct Count of Females / Distinct Count of Patients = % of Females

Once you create these two as formula fields, you can add it to a pie chart as an unlinked subreport and display the pie chart on the order header and anything else you want below it.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36900446
No need for that.  The chart allows you to display the results as the number or a percent and does it correctly

mlmcc
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Reports last day of month 2 61
Crystal Reports Date Calculation 10 42
Crystal reports vb.net 2 54
Crystal Reports - Record selection filter - formula editor 3 17
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 …
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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