Creating reports and dashboards | Stimulsoft community forum

Hi there,

I have tried what you’ve suggested, I put the chart on the “Group Header Band” I’m also outputting the data, the data is grouped correctly and it's split to three different groups one per room. However, the chart seems to be plotting all the data of all the rooms on every chart, which shouldn't happen!

I’ve attached example report and example data (CSV file), Can you please have a look and let me know what am I missing.
I would like to get each chart plotting it's related values (one chart per room i.e. chart1 shows only room 1, chart 2 shows values for room2, …)
Thanks

Hello.

You should:

1. Add a variable. For example, its name will be CurrentRoom.
2. Right next line in the Before Print event of the GroupHeader:

   Code: Select all

   CurrentRoom = Example.RoomName;

3. Set Filter expression of the Series to the next

   Code: Select all

   Example.RoomName == CurrentRoom

Please, look at the attached report template.

Thank you.