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='n@REPORT-VALUE{PRE_INVOICE_NO}]']