It would depend. If you want nulls instead of 0s meaning you would have blank lines in your report, try my suggestion. If you want the 0s to just not show up so the report would look nicer, use your way.
If your field really is null, then when you place it on the report, it will not show a zero--unless you have checked "convert nulls to default values" in file->report options.
Go to File -> Report Options -> Uncheck 'Convert Database NULL values to default'
This should solve your problem of getting 0's when the field is left blank
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.