Populate a null fields with a ***Empty*** placeholder in CSV

building reports crystal reports
1

I am exporting a Crystal Report to a CSV text file. Some of the fields are blank. Is it possible to populate these blank fields with a Empty placeholder?

Thanks!

Blowers (BOB member since 2009-09-30)

2

Hi,

You can create a formula and use it in the report. The formula will be something like:

if isnull(fieldName) or Fieldname=’’ then
********
else
FieldName

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)

3

Great i’ll try that
Thanks!

Blowers (BOB member since 2009-09-30)