Evaluation Functions

[DanHD]

hello

I want to use (learn to understand) the evaluation functions.
In an invoice we’ve on line level the reference number to the sales order . The Invoice is created from multiple sales orders.
In need those reference numbers singular printed in the header of the invoice.
In the line reference some references are multiple. So when I use in an invoice with 3 records on linelevel the formula:
Whileprintingrecords;
Stringvar Ref;
Ref := Ref + ' ' + {Order.Ref};
I get something like this ‘1005, 1008, 1005’ (1x 1008 and 2 x 1005).
In the header I want printed : 1005, 1008 (or I prefer printed under each other).

Is this possible with the evaluation function or another function?

Regards
DanHD



Dan

 

[ianoctdec]

Hello Dan,

Try this to check for duplicates and print them on different lines:

Whileprintingrecords;
Stringvar Ref;
if instr({Order.Ref}, Ref) = 0 then
Ref := Ref + chr(13) + {Order.Ref}
else
Ref

Dana

 

[DanHD]

hi Dana

looks good for the duplicate.
But how do I get this in the header?

regards
Dan

Dan

 

[ianoctdec]

Hi Dan,

This formula only works in the group footer.
To get it in the header, maybe use a subreport to do the concatenation.

Dana