• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

SQL Server 2008 Reporting Services: Displaying "All Items" in a Parameter list

I have recently started writing reports using SQL 2008 reporting services.
I can write nice reports that use parameters, but can only select a single value.
I am batteling to get an ALL ITEMS selection to work so the users can choose that option and get all the item,  catagories, sales people, etc on one reports.

Does anyone have a good tutorial on the how to do this?
0
bax2000
Asked:
bax2000
  • 3
  • 3
1 Solution
 
Simone BCommented:
In your query's where clause, the syntax for the parameter should be

WHERE fieldname IN (@ParameterName)

In your parameter list, right click on the parameter and select properties. You should have an option there for MultiValue.

This video is pretty good, but it's for 2005. However all of the concepts are the same.

http://www.youtube.com/watch?v=vB9iDurRtRM
0
 
bax2000Author Commented:
Thanks, good video, but I already have that base covered.
Do you have a link to the next video to show how to incoporate and "All" selection in the dropdown?
I can't find that on his YouTube page.
0
 
Simone BCommented:
Have you tried creating the multi-value parameter yet? I've never had to do anything special to get the All or Select All. It should be at the top of your parameter list for any multi-select menu.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
bax2000Author Commented:
I get all my paramter list by using a select * from statement query in a dataset and link that dataset to the parameter. I don't see an All or Select all option .. I can only pick one item in the list at a time.

Can you explain your method to me?
0
 
Simone BCommented:
In SQL 2008, the parameter should show up on the parameter list that is in the dataset window. Right click on the parameter and select Properties. You will see a check box to allow Multiple Values. Make sure it's selected. You will then be able to select more than one parameter, also you should get an All or Select All option at the top of the drop down.
0
 
bax2000Author Commented:
Just what I was looking for!!
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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