If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pie chart in a report
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. -- h.lovera |
#2
|
|||
|
|||
pie chart in a report
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 -- Build a little, test a little. "h.lovera" wrote: 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. -- h.lovera |
#3
|
|||
|
|||
pie chart in a report
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. -- h.lovera "KARL DEWEY" wrote: 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 -- Build a little, test a little. "h.lovera" wrote: 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. -- h.lovera |
Thread Tools | |
Display Modes | |
|
|