CODEWITHSUNDEEP
sql-server-2008reporting-servicesssrs-2008
Saifuddin
Saifuddin

Reputation: 99

SQL pivot values to line chart - SSRS 2008 R2

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 monthly collection report design pane

Upvotes: 2

Views: 422

Answers (1)

Jonnus
Jonnus

Reputation: 3038

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

enter image description here

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

enter image description here

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

Upvotes: 1

Related Questions