Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Passing multi-parameter into SSRS 200

Posted on 2009-05-04
1
Medium Priority
?
324 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 2000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

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. …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

618 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