Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • Last Modified:

SSRS 2008 Parameters with multi value

Hi guys. I'm trying to create a report in BIDS with SSRS 2008 that prompts the user for a location, the user can only choose one of three locations, but at the same time each choice has multiple values assigned to it.

The SQL query has this:

WHERE (LOC_ID IN (@Location))

Open in new window


I setup the report parameters as follows:
 
 Those are the labels and values assigned to eachLike that it doesn't work. But if i assign only 1 value to each label, it works fine.
And I also tried with quotation marks, (ex. '22', '23') and still doesn't work.



0
ovoehlers
Asked:
ovoehlers
  • 2
1 Solution
 
ralmadaCommented:
try
select * from yourtable
where (',' + @location + ',') like '%,' + LOC_ID + ',%'

Open in new window

0
 
ralmadaCommented:
so just to clarify the above will work for a variable @location without quotation marks.
0
 
ovoehlersAuthor Commented:
That did it, thanks for your help.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now