Solved

SSRS Report Allow multiple on showing 1st selection results

Posted on 2014-12-09
1
71 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
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. …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

758 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

21 Experts available now in Live!

Get 1:1 Help Now