Reporting Services Chart Grouping Example

If you would like to know how to show a separate chart based on the same dataset, these steps may help you.


The following steps will create a separate graph for each server.


The data used for this example was:



Using SQL Server Report Builder 3.0 create a Blank Report and follow these steps:




Below I am connecting to the default instance’s test database where the data is held






You should see the below



Drag ‘server’ to the first column


We only require the Header and therefore the table row can be deleted




Create a Line chart in the second column in the Header



Resize the Header so the chart is more visable



Remove the last column in the Header as it is not required



We don’t require the first Header column to be visable in the report so we can make it hidden




Click on the chart and you should see Chart Data.
Drag the Dataset fields to the Chart Data as shown below.



Now we specify that the chart rows should be grouped by server





Drag and hide the first 2 columns




Change the outline of the table to be white




After you run the report you should now see a chart for each server and that is the end of this simple example



Leave a Reply