Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question