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.

---

Friend - the Israeli portal for adopting pets
פרנד - הפורטל הישראלי לאימוץ בעלי חיים
http://www.friend.co.il

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 fix (like in excel) so they will stay visible even if I scroll left or right.

Thanks.

---

Friend - the Israeli portal for adopting pets
פרנד - הפורטל הישראלי לאימוץ בעלי חיים
http://www.friend.co.il