All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

Reporting Services Tip – Automating the creation of multiple charts

Reporting Services Tip – Automating the creation of multiple charts

  • Comments 1
  • Likes

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)
  • I did this , the chart is pefectly show in the preview (VS), but after deployed to SRS Report Manager, the chart is blank without any error.. do you know why?

    how can the chart be shown up?

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment