parameter with multiple values-paginated report

[Anonymous]

Hi All,

I am connecting Firebird ODBC connection to create a paginated report.

i am unable to set mutiple value parameter in query level. could you please help to below query to enable multiple value seletion in parameter.

WITH CTE_RATING
AS
(SELECT
RATING_DESC,
RATING,
STORE,
CASE WHEN RATING='2' THEN 'YES'
WHEN RATING='3' THEN 'YES'
WHEN RATING='4' THEN 'YES'
WHEN RATING='5' THEN 'YES'
ELSE 'NO' END AS CUST_RATING
FROM RATING_DESC

)

SELECT CH.ACCOUNT AS Account,
CASE WHEN CH.CURMONTHSDUE>=3 AND R.CUST_RATING ='NO' THEN 'YES' ELSE 'NO' END AS "OVER 90"

FROM CONTRACT_HISTORY CH
LEFT JOIN CONTRACTS CT ON CH.CONTRACT=CT.CONTRACT AND 1=1
lEFT JOIN CUSTOMERS C ON CH.ACCOUNT=C.ACCOUNT AND 1=1
LEFT JOIN STOREINITIALS S ON CH.STORE=S.STORE AND 1=1
LEFT JOIN CTE_RATING R ON CH.STORE=R.STORE AND C.RATING=R.RATING
WHERE S.CO_NAME in (?)

Thank you in advance

[v-jingzhang]

Hi @Anonymous 

Do you mean you have a parameter which allows multi-select and hope to pass the multiple selected values to S.CO_NAME in the SQL query?

Best Regards,
Community Support Team _ Jing