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?

   

- Advertisement -