Cross-Tab alternate row colors
I have a cross tab report that the users are requesting the rows be alternately colored for ease of viewing. Does anyone have a method for doing this in crystal XI?
Graham Cunningham replied
Ray,
If you are using a CR version prior to 2008 then you can set up a counter formula in the background colour of the summarized cells and base the color on the counter value.
For example;
numbervar x:= x + 1;
if remainder(x, 2) = 0 then crlime else cryellow.
You will need to reset the counter in the column total summary and you can nest this in a conditional suppression formula.
numbervar x:= 0;
false
In CR2008 you can reference the CurrentRowIndex function instead of creating a counter but the background color formula would be similar.
if remainder(CurrentRowIndex, 2) = 0 then crlime else cryellow.