[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SSRS Parameters

Posted on 2013-01-25
4
Medium Priority
?
310 Views
Last Modified: 2013-01-25
I have a report that show "All" data

I want to add two comboboxes

Exch one will filter on distint values in a column

For example...
The report may have 1000 records, but only three distinct usernames

I want a combobox that has a blank for all, and then the three distinct users.
On select of a user, the report is filtered.
0
Comment
Question by:lrbrister
[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
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:liija
ID: 38819813
...so you should use the switch 'Allow multiple values' behind the parameter.
That switch will allow you to choose all the usernames when needed on the report.

Is that what you are after?
0
 

Author Comment

by:lrbrister
ID: 38820085
liija
How do I do that
0
 
LVL 6

Accepted Solution

by:
liija earned 2000 total points
ID: 38820163
Here is one step-by-step example:
http://www.wiseowl.co.uk/blog/s187/multivalue-reporting-services.htm

You need two datasets, one for the parameter and one for the main report.
At the end the author adds filter to the tablix. You shouldn't do that - if your data is more than a few hundred rows.
Instead, add WHERE-clause to your main dataset:
WHERE user in (@User)

Open in new window


It would also be better if you found user names and id's somewhere else than transactions (users-table?) for the parameter. Then filter the report query with user_id's.
0
 

Author Closing Comment

by:lrbrister
ID: 38820231
Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

650 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