Simply The Best

1) Right-click the Row > Format field > Border tab > Click on the formula button beside ‘Background’ and use this formula:

numbervar row;row := iif(row=1,0,1);iif(row=0,color(197,217,244),color(255,220,255))

2) Next, right-click the Column > Format field > Border tab > Click on the formula button beside ‘Background’ and use this formula:

numbervar col;col := iif(col=1,0,1);iif(col=0,color(197,217,244),color(255,220,255))

3) Then, right-click the Summary Field > Format field > Border tab > Click on the formula button beside ‘Background’ and use this formula:

numbervar sumr;sumr := iif(sumr=1,0,1);iif(sumr=0,color(197,217,244),color(255,220,255))

Please note that the above formulas will only shade the ‘cell’ and not the entire text field of the crosstab. The reason being the cell that you’re referring to is made up of a normal text field and margins on the top, left, right and bottom.

You would need to get rid of the cell margins completely and that is the only way around.

So, right-click the cross-tab in the Preview mode and go to Grid-options > uncheck ‘cell margins’.

Could you change all the formula to:

If Remainder (CurrentRowIndex, 2) <> 0

then color(197,217,244)

else color(255,220,255)

Downloads for SAP Crystal Reports and others