Forum Discussion

Anthony_C1555's avatar
Anthony_C1555
Copper Contributor
Sep 20, 2023

Create A Series Chart On An SSRS Report

Hello Forum

 

I am struggling to create a "Series Chart on an SSRS Report.

 

The data contains space used and available free space for all Databases on our estate.  

 

ServerNameDateLoggedDBNameDBFileNameCurrentSizeMBFreeSpaceMB
SERVER121/08/2023DB1DbFile146683212662233.25

 

The Report returns stats for the past thirty days.

What I would like to do is to present a series of line charts containing the stats, one Chart per database, so that the Horizontal axis shows the Date and the vertical axis the size.

 

Many Thanks

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Sep 21, 2023

     

    Anthony_C1555 wrote:
    one Chart per database

    Anthony_C1555 , create a data set with the database names, add a Tablix to the report for the databases, insert a chart into a Tablix cell and filter the data for the Chart on the row - database name.

Resources