Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Evaluation Functions

Status
Not open for further replies.

DanHD

Technical User
Dec 1, 2008
98
NL
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
 
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
 
hi Dana

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

regards
Dan

Dan
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top