Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Use Oracle parameter in SSRS 2008 r2

Author  Topic  Frans Starting Member 4 Posts Posted - 2013-03-15 : 04:08:57 I have a report in SSRS r2 connecting to en oracle database and use the query: SELECT DRS_DESC1 AS OORZAAK_DETAIL, NVL(WIJK_NAAM, 'Overigen') AS WIJK, HM_ID AS NR, to_char(HM_DATECREATE, 'YYYY') | | '_' | | to_char(HM_DATECREATE, 'MM') AS J AARMND, RS_DESC1 AS OORZAAK FROM VMESS WHERE RS_DESC1 IN (:OORZAAK) ORDER BY NR In the map Parameters I made @OORZAAK. Raunning fails with: "Cannot add value query parameter ':OORZAAK' .... because it is not supported by the data extension. What to do to get the parameter working?