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
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