Hi, I have a problem that is driving me mad. I am trying to create a report in BIDS that pulls data from oracle database and generates the report of call it sales by month. What I'm attempting to do is to create a parameter in BIDS and force
a comma separated value into it and then pass that value into SQL statement for an oracle dataset in other words.
BIDS: Parameter @QTR Paramater label QTR1 Paramter value ('01','02','03')
Parameter @Year Parameter label Year Parameter value 2010
Oracle side: select * from ....
where year=:Year and
month in :QTR
Whenever I try to run it like that the report generates but it's blank. Replacing value in QTR parameter with a single non quoted value like 01 generates report perfectly fine. Could anyone shed some light as to how properly specify comma delimited
strings to be used in :in: statements.
View Complete Post