Chart Constant Lines/Strips/Conditions

[NadinW]

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, …)

Example.mrt

(26.62 KiB) Downloaded 240 times

ExampleData.csv

(127 Bytes) Downloaded 218 times

Thanks

[HighAley]

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.