I have created an excel report and added to Public Reports section for others use. I have used a query like below;
and used the paramter for STATUS like,
SELECT * FROM BUG WHERE BG_STATUS IN ('NEW', 'OPEN', 'CLOSED')
This report is working fine if I pass single status like NEW. But I need to pass multi values like 'NEW', 'OPEN'
SELECT * FROM BUG WHERE BG_STATUS IN (@STATUS@)
Please throw some light to proceed on what need to be done to make it work.