Display Blank instead of "0"

[f0rg3tfu1]

Hey all,

Quick question, should be pretty easy.

Cr 10, SQL server.

I have a timesheet reports that sums up hours by day and totals them for the week... pretty standard format. I want the report to show up blank spaces instead of "0" for each field where there is no hours.

Is there like a blanket function I can use globally to say that "0" = ""?

Thanks for your help!

 

[BobSuruncle]

Go to FILE menu and choose OPTIONS.
On the FIELDS tab, you'll find a button for each field type. You'll likely want to format both Numbers and Currency.
When you click the appropriate button, you'll get the Format Editor. Click the Number tab and then the Customize button.
You'll see a propery called "Suppress if zero". Select it.

This will cause any new field that you place on the report to take this formatting. Existing fields, however, will need to be modified individually. (or format one of them and use the Format Painter. )



Bob Suruncle

 

[f0rg3tfu1]

Fantastic! Thanks a lot, perfect tip.