Show or hide discount caption based on an expression

Hornsyld

Hi there,

I am new to new to navision, but i was wondering why it is not default that when you print a report and you have lines without any discount that it still will write the caption. Then the customer is wondering why he didnt get discount.

I have made this on a invoice report myself, but i am not sure its the correct way.
I go into properties of report at the caption - select visibillity and the select show or hide based on expression and write this expression:

=IIf(Fields!Discount_SalesInvLine.Value <= 0, TRUE, FALSE)

Thanks in advance

mohana_cse06

your solution is right but it is a standard behaviour for now and we can customize as we want..

Hornsyld

The solution dosn't seems to work.
Can i be sure that my solution loop tough every sales line and if 1 of them contain a sales it show caption otherwise it hide caption or does it takes the total value of all the lines and check if discount is <= 0 ?

mohana_cse06

Then you have to loop through all the records and assign to a Boolean field and use that Boolean field in visible condition.

Belias

Is your caption in the header of the lines? if so, you can aggregate as a sum the discount (negative discounts cannot exist in a real world, afaik).
in other words...
=IIF(SUM(Mydiscountfield.Value) <= 0)