Adding static columns to a matrix report? -- sql server reporting services

plandry NO[at]SPAM newsgroups.nospam
12/29/2004 2:51:02 PM

So I'm making a matrix report. It's driving me nuts, frankly. Here's what I
want to do.

__________|Item Code|Description | Column Group ---->
Row Group| | |
------------------------------------------------------
| | |

|
|
\/

I can get it all working, except for the "Description" column. What I have
now is

__________|Item Code| Column Group ---->
Row Group| |
------------------------------------------------------
| |

|
|
\/

Which works fine. I cannot, for the life of me, add another "static" column
for the Description (that does not get repeated with the column group). I
hope this is clear enough for someone to offer me a suggestion, and I hope
posting doesnt mess up the linbreaks... Thanks in advance!

Vinay
12/30/2004 3:03:03 AM

Try this ..

Right click on filed below column group. choose add row.
It will add new column on left. Then delete the cell below the column field.
which will delete added row below but coloum on left will remain as it is.

[quoted text, click to view]

plandry NO[at]SPAM newsgroups.nospam
12/30/2004 6:45:07 AM

That only adds another row below... I think that's how I got the first Item
Code column. It just won't let me add another column, no matter how many rows
I add...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Adding static columns to a matrix report?