pie chart in a report

[h.lovera]

I apologize if this has already been discussed - I read through several
threads but didn't really find a solution.

I need to include a pie chart on a report showing an total employee earned
wage % and a total company paid benefit % in the pie. It needs to change
with every record employee record. The chart's in the group footer.

The chart looks just like it should in design view (2 colors) but when I
switch to either report view or print preview, it becomes a one-color chart.

Here's the SQL. If this has to do with this Row Source, would you please
explain it simply? As a relative novice, I don't yet have a tremendous
understanding of how that all fits together.

TRANSFORM Sum(qryChartTest.TOTBEN) AS SumOfTOTBEN
SELECT qryChartTest.EMPLID
FROM qryChartTest
GROUP BY qryChartTest.EMPLID
PIVOT qryChartTest.TOTBEN;


Thanks much.

 

[KARL DEWEY]

I cannot answer your pie chart question but your crosstab query does not look
right in that you are transforming on same field as you are pivoting.
The results would look like this --
EMPLID 1 4 5 9 15
20044 4
20045 1
20048 9
20052 15
20055 5

 

[h.lovera]

Sorry for my ignorance but this is exactly the problem. I don't know what
field should be in the TRANSFORM and what should be in the PIVOT. I don't
understand those 2 functions.

Can you explain them?

Thank you.