Been trying to figure out another way of doing this. I have use these two formulas before with no problems, but it doesn't seem to work on this circumstance.
if RecordNumber mod 2>0 then crSilver else nocolor
if RecordNumber Mod 2=0 then crSilver else NoColor
The problem here is I am grouping records this time and it is not shading every other line. The pattern is inconsistant due to it shading the individual records within the group so the groups showing are not shaded correctly. How do I write something to shade every other group instead of record. Thanks
if RecordNumber mod 2>0 then crSilver else nocolor
if RecordNumber Mod 2=0 then crSilver else NoColor
The problem here is I am grouping records this time and it is not shading every other line. The pattern is inconsistant due to it shading the individual records within the group so the groups showing are not shaded correctly. How do I write something to shade every other group instead of record. Thanks
