HuiShi
asked on
Passing multi-parameter into SSRS 200
Hi there:
I am trying to pass multi parameters into SSRS 2000. After users put a list of values separated by commas, I used the code AND (r1.raw_billing_number IN ('&Replace(:PIN,",","', '")&')) in the query.
However, it did not give me any data back. The db I am running against is Oracle 10g.
Can someone give me some hints?
thanks
Hui
I am trying to pass multi parameters into SSRS 2000. After users put a list of values separated by commas, I used the code AND (r1.raw_billing_number IN ('&Replace(:PIN,",","', '")&')) in the query.
However, it did not give me any data back. The db I am running against is Oracle 10g.
Can someone give me some hints?
thanks
Hui
AND (r1.raw_billing_number IN ('&Replace(:PIN,",","', '")&'))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.