Hi,
I was wondering if anyone can assist me with this. I’m trying to alternating background colors in my crosstab. I tried everything and it simply does not work. I might be missing something… I’m working on Crystal Reports XI R2.
The attachment document would be my ideal crosstab.
Please help!!!
idealcrosstab.doc (29.0 KB)
btchavez (BOB member since 2008-07-09)
Your question was novel to me, so I have toyed with the idea.
I could NOT find a solution to turn the complete background grey like your example, but I could get the following to work …
Right-click on one of the values in the row label, select Format Field, click the Border tab, click the conditional formatting button to the right of Background and enter the following formula:
IF Remainder (CurrentRowIndex, 2) <> 0
THEN Color (200, 200, 200)
ELSE crNoColor
You would need to copy this formula to one of the values in the columns and Total column.
Perhaps with this idea, someone else can take it the rest of the way and show both of us how to apply the concept to the whole row instead of the objects within the row.
Chamsin 
(BOB member since 2008-06-05)