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

Posted on 2011-10-06
Last Modified: 2012-05-12
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?
Question by:bax2000
    LVL 11

    Expert Comment

    by:Simone B
    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.

    Author Comment

    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.
    LVL 11

    Expert Comment

    by:Simone B
    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.

    Author Comment

    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?
    LVL 11

    Accepted Solution

    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.

    Author Closing Comment

    Just what I was looking for!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Suggested Solutions

    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…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 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

    17 Experts available now in Live!

    Get 1:1 Help Now