dynamic columns
I am facing a problem with the SQL reporting Service and also am pretty much new to the reporting service I need to create a yearly report from a table called say tblData. It has rows like [items] [Amount] [Date]. Item1 100 05/2005 Item1 110 06/2005 Item2 200 05/2005 Item2 230 06/2005 Now I want the report like [Items] [First month] [Second month] etc... The data for the first month, second month etc will be the [amount] for that month. ie the report rows should be like [item] [05/2005] [06/2005] item 1 100 110 item 2 200 230 In the report the month columns will be dynamic according to the data in the tblData table... Now how should I implement this? First I though of writing up a Stored Procedure so that the sp returns the formatted data (i.e. a returning a table having the having the dynamic columns). But how can I create the report using these dynamic columns in the reporting service?
October 26th, 2012 12:11pm

For that you use a matrix, not a table. Check this: Adding a Matrix (Reporting Services) Add the Item column on the Rows cell.Add the Month column on the Column cell.Add the Value column on the Data cell.
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2012 12:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics