Switch columns and rows in SSRS
Hi, I have a report with static columns that looks something like this: ------------------------------------------------------------------------------------------------- Date Column 1 Column2 … Column30 ------------------------------------------------------------------------------------------------- December 1 xxx xxx … xxx December 2 xxx xxx … xxx . . . December 31 xxx xxx … xxx ------------------------------------------------------------------------------------------------- It is based on SP that produces a temporary table exactly the same way as the report output (my Dec 1 to 31 rows are details that are precalculated within SP). I need to switch columns and rows as my report is getting too wide. Does anyone know how it is done in SSRS 2005 (with SQL 2005 data source) without re-writing my SP? Thank you in advance!
October 14th, 2010 10:16pm

You just have to change it in the layout of the report. In the layout, you will have a tablix. Simply switch the rows and columns (means all the values that you had in the rows should be in the columns and all the values in the columns need to be in the rows, the value in the data cell can be the same) and you should be fineCheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
October 14th, 2010 10:22pm

Thank you for your reply Jason. Unfortunately I do not have tablix within SSRS 2005; I only have matrix and table. For the original report I am using table as it displays data exactly the way it is passed from the SP. You cannot switch columns and rows within the table. I tried matrix, but it didn’t work either… Is there any work around that you know of? Thanks again! Lana
October 15th, 2010 11:54pm

Hi Lana, In my mind, you might have double posted this question. To switch rows and columns in reporting services, we should use matrix. In the matrix, you can choose any naming columns as rows or columns, it is just like the Pivot procedurce by T-SQL. Hope this helpfully, thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2010 6:21am

Thank you Jerry
October 20th, 2010 6:55pm

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

Other recent topics Other recent topics