Group Footer to alternate color

• sol

  SSCrazy

  Points: 2294

  More actions

  November 2, 2005 at 7:48 am

  #152603

  I'm trying to get every other group footer to be a different color, and can't seem to get the distinctcount() function to work.  I also tried the count() function, but that's always giving me 1.

  Any suggestions are welcome!

  Thanks!

• stonemw

  SSC Veteran

  Points: 204

  More actions

  November 3, 2005 at 6:34 am

  #602113

  You can play with this to try to get it to work,

  =iif(RowNumber("table1_Group1") Mod 2, "Green", "Blue")

  The problem I have is if there is only 1 record for the group, then the color will not change.  It is a start and may help.