Multiple Charts in an SQL Report

Question

I am preparing a report in SQL Reporting Services 2012, and I want to show a variable number of charts based on the data that I have.

So the (simplified) data source looks like

ID Name Group Sales ============================= 1 apples fruit 15 2 bananas fruit 25 3 carrots vegetable 10 4 brocolli vegetable 19 5 tuna fish 15 

For each group, a graph based on names and values:

• Chart 1 - Fruit Sales
• chart 2 - sale of vegetables
• chart 3 - fish sale
• etc.

But I do not want to hard program the names of the groups - if a new group is added to db, a new graph should appear in the report.

Answer 1

Create a table based on your grouping of the datasets in the "Group", and then insert the chart into the table, SSRS should take care of the rest.