1768272 - How to change color of every-other column and row of a cross-tab

• Crystal Reports 2008
• Crystal Reports 2011

1. Right-click the Row > Format field > Border tab > Click on the formula button beside 'Background' and use the following formula:

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

2. 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. 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)) 

• The above formulas will only shade the 'cell' and not the entire text field of the crosstab
•  

colour colum shade shading , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To