Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

show quotes as sting if no value 1

Status
Not open for further replies.

Bloke152

Programmer
Aug 9, 2005
123
NO
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
 
Have you gone into file->report options and checked "convert nulls to default values"?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top