Field to show zero

[mnmdesigns]

Sorry this might be a very simple question but had to ask. I have data field in the details section. Sometimes if there is no data in that field it shows up blank in the preview mode. I would like to replace the blank value with a zero. How can I do this?

CR 8.5

Thanks in advance,

MD

 

[synapsevampire]

You haev various means to accomplish this:

File->Reort Options-?Select Convert Null Values to Default (this does it throughout the report, but you can no longer test for null)

or

Right click the field and select format field->number->customize->Show Zero Values as 0

and

Make sure that you don't have Suppress if Zero selected.

-k

 

[mnmdesigns]

Thanks a lot for your help.