Adding static columns to the right side of a Matrix report

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!On Jun 7, 2:29 pm, dfate...@.gmail.com wrote:
> 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!
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