Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Every problem has within it the seeds of its own solution
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 Display the words N/A for Zero Summary Values in a Cross Tab in Crystal Reports 2008?

Over the last couple of Crystal Reports 2008 training sessions a number of delegates have asked the same question,  "How Do I Display the words "N/A" for Zero Summary Values in a Cross Tab?"


There are a number of ways to achieve this but the quickest method is to use the Display String formatting feature of Crystal Reports.

The Display String feature overrides the value that is displayed on the report.

To display the words "N/A" for zero summary values in a cross tab:
  1. Create the cross tab

  2. Right click on the Summary Field

  3. Select the Format Field menu option

  4. Click on the Conditional Format button [X+2] for the Display String option

  5. In the Formula Work Shop enter the following formula:

    If CurrentFieldValue
    = 0
    Then "N/A"
    Else Totext(CurrentFieldValue)

  6. Press the Save and Close button

  7. Press the OK button

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

49 + 7 =