SQL pivot values to line chart - SSRS 2008 R2

Question

I have SQL pivot, which works fine.. giving me report as below (demo figures)

 Receipts   Jan   Feb   Mar    Apr   May... Dec
 Cash-Rcpt  100   300   150    240   150
 CC-Rcpt    200   400   650    440   250
 Chq-Rcpt   300   100   950    840   350

Now i would like to create line chart beneath the same report, i'm not able to get receipts at y axis, months at x axis and values as lines

@Jonnus thanks a lot for the reply, as its a SQL pivot, the data fields are appearing to me as below image

Jonnus Jonnus · Accepted Answer · 2015-11-03T09:34:44

While it's not clear what you mean by "receipts at y axis" is this the desired layout for your data?

This can be achieved by setting up the chart as follows.

If this the desired output, and you need further assistance, leave a comment and I can expand...

SQL pivot values to line chart - SSRS 2008 R2

1 Answers