We have a standard formatting on table style reports which alternates the background colour of each row between grey and white using an expression. This works fine when it is a standard table tablix. However, when we employ the same expression on matrix tablixes with grouped rows and columns it looks a mess - presumably due to the groups being present.
Has anyone worked out a way of formatting a matrix report that has groups on both the columns and rows - but still prints out with an alternative background colour (i.e. similar to the old white and green computer paper)?
Managed to resolve this last night. I used the following expression in the background colour:
=iif(RunningValue(Cstr(Fields![RowGroupNameHere].Value),CountDistinct,"DatasetName") Mod 2,"LightGrey", "White")
This exploits the CountDistinct across the entire matrix's rows to essentially provide a row counter at each row group on the matrix - which can then be used with the Mod 2 to return either a 1 or a 0. Seems to work really well so thought I'd share for anyone else having the same problem :-)
Alternate line formatting on matrix style reports
Posted - 12/05/2012 : 08:14:26
