Displaying default text when no data available

[ajxmas]

Hi, I am using Crystal XI with Oracle DB

I have a DB field on the report that I want to put 'N/A' if it doesn't exist. This field comes from a secondary table that is linked to the primary table. So it only contains data when there is a match to the primary table.
The report shows blanks when there is no data in that table. But I want my report to look like this:

DATE ID AMT CLASS SER #
7/22/09 DEVICE001 $2.00 Full Fare 0021100
7/23/09 DEVICE044 $5.00 N/A 3429871
7/24/09 DEVICE123 $1.50 Senior 0021384

I have tried using the Display String formula under the Format Editor for setting up the default text.

I tried using (if CurrentFieldValue = ' '....) no luck
I tried using (if CurrentFieldvalue is null....) no luck

The field is defined as VARCHAR2(15). So should'nt checking for blank work?

Any other suggestions?

 

[IanWaterman]

Create a formula

@Class

If isnull(yourclassfield) then 'N/A' else yourclassfield

Ian

 

[ajxmas]

That worked perfectly!! Thanks.