We need to create a tabular report in SSRS that uses data in a pivot query. The column headers in part or all of the table need to be defined when the report is created. Is there a way to do this in SSRS?
Below is an example (sorry for the ugly formatting, I'm in a hurry). The second column is the pivot column and the report needs to have this as column headers. Is this possible with SSRS 2005?
Thanks for any help!
Rob
Data
John | Jan 2011 | 25
Fred | Jan 2011 | 35
John | Feb 2011 | 35
Fred | Feb 2011 | 25
John | Mar 2011 | 45
Fred | Mar 2011 | 60
Report
Person | Jan 2011 | Feb 2011 | Mar 2011
John | 25 | 35 | 45
Fred | 35 | 25 | 60
