J Jan Sundell New member Local time Today, 05:44 Joined Mar 20, 2015 Messages 7 Nov 13, 2015 #1 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?
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?
pbaldy Wino Moderator Staff member Local time Yesterday, 20:44 Joined Aug 30, 2003 Messages 36,274 Nov 13, 2015 #2 Typically you would exclude them in the source query. Failing that, you could put code in the detail format event to hide those records.
Typically you would exclude them in the source query. Failing that, you could put code in the detail format event to hide those records.
J Jan Sundell New member Local time Today, 05:44 Joined Mar 20, 2015 Messages 7 Nov 13, 2015 #3 Thank you for the answer, but what kind of code in the detail format event to hide those records do you refer to?
Thank you for the answer, but what kind of code in the detail format event to hide those records do you refer to?
pbaldy Wino Moderator Staff member Local time Yesterday, 20:44 Joined Aug 30, 2003 Messages 36,274 Nov 13, 2015 #4 You'd test your fields and set the detail section's visibility: Me.Detail.Visible = False
J Jan Sundell New member Local time Today, 05:44 Joined Mar 20, 2015 Messages 7 Nov 13, 2015 #5 Thank you, I will try that.
pbaldy Wino Moderator Staff member Local time Yesterday, 20:44 Joined Aug 30, 2003 Messages 36,274 Nov 13, 2015 #6 No problem. Don't forget an Else clause; you want to set the visibility either way.