Search code examples
reporting-servicesssrs-2008linechart

SSRS: How to add data table on x-axis?


SSRS : I am trying to create a graph which can have a data-Table on X-axis. how can i achieve this below graph? any idea ?

image is showing the data. i want Values on Y-Axis and X-axis should contain multiple rows.

image is showing the data. i want Values on Y-Axis and X-axis should contain multiple rows.


Solution

  • No, you can't put a table in axis. But there is walk-around. create a chart with dates on x axis, then a table (matrix) immediately below the chart, you have to experiment with the width of the column group (where dates sit) and location of the table so that the dates column in the table align with the dates in the x axis. And then you can hide the dates in the table, so that the report looks like the picture shown. The chart and the table cab be generated from the same of different data sets (depending on your business rule).