Cross-Tab alternate row colors

[Former Member]

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?

[former_member260594 · Accepted solution]

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.