Solved

SSRS Report Allow multiple on showing 1st selection results

Posted on 2014-12-09
1
76 Views
Last Modified: 2015-06-08
I have a Parameter setup to look for Return Types.  The parameter is looking at a query for the results and I have allow multiples selected but it only shows the results from the first selection.  What am I doing wrong?
0
Comment
Question by:sharris_glascol
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40490825
Far too little information provided for me to assist.

The best thing I can do this is this - creating a multivalued parameter may require more than only clicking the "Allow multiple values" box.

It may be as simple as changing the SQL from "WHERE MyProduct = @MyProductID" to "WHERE MyProduct in (@MyProductID)"; but it may be more.

I can recommend the book "SQL Server 2012 Reporting Services Blueprints" - chapter 1 talks about multivalued and cascading parameters, and how to parse them.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 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