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 Business View Manager , How To