Solved

Passing multi-parameter into SSRS 200

Posted on 2009-05-04
1
318 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
ID: 24299964
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SSRS scale out 13 69
SSRS Report error in deployment 5 172
running SQL 2012 SSIS packages in recent versions? 3 91
Supress rows in SSRS table based on Like or Soundex 2 42
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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