Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Advice is what we ask for when we already know the answer but wish we didn't
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Create a Banded Cross Tab in Crystal Reports 2008?

Last week a client asked "How do I create a banded effect on a cross-tab, in Crystal Reports 2008, to make the data easier to read?"

The solution to this is to use conditional formatting and the crosstab function CurrentRowIndex:

  1. Create the cross-tab

  2. Right click on the Row Heading Label

  3. Select the Format field menu option

  4. In the Format Editor dialog box, click on the Border Tab

  5. Press the Conditional Format button [x+2] button for the Color - Backgroud option

  6. In the Formula Workshop enter the following formula:

    if Remainder(CurrentRowIndex,2) =0 then 
    Color (189,234 , 149)

  7. Press the [Save & Close] button

  8. Press the OK button of the Format Editor dialog box

  9. Repeat steps 3 - 8, for the Summarised Area and Row Heading Total fields


Name *

Email Address *

Comment *

To prove you are human what is:

92 + 73 =