report (1 Viewer)

Rashid

New member
Local time
Today, 03:19
Joined
Sep 6, 2019
Messages
22
Respected sir,
in my db there is a form "order entry"
ordf.PNG

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.
inv1.PNG
 

Ranman256

Well-known member
Local time
Today, 06:19
Joined
Apr 9, 2015
Messages
4,337
change the report query to filter them out.
where [Qty]>0
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:19
Joined
May 7, 2009
Messages
19,169
add Format Property to Qty textbox:

#;-#;""
 

mike60smart

Registered User.
Local time
Today, 10:19
Joined
Aug 6, 2017
Messages
1,899
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?
 

Users who are viewing this thread

Top Bottom