>how can i replace 0.00 with a blank value in my report? for example in my sales report , sales for my canned goods are shown in 500.00 while sales for my bottled goods are shown in 0.00 . I need to have a report where all the products that have 0.00 for their value replaced with blank.

Specify format Blank if Zero and type Numeric.