SAP Knowledge Base Article - Public

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

Symptom

Environment

  • Crystal Reports 2008
  • Crystal Reports 2011

Resolution

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
  •  

 

 

Keywords

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

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011