Omitting lines in a report

[Jan Sundell]

Is there a way of omitting both label and the data itself if the value of it is e.g. zero? I would like to print invoices, but if the rebate value or the transport cost is zero, that line in the invoice should not appear in the report.

 

[sxschech]

If it is an entire line, couldn't you put that criteria in the query the report uses to exclude it? If it is a field on the report then you could use iif statements in the control source of the textbox to evaluate the the value and hide the text boxes.

=iif(rebate=0,"",rebate)

 

[Jan Sundell]

Thank you, will try that.

 

[CJ_London]

or in the report section on format event

me.rebate.visible=me.rebate<>0

if the label is associated with the control then that will also be hidden/visible

 

[Jan Sundell]

I'm very inexperienced, so your answer makes me a little confused.
The line in the invoice to which I refer looks like this:
"Rebate" =[Rebate] "%" "Reduction" =[Rebate]*[Sum Costs]
Where shall I place this logical sentence, and will the whole line disappear if it is zero?