title: Multiple charts in a SQL Report
body: <p>I'm preparing a report in SQL Reporting Services 2012 and I want to show a variable number of charts based on the data I have. </p>
  
  <p>So, the (simplified) data source looks like </p>
  
  <pre><code>ID Name    Group       Sales
  =============================
  1  apples   fruit        15
  2  bananas  fruit        25
  3  carrots  vegetable    10
  4  brocolli vegetable    19
  5  tuna     fish         15
  </code></pre>
  
  <p>For each group - show a graph based on the names and values:</p>
  
  <ul>
  <li>chart 1 - fruit sales </li>
  <li>chart 2 - vegetable sales  </li>
  <li>chart 3 - fish sales</li>
  <li>and so on...</li>
  </ul>
  
  <p>But I do not want to hard-code the group names - if a new group is added to the db, a new chart should pop-up in the report. </p>