Matrix Background Formatting

Question

I'm new to SSRS. How do I format the background of the various data levels of a matrix to reflect a different color when a level is expanded or collapsed?

Answer 1

0

Hi Tony, I've usually employed the expression

=iif(RowNumber(Nothing) Mod 2,*Colour1*, *Colour 2*)

to achieve candystriping, so you might be able to introduce this into the InScope() expression to get this to work within the groupings.

answered Oct 24 '09 at 05:11 PM

Paul
36

(comments are locked)

Answer 2

0

Use the InScope function. Basically, you can set the background colour to be something like:

=IIF(InScope("matrix1_group1"),"Blue","Red")

answered Oct 20 '09 at 11:44 PM

Rob Farley
5.7k ● 13 ● 17 ● 19

(comments are locked)

Answer 3

0

Thanks but I need the color to alternate as well. Any ideas on how to make that happen?

Thanks

answered Oct 21 '09 at 02:24 PM

Tony
12 ● 1 ● 1 ● 1

(comments are locked)

Matrix Background Formatting

Follow this question

Related Questions