Hi
I have a fully functioning report which uses dynamic parameters for Account identifiers and date ranges passed into an SQL command that retrieves data from a table based upon these param values.
At the momentg, the Account identifier parameter is a single value - a request has come through to allow users to multi select account values such that the SQL command becomes .... Where account_id in ('xxx','yyy') - the user is not able to select 'yyy' as the dynamic param only allows one value to be selected and passed into the query.
I want the user to be able to pass in more than one value for the param '{?Portfolio}'
Here is the command as it stands now
SELECT A.A_EXTACCID as Ext_Port_ref, I.A_INSID, ISNULL(I.A_ISICDE,'N/A') as ISIN, ISNULL(I.A_SEDCDE,'N/A') as SEDOL, ISNULL(I.A_BBCDE,'N/A') as BBG, A.A_ACCID, CASE E.A_TRDSDE WHEN 'B' THEN 'BUY' WHEN 'S' THEN 'SELL' END AS TRDSDE, ISNULL(C.A_CTRPTYID,'N/A') as Broker, SUBSTRING(E.A_TRDDTE,0, 9) AS TRADEDATE, ISNULL (SUBSTRING(E.A_STTDTE,0, 9),'N/A') AS STTDTE, SUBSTRING(E.A_ADDDTETME,9, 4) AS ADDTME, E.A_QTY, E.A_STTCCYCDE, ISNULL(I.A_PRCFAC,1) as pr_fact, (E.A_PRC * I.A_PRCFAC) as Dealt_price, E.A_NETCSD, E.A_CMSAMT, CASE E.A_TRDSDE WHEN 'S' THEN (E.A_NETCSD / E.A_QTY) WHEN 'B' THEN (E.A_NETCSD / E.A_QTY) END AS NETPRC, E.A_INSNAM, ISNULL(E.A_GIVUP, 'N') AS IS_CFD, CASE ISNULL(E.A_GIVUP,'N') WHEN 'Y' THEN 'ML' WHEN 'N' THEN 'N/A' END AS GIVEUP, ISNULL(I.A_RICCDE, 'N/A') as RIC, ISNULL(E.A_LCLFEE,0) AS LOCAL_FEE, ISNULL(E.A_LCLTAX,0) AS LOCAL_TAX, SUBSTRING(E.A_ADDDTETME,0, 9) AS INPUT_DATE FROM T_ATH_EXE E JOIN T_ATH_ACC A ON E.A_ACCID = A.A_ACCID JOIN T_ATH_CTRPTY C ON C.A_CTRPTYID = E.A_CTRPTYID JOIN T_ATH_INS I ON I.A_INSID = E.A_INSID WHERE cast((substring(E.A_ADDDTETME, 5, 2) + '/' + substring(E.A_ADDDTETME, 7, 2) + '/' + left(E.A_ADDDTETME, 4)) as datetime) BETWEEN {?startDate} AND {?endDate} AND E.A_SYCSTA = 3 AND E.A_EXETPE = 'M' AND A.A_ACCID = '{?Portfolio}'
|