Problems with pie charts in report with grouped data

[HGrijmans]

Hi,

I have the following table [Employee, ProductionCell, Customer, WorkedMinutes].
In the report I have two nested Groupheaders, the first one on Employee, and the second one on Productioncell.
For each Employee, productionCell combination I want to show a pie chart with customers and WorkedMinutes, so I placed the piechart in the inner Groupfooter ( of ProductionCell).
However the piechart Always shows all customer,WorkedMinutes information independent of Employee, and productionCell.

Example:
Employee ProductionCell Customer WorkedMinutes
John Design Acne 100
John Design Fabric 70
]John Construction Fabric 125
Peter Design Acne 500
Peter Construction Acne 250

In this example I get 4 piecharts (for each {Employee,ProductionCell} but with all Customer,WorkedMinutes data.
I already used a virtual table but this result in the same piechart.
( I have attached the Original report file, however the naming is Dutch).

Does any one know how to solve this problem?

regards
Hans Grijmans

[Alex K.]

Hello,

Can you please send us a test data for your report.

Thank you.

[HGrijmans]

I have placed some test data in my Original post. (See above).
The first three columns are strings, the last column is of type double.
Translation in case of problems with Dutch:
( Employee = Werknemer, ProductionCell = Productiecel, Customer = Klant, WorkedMinutes = GewerkteMinuten)

[HighAley]

Hello.

You should use variables to Filter data for Chart.
You could set its value in the Before Print event of each Group Header.
Please, look at the attached report template.

GroupChart.mrt

(30 KiB) Downloaded 178 times

Thank you.

[HGrijmans]

Hello Aleksey,

Thank you very much for your solution, it did the job.

with regards
Hans Grijmans

[Andrew]

Hello,

Great! Have a nice day!