Solved

Passing multi-parameter into SSRS 200

Posted on 2009-05-04
1
316 Views
Last Modified: 2012-05-06
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

0
Comment
Question by:HuiShi
1 Comment
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
Comment Utility
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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now