I've set a few criteria in optional field in Order Entry module, user will insert their data to each of the created optional field, now how can i show Optional Field data which have a few lines to reporting? It should showing all Order Confirmation although the optional field is empty. I've tried using Select Expert - Record but it show nothing.
Here's my code:
IF {OEORDHO.OPTFIELD} = 'OLDCUSTOMER' THEN
{@oldcust} = {OEORDHO.VALUE}
ELSE
{@oldcust} = ''
The module i use is Order Entry, using report from Order Confirmation.