SAP Knowledge Base Article - Public

1543378 - How to change the color on the Group Header alternately in Crystal Reports.


How to change the color of group header alternately.


  • Crystal Reports XI R2
  • Crystal Reports 2008


1. Create a formula that will count the Group Header in the following way:

         Formula name: Count of Group Header


         numberVar cnt;

         cnt := cnt + 1;


2. Place this formula "@Count of Group Header" in the Group Header. The above formula will work as a counter. 

3. Create a formula for getting the alternate color change on Group Header in the following way:

         a) On the  Report menu, click  Section Expert .

         b) Then select the  Group Header where you have placed the formula "@Count of Group Header" and click the  Color Tab.

         c) Select the  Background Color check box and then click the  X+2 button, Use the following formula in the Formula Workshop.

                 iif (Remainder({@Count of Group Header}, 2) = 0, crAqua, crRed)

         d) Click the "Save and Close" button and then click "OK" to close the Section Expert.


Group header, color change, Alternate color change. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


Crystal Reports 2008 V0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports XI R2