Adding a static column to a matrix | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Adding a static column to a matrix

I am using a matrix in RS to cross-tab and produce a report. I need to add a column to the left of the static column that the matrix automatically put in. I can get RS to let me add a column, but it adds it as one big cell instead of a lot of individual cells. I need it to mirror the standard column that RS put in automatically so that I have matching cells between the two columns. The column I want to add will be so that I can just type in some text in each cell to categorize each of the items in the column that is already there.