Alternate row color within a group RRS feed

  • Question

  • Hello All,

    I'm creating a report using VS2010 and will like to know how I can start every group with the color green and then alternate the details within the group with Transparent.

    I have tried this:

    =IIF(RunningValue(Fields!Lot.Value, COUNTDISTINCT, NOTHING) Mod 2 = 1
    ,=IIF(RowNumber(Nothing) Mod 2 = 1, "Green", "Transparent")
    ,=IIF(RowNumber(Nothing) Mod 2 = 0, "Transparent", "Green"))

    But this makes some groups start with Transparent.

    Your input is appreciated.

    Thank you,


    Tuesday, October 30, 2012 8:55 PM


  • For those that are interested.  The solution to my problem was simply to scope my RowNumber() function to the group name I was Interested in.

    =IIF(RowNumber("GroupName") Mod 2 = 1, "Green", "Transparent")

    This code accomplish starting all my groups with green and then if there were multiple entries withing the group they would alternate color.

    Thank you,


    • Marked as answer by JFercan Wednesday, October 31, 2012 2:41 PM
    Wednesday, October 31, 2012 2:41 PM