Crystal Reports-How to display nulls as zero
Posted on 2009-05-01
Here's another one for the Crystal gurus. I am not really familiar with using formulas on the "Format field" page. I have the following issue:
I am performing a summary on a detail record amount field , displaying the summary field on the report. For some reason, if there are no detail records or the amount fields are null, the summary shows up on the report as blanks (or null?). I have the selector set to "show zero value as 0." However, i don't know how to get it to show a blank or null value as zero (which is a requirement.