Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Challenge yourself. Aim high
 
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!!!!

14
April

How Do I Create a Conditionally Formatted Cross Tab in Crystal Reports?

Last week a client asked "How Do I Create a Conditionally Formatted Cross Tab in Crystal Reports?"

Solution:

  1. Create the cross-tab

  2. Right click on the Summarised Area Field of the cross tab

  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 - Background option

  6. In the Formula Workshop enter the following formula:

    If CurrentFieldValue > 10000 then CrLime else CrNoColor

  7. Press the [Save & Close] button

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


If you have any questions, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *