question

Tony avatar image
Tony asked

Matrix Background Formatting

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?

ssrsformatting
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Paul avatar image
Paul answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image
Rob Farley answered

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

=IIF(InScope("matrix1_group1"),"Blue","Red")
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tony avatar image
Tony answered

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

Thanks

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.