• How do I do to each group so one group row doesn't affect the other group?

    I used the following code: = iif (RunningValue( Fields!YourField.Value , CountDistinct, Nothing) mod 2, "White", "Gainsboro") but it continues even outside each group...

    Sol_Web_Solutions (9/10/2007)


    Hello!

    Whenyou're trying to alternate the details, I use the following:

    = iif (rownumber(Nothing) mod 2, "White", "Gainsboro")

    When you're going off a group band, I use this:

    = iif (RunningValue( Fields!YourField.Value , CountDistinct, Nothing) mod 2, "White", "Gainsboro")

    Hope this helps....I ran into the same issue!