In the attached design a series of pie charts is created based on the data in the report's configured data set at run-time. The number of pie charts generated is data-driven and is not known during design.<br />
The trick is to create a table element on the report consisting of a single grouping. This grouping is the element that determines the number of charts that are rendered. By placing the pie chart inside the table's group header, the chart is repeated automatically for each group found in the Data Set.<br />
<br />
In the example, a sample Classic Models data set is used. A grouping is done on Product Line. Once that grouping has been created on a table, a chart is added to the Group Header Row. When adding the chart, be sure to configure the chart to "
Inherit Data From the Container" on the data configuraion tab. This will ensure the data used to build the chart is specific to each group. Other than that, there is not much to this.<br />
<br />
The report features a paramter to affect the minimum deal size. Altering this parameter will allow you to eaisily see the number of charts change. Make the parameter 10,000 and you will shift from 4 charts to 3. Make the value 5000 and you will have 6 charts.<br />
<br />
Click here to try it out now!<br />
<br />
Sample built using the Classic Models sample data, so you should be able to download and run it as-is, no modification needed.<br />
<br />
Good Luck!
