|
Frans
Starting Member
Netherlands
2 Posts |
 Posted - 03/15/2013 : 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?
|
|
Use Oracle parameter in SSRS 2008 r2
