I want to create a report rule expression to use the customer ref field for an invoice, and to use the name regardless of if the user has entered this in upper or lower case.
I have created the expression = UPPER([@CUSTOMER_ORDER_IVC_REP/CUST_REF])
Testing if this works how I expect it to it does not work how I would expect. It works in PL SQL, so I now suspect it is not available in the report rule expressions. I have seen the report rule is not being used in the report rule log.
Does the upper function work on report rule expressions?
Thanks
Darren