Post reply

Alternate line formatting on matrix style reports

  • December 5, 2012 at 5:54 am

    #271566

    Hi,

    We have a standard formatting on table style reports which alternates the background colour of each row between grey and white using an expression (see attached image). 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)?

    Many thanks,

    jag7777777

  • December 5, 2012 at 4:59 pm

    #1565969

    Can you post the expression you have used and the new result how it looks lik for better understanding

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • December 6, 2012 at 2:26 am

    #1566053

    Thanks for your reply.

    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 🙂

    jag7777777

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply