September 20, 2010 at 8:51 am
I'm trying to write a report to display total revenue and target per office with an individual graph per office. Not written charts in SSRS before and I'm really struggling with it. Anyone able to help please?
As you can see from the attachment, I need a separate chart per office. The number of offices is not finite i.e. I don't want the report to have programmed in three charts corresponding to these three offices, I want it to be dynamic in that, if the next time we've got 4 offices I don't want to have to amend the report to include another office chart. I want it to display a chart according to the number of offices listed in the first column.
September 20, 2010 at 9:06 am
Try putting the chart in a list control where the list control is bound to the offices. The chart should bind to each office's data as it loops through.
September 22, 2010 at 4:54 am
This works really nicely setting the office as the detail group. Brilliant. Many thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply