Multiple charts in Reporting Services 2005

Question

Hi,

I want to create a report with multiple charts. I have data like: [month], [percentage], [department]

I have created one chart based on [month] and [percentage], but I want a different chart for each [department] in the same report.

The number of departments is dynamic, as the user can select one or more departments from a multivalue parameter.

(Surely one could run the report selecting one department at the time, but that is not practical and not the desired way)

How do I go about this?

Thanks in advance.

Answer 1

You have to use table control and add a department group. Delete detail row. In the group header row, add a chart control to a table Cell and use Month & Percentage to it.

 

Answer 2

You can also add chart for each department and control their visibility through the parameter. Of course unless you are having too many departments, because it would be a huge overhead in report designing and maintaining.

---

Ivan Donev MCTS SQL 2005,MCTS SQL Server 2008, MCITP 2008 BI Development

Answer 3

Thanks Arun,

I got it to make it work :)

Jos