show quotes as sting if no value 1

[Bloke152]

Crystal 2008

HI ,
Im trying to export a report as csv but currently nulls show as simply that, nulls. I want to have a formula field that will replace the field in the section to force the report to show "" istead of nulls.

The issue has arisen since we have upgraded from CR9 to 2008. CR9 would export nulls in csv as "" but now after upgrading we have found out that CR2008 will not.

I attempted this so far in the following ways with no joy...
I have created a formula field for each field and made it output '"' + {Command.Field} + '"'. still if the field is a null crystal will show nothing.

I have also tried doing the same in the command in various ways but crystal recognises there is no value there.

Is there anyway to make crystal show a null as ""?

Thanks for the help

 

[lbass]

Have you gone into file->report options and checked "convert nulls to default values"?

-LB

 

[Bloke152]

No, I hadnt. That was the solution. Thanks!