Search code examples
mysqlreporting-servicesssrs-2012linegraph

SSRS Graphing multiple lines using each column from database as x-axis


I can seem to figure out what how to set up a way to graph the following table into a graph with multiple lines. I have the following table:

screenshot of table

I would like each row of the SRReportName be a different line and each column from ProcessingMinsYesterday and the rest (not SRReportName column) to be an value in the X-axis and the Y-axis to be that numerical value within the tables. So it would look like this:

Screenshot of intended graph


Solution

  • You can represent each report by a line in the chart, just add SSRSReportName to the Series pane. However to get the desired x-axis you have to unpivot your ProcessingMins columns from the query.