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
