Single Default Value for all blank fields

[Former Member]

Does anyone know how I could get a single default value (Example: INCOMPLETE) for all blank fields?

[former_member205840]

Hi Jared,

If you want to see 'INCOMPLETE' for all blank fields then you may have to write a formula for all fields and insert formulas in your report instead of direct fields.

As suggested by Mustafa, you may have to create formulas for each field.

-Sastry

[Former Member]

Hi Jared,

You can try this formula and use it

if isnull(field) or field=''

then 'INCOMPLETE'

else field

or

You can place above formula to the existing field.

Right click on field-- Format field-- Common-- Display String and paste the above formula.

-Mustafa