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
AND (r1.raw_billing_number IN ('&Replace(:PIN,",","', '")&'))

Open in new window

HuiShiAsked:
Who is Participating?
 
Chris LuttrellSenior Database ArchitectCommented:
I am asssuming this is in a dynamic query.  You will have to put two singe quoutes each place you need a quout to be in your final string, and it looks like you are missing the opening and closing quotes.  Try:
AND (r1.raw_billing_number IN ('&''''&Replace(:PIN,",","'', ''")&'''))

If your snippete was not part of a dynamic query you will have to do this in either a dynamic query or pass the string :PIN to a function that returns a table and use that instead.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.