How to have zeros on a report instead of blanks?

SOLVED

I have a custom report that was made prior to me starting with the company that is a job cost report that shows the original estimate on it as well.  This report was made in report designer.  The owner would like it to have zeros instead of blanks in the spaces and I am not able to figure out how to do this.  Does anyone know if I am missing a setting on the report or what?  Thank you.

Parents
  • 0
    verified answer

    To print zeros instead of a blank field:  Open the design in Report Designer. Select the field in the design. With the field selected, in the Menu bar click FORMAT > FIELD and uncheck the box "Leave blank if zero."  

    Art MInds
    Independent Senior Consultant
    Pasadena CA 

Reply
  • 0
    verified answer

    To print zeros instead of a blank field:  Open the design in Report Designer. Select the field in the design. With the field selected, in the Menu bar click FORMAT > FIELD and uncheck the box "Leave blank if zero."  

    Art MInds
    Independent Senior Consultant
    Pasadena CA 

Children