I am designing my own Excel Plugin for a report output. I have it running except I need to run a case sql that will set a field to a certain number when a customer is printed. Has anyone been able to pass a report parameter to a sql?
[&SELECT CASE WHEN IDENTITY='VICMEO' THEN '0131' ELSE '0000' END FROM CUST_ORDER_INV_HEAD_UIV_ALL WHERE invoice_no='[@REPORT-VALUE{PRE_INVOICE_NO}]']