Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

parameter with multiple values-paginated report

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

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support

    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