Print Page | Close Window

sums of columns into a pie chart

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19907
Printed Date: 19 Apr 2024 at 9:53am


Topic: sums of columns into a pie chart
Posted By: Joscan
Subject: sums of columns into a pie chart
Date Posted: 19 Aug 2013 at 5:02am
Hi There,
I have an urgent question and hope you can help me. I am by no means a CR expert but have been asked to help out with a CR development task. The actual report is going ok as it is fairly easy.

I am trying to create a PIE chart in a report and so far nothing is working.

The situation is as follows:

I have several columns that all contain Hours.

Example:

Internal Hours    ext h1    ext. h2     ext h3     ext h4
50                        0            10         4               0
10                        2             0          0               0
25                        0             8          20             2        

Each row would be associated with an employee. They may do internal work or differnt external jobs and therefore have the hours.

So I created the totals of each of the 5 columns.
These totals I need to use in a pie chart. I created a cross tab in which I put the sums of the columns to get one column. I am trying to use that to create the pie chart but CR is not recognizing that cross tab so I assume what I did is not really a cross tab somehow.

Any suggestion what I can do?
Thanks,


Print Page | Close Window