I have data like this in crosstab report, it is grouped by employee I need to do color formatting for employees alternatively say for instance all the rows for john should be coded as silver, roberts should be plain and ram should be silver again like that

Employee      data

             HOurs
             Variance
Jhon        Percentage
             Totals

Robert       HOurs
             Variance
             Percentage
             Totals


Ram          HOurs
             Variance
             Percentage
             Totals

I used this formula to do color format for employee name but not sure who to do for the entire row

format field>border> background x-2
IF Remainder (CurrentRowIndex, 2) <> 0
THEN crSilver
ELSE crNoColor

Edited by achandana01 - 27 May 2015 at 11:00am