More chart grouping problems
Posted: Mon Apr 16, 2012 8:50 pm
I'm still struggling to create my report when it needs to include charts. The problem is that a chart in a Stimulsoft report can't work with the main report groupings. I'd appreciate any advice on whether the below is possible.
I have a series of time related data that I group by venue and day. The data has a value for each hour in the day. An abbreviated form of the data is shown below.
Venue,Date,Hour,Value1,Value2
Venue1,12 Mar 2012,0,23,2
Venue1,12 Mar 2012,1,15,22
... [another 22 samples for hours 2 to 23]
Venue1,13 Mar 2012,0,25,2
Venue1,13 Mar 2012,1,17,22
... [another 22 samples for hours 2 to 23]
Venue2,12 Mar 2012,0,12,23
Venue2,12 Mar 2012,1,13,20
... [another 22 samples for hours 2 to 23]
Venue2,13 Mar 2012,0,30,20
Venue2,13 Mar 2012,1,179,11
... [another 22 samples for hours 2 to 23]
For my report I group by Venue and Date and display the Sum of Value1, that's fine. But on top of that I need to display a chart for each Venue for each day with the hourly samples in a line chart. That would be easy to do if I could plonk the chart in the data section of the report within my two groups and have it just display the data from the groups but that's not possible. The alternative seems to be to create a separate data source based on the original one and apply the same groups to it but that won't work either as I need to display the hourly sample values rather than a grouping function across the whole data.
My data source is my own business objects so I can shape it any way I want but I can't even see how I would be able to come up with a viable structure in this case. The start and end dates of my report can be variable so I couldn't for example create a separate custom data source for each day. The only thing I can think of is that I add the charts to the report programatically which I'm reluctant to do as then I lose a lot of the ability to customise the report through the designer. I've been going around in circles on this one for over a week now. Any advice would be gratefully received. I've attached a demo report that demonstrates my problem.
I have a series of time related data that I group by venue and day. The data has a value for each hour in the day. An abbreviated form of the data is shown below.
Venue,Date,Hour,Value1,Value2
Venue1,12 Mar 2012,0,23,2
Venue1,12 Mar 2012,1,15,22
... [another 22 samples for hours 2 to 23]
Venue1,13 Mar 2012,0,25,2
Venue1,13 Mar 2012,1,17,22
... [another 22 samples for hours 2 to 23]
Venue2,12 Mar 2012,0,12,23
Venue2,12 Mar 2012,1,13,20
... [another 22 samples for hours 2 to 23]
Venue2,13 Mar 2012,0,30,20
Venue2,13 Mar 2012,1,179,11
... [another 22 samples for hours 2 to 23]
For my report I group by Venue and Date and display the Sum of Value1, that's fine. But on top of that I need to display a chart for each Venue for each day with the hourly samples in a line chart. That would be easy to do if I could plonk the chart in the data section of the report within my two groups and have it just display the data from the groups but that's not possible. The alternative seems to be to create a separate data source based on the original one and apply the same groups to it but that won't work either as I need to display the hourly sample values rather than a grouping function across the whole data.
My data source is my own business objects so I can shape it any way I want but I can't even see how I would be able to come up with a viable structure in this case. The start and end dates of my report can be variable so I couldn't for example create a separate custom data source for each day. The only thing I can think of is that I add the charts to the report programatically which I'm reluctant to do as then I lose a lot of the ability to customise the report through the designer. I've been going around in circles on this one for over a week now. Any advice would be gratefully received. I've attached a demo report that demonstrates my problem.