report

[Rashid]

Respected sir,
in my db there is a form "order entry"

there Qty & unit charge fields are set to default value of "0", So automatic calculation done properly. but when i get report of this record there i also find "0" values. but the client want that in invoice report the empty fields must be blank. how can we remove the default value in our reports.

 

[Ranman256]

change the report query to filter them out.
where [Qty]>0

 

[arnelgp]

add Format Property to Qty textbox:

#;-#;""

 

[mike60smart]

Respected sir,
in my db there is a form "order entry" View attachment 92113
there Qty & unit charge fields are set to default value of "0", So automatic calculation done properly. but when i get report of this record there i also find "0" values. but the client want that in invoice report the empty fields must be blank. how can we remove the default value in our reports.View attachment 92115

Looks like you have hard coded a specific number of records in the Items table ?

Can you upload a screenshot of your Relationships Diagram so we can see the table structures?