Adding static columns to the right side of a Matrix report -- sql server reporting services

dfateman NO[at]SPAM gmail.com
6/7/2007 12:29:02 PM

Hi all,
I'm trying to figure out how to add static columns to a matrix report
in reporting services 2005. i have a matrix where the columns can be
dynamic (1 to n columns) and in addition to the row columns on the far
left i also need to place columns on the right as well. So it would
look like this:

matrixcol1 matrixcol2 staticcol1, staticcoln....
row 1 # # label1 label_2_1
row 2 # # label2 label_2_2

I got the report to display the data by embedding a matrix in a list
but for each row the columns for the matrix do not line up as
matrixco1, 2.. is different for each row. -THanks!

EMartinez
6/8/2007 6:37:09 PM

[quoted text, click to view]

I normally handle this by placing an empty space in front of the
columns I want to appear first (on the left) in the matrix (i.e., (" "
+ ColumnNameToBePivoted)) and then have the columns I want at the end
(on the right) just be their regular names. That way, alphabetically,
the spaced columns will come first. Of course, you will want to do
this in the stored procedure/query that is sourcing the report. Hope
this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

sql server reporting services : Adding static columns to the right side of a Matrix report