sql server reporting services: I have a matrix and would like to be able to add to the column titles
the column number. I have been looking for a function maybe similar
to the rownumber() function, but cannot locate anything for column
number. Is this a possibility?

Thanks!

On Jun 26, 6:42 pm, Just Another Reporter <Crystal.War...@gmail.com>
[quoted text, click to view]


The best way to add this functionality is to add an extra column to
your dataset (query/stored procedure results) giving the column rank
(so to speak). If there are a manageable number of column values to
pivot, you can use case statements in the query/stored procedure to
assign the column rank value. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant