alternate background colors by group and details

  • Attach is an example of what I am looking for. Disregard Group 1 as that will be hard-coded with a gray backgroud color. What I need is to alternate the color for Group 2 but also have the details of that group the same color.

  • Looks like you need a Group Number for the group1, RunningValue may help.

    Try following Backgroundcolor expression for both Group2 and Detail Row.

    =IIF( RunningValue(Fields!Group1FieldName.Value, CountDistinct, Nothing) MOD 2, "green","blue")

  • wwei (1/24/2010)


    Looks like you need a Group Number for the group1, RunningValue may help.

    Try following Backgroundcolor expression for both Group2 and Detail Row.

    =IIF( RunningValue(Fields!Group1FieldName.Value, CountDistinct, Nothing) MOD 2, "green","blue")

    I am not exactly sure what i use for Group1FieldName? That is not group 1's actual name right?

  • nm, i used group 2's group on field and it works. in this case it would be values in column C.

    Thank u!

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

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