In addition what Craig said:
1. Click on the field and choose Format Field
2. Select Number
3. Click on Customize
4. Select Supress if Zero
I don't know if that works on previous version of CR. I have only CR 9.2
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.