Blank lines i a report

Jan Sundell

New member
Local time
Today, 12:11
Joined
Mar 20, 2015
Messages
7
Is there a way to hide whole lines in a report that have values that are zero, e.g. in an invoice if rebate is zero or if freight is zero?
 
Typically you would exclude them in the source query. Failing that, you could put code in the detail format event to hide those records.
 
Thank you for the answer, but what kind of code in the detail format event to hide those records do you refer to?
 
You'd test your fields and set the detail section's visibility:

Me.Detail.Visible = False
 
No problem. Don't forget an Else clause; you want to set the visibility either way.
 

Users who are viewing this thread

Back
Top Bottom