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,