Solved

Passing multi-parameter into SSRS 200

Posted on 2009-05-04
1
317 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
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 video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

919 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

16 Experts available now in Live!

Get 1:1 Help Now