My request for the country name to be able to be displayed on documents has been accepted. I would really appreciate you all voting for it.
KB 2220536
Many thanks,
Sue
Can you please elaborate what you mean by that. Whose country name and why ?
How do I access the KB 2220536 ?
Sue,
So what you require is technical access to this table for the pruposes of forms/report design changes, so you can use standard forms/report methodogy to populate a Country description where required, in same fashion as using Region/Territory/Customer type and other tables like this.
Yes I would support that. Never new it was not avaialble.
Charles
That's exactly it rather than trying to Stack if statements
You could try the following on the layout but caveat emptor, please satisfy yourself in testing (and with batch processing, multiple prints in a row, reprints etc) that it works!
In the report header put an expression:
iif(!used("vcntry"), iif(sqopen("S", "vcntry"), "", ""), "")
Then in the detail band:
iif(used("vcntry") and seek(it_cntorig, "vcntry", "vcntry1"),vcntry.vt_desc, "")
