Reporting Services Tip – Automating the creation of multiple charts

  • Article

I had a question regarding automating the creation of multiple charts from one dataset, instead of having all the series being plotted on the one chart.

An example of where this may be applicable if you have a dataset that has CPU usage for a number of Servers, and you want to create one chart for each server.

 

Following are the steps you can use to automate the creation of multiple charts.

  • Create a table in the report
  • Add a table group, based on server name
  • Increase the height/width of the table group header, so that you can place a chart inside the table group header
  • Design your chart (chart title based on the current server name)