SSRS - Want to display the same chart multiple times based on DB result
Posted on 2013-12-23
Hi, i am relatively new to SSRS, but not new to development or SQL Server. I have a project to create some executive reporting and was wonding if what i want to do is possible.
I have a pie chart that i create which is based on City, the chart shows a breakdown of inventory per city. So for example, in Miami there are 10 of item 1, 15 of item 2, 4 of item 3, etc.
My DB query returns the inventory counts grouped by city.
Is there a way to repeat the same pie chart on a report multiple times, dynamically driven by the data set? If my data set only had results for Miami and JAcksonville, i would have two charts. If it returned Miami, jacksonville, orlando, pensacola, and tampa there would be 5 charts.
Is this possible in SSRS or do all the charts / reports need to be pre-defined? IF its possible how would it be done? FYI this is SSRS 2012 and i am currently using the report builder.
Thanks in advance