all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

Fix matrix column and IF-ELSE statement


Fix matrix column and IF-ELSE statement nicknack
11/18/2006 10:57:26 PM
sql server reporting services:
Hello.
I have to questions -
1) I have a matrix in my report and I want The group column to be fix
so if I have a lot of columns and I scroll left the Header column will
stay in the left of the screen and only the result column will be
scrolled.
How can I do it?
2) How can I use a IF-ELSE statment or a CASE in the expression?
I want one of my column to be red if the value is "1", green if the
value is "2" and blue if the value is "3".
Is there a way to do it?

Thanks in advance.
Re: Fix matrix column and IF-ELSE statement nicknack
11/20/2006 3:41:06 AM
Just to let you know that I found a replacment for the if.

I found that there is a switch-case statment in SSRS :)

I still be happy to hear if there is a way to make the first column of
a matrix or table fix (like in excel) so they will stay visible even if
I scroll left or right.

Thanks.

nicknack =EB=FA=E1:
[quoted text, click to view]
Re: Fix matrix column and IF-ELSE statement nicknack
11/20/2006 6:49:11 AM
O=2Ek so I got the answer to this matrix thing too.

After creating a column group you can use (in the "edit group" option)
the "Group header should remain visible when scrolling" and thats what
make the magic happen.

Thanks to andy for the solution :)


take care,

Roy

nicknack =D7=9B=D7=AA=D7=91:
[quoted text, click to view]
AddThis Social Bookmark Button