Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25426 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SSRS: Intro To Parameters

Part of Microsoft Reporting Services Basics

sql SSRS: Intro To ParametersSSRS: Parameters Introduction

With your SSRS report well underway, the next hurdle is ensuring your report is able to change its results depending on the criteria the user wants. You could create a myriad of different reports to offer the user choice but this becomes quite difficult to manage. It is a much better idea to have one report that has the ability to let the user filter the results the way he/she want it. This is accomplished by putting report parameters onto the report.

How to implement parameters in SSRS

For this you will need to amend the SSRS report to handle parameters, more over if you are utilising SQL to obtain the information then a SQL script alteration will also be required.
This video will show you how to create parameters and allowing users to choose from a list of options.This video is one of many SSRS tutorials on this site click here for more.

Example SSRS File

To download the example SSRSproject shown in this video please click here:

Related Posts

658 Comments

  1. kingrich742 says
    06 Feb 13 at 7:36am

    Hi, I hope you can help with a parameter problem I’m having. I have a report in Visual Studio 2008 that uses a single table in MS Access as it’s Datasource. It runs fine as is and pulls data into the report. However, when I try to add parameters no data is pulled through. Any ideas?

  2. evan wilder says
    03 Oct 12 at 8:27pm
  3. chickenmunga says
    03 Oct 12 at 3:26pm

    if your intent isn’t to force the user to either select all cities or just one at a time, there’s an easier way of doing things:
    On the Parameter’s properties, General tab, place a check mark in the ‘Allow multiple values’
    This eliminates the need for the ‘All’ customization.

  4. nince021 says
    05 Jun 12 at 10:14pm

    Fantastic! You make it look so easy! Thank you.

  5. nince021 says
    05 Jun 12 at 10:14pm

    [..YouTube..] Fantastic! You make it look so easy! Thank you.

  6. nince021 says
    05 Jun 12 at 10:14pm

    [..YouTube..] Fantastic! You make it look so easy! Thank you.

  7. clockworkmunkee says
    25 Apr 12 at 6:01pm

    Hi, excellent vid, very good presentation. Quick question – I’m using an excel ssheet as my datasource and am trying to create a parameter report, however i keep getting the following error “error [07002][Microsoft[[ODBC Driver]Too few parameters. Expected 1” – do you know why and how to fix this? thanks

  8. 25 Apr 12 at 6:01pm

    [..YouTube..] Hi, excellent vid, very good presentation. Quick question – I’m using an excel ssheet as my datasource and am trying to create a parameter report, however i keep getting the following error “error [07002][Microsoft[[ODBC Driver]Too few parameters. Expected 1” – do you know why and how to fix this? thanks

  9. PCTeachME says
    26 Jan 12 at 8:02am

    @titusm hi, great news about driver. Welcome to my world regarding conversion ! You can deploy 2005 reports to a 2008 box i believe. But as the so called visual studio “wizard” goes I have not come across any other way other than xml alteration or recreation in 2008 (not to say there isnt a way but I dont know of one). To ease deployment pains have you downloaded “Bids Helper”?

  10. PCTeachME says
    26 Jan 12 at 8:02am

    [..YouTube..] @titusm hi, great news about driver. Welcome to my world regarding conversion ! You can deploy 2005 reports to a 2008 box i believe. But as the so called visual studio “wizard” goes I have not come across any other way other than xml alteration or recreation in 2008 (not to say there isnt a way but I dont know of one). To ease deployment pains have you downloaded “Bids Helper”?

  11. titusm says
    26 Jan 12 at 7:06am

    Hi,
    it was the driver. It is kind of funny thou. For testing purposes i tried to connect via odbc and with odbc bids 2008 can’t work with bind variables – at least from my experience.
    After i connected via tns it works ok with binds.

    Anyways – my problem now is importing the 2005 rdl’s in 2008. Import project does not work. Do you know of any program that does the rdl conversion from 2005 to 2008 (i don’t have time to edit the “xml” version by hand)
    thanks
    Titus

  12. titusm says
    26 Jan 12 at 7:06am

    [..YouTube..] Hi,
    it was the driver. It is kind of funny thou. For testing purposes i tried to connect via odbc and with odbc bids 2008 can’t work with bind variables – at least from my experience.
    After i connected via tns it works ok with binds.

    Anyways – my problem now is importing the 2005 rdl’s in 2008. Import project does not work. Do you know of any program that does the rdl conversion from 2005 to 2008 (i don’t have time to edit the “xml” version by hand)
    thanks
    Titus

  13. titusm says
    26 Jan 12 at 7:06am

    [..YouTube..] @PCTeachME
    Hi,
    it was the driver. It is kind of funny thou. For testing purposes i tried to connect via odbc and with odbc bids 2008 can’t work with bind variables – at least from my experience.
    After i connected via tns it works ok with binds.

    Anyways – my problem now is importing the 2005 rdl’s in 2008. Import project does not work. Do you know of any program that does the rdl conversion from 2005 to 2008 (i don’t have time to edit the “xml” version by hand)
    thanks
    Titus

  14. PCTeachME says
    25 Jan 12 at 1:10pm

    Hi, That is odd! It sound definatley something with the driver (if the same code worked in the past). Is there a conflict with the Oracle TMS driver (I hate those things!)? Can 2008 report work without parameters? Sorry you may have done all these things already but need to start somewhere… If you happen to already worked out the answer please update on here for any other users :)

  15. PCTeachME says
    25 Jan 12 at 1:10pm

    [..YouTube..] Hi, That is odd! It sound definatley something with the driver (if the same code worked in the past). Is there a conflict with the Oracle TMS driver (I hate those things!)? Can 2008 report work without parameters? Sorry you may have done all these things already but need to start somewhere… If you happen to already worked out the answer please update on here for any other users :)

  16. PCTeachME says
    25 Jan 12 at 1:10pm

    [..YouTube..] @titusm Hi, That is odd! It sound definatley something with the driver (if the same code worked in the past). Is there a conflict with the Oracle TMS driver (I hate those things!)? Can 2008 report work without parameters? Sorry you may have done all these things already but need to start somewhere… If you happen to already worked out the answer please update on here for any other users :)

  17. titusm says
    25 Jan 12 at 1:13am

    Hy,
    I have a little question maybe you can help me.
    I use bids 2008 (i worked on 2005 with no problems) with oracle database.
    In 2005 i used to do the dataset parameters using “:parameter”. In 2008 it does not recognize this type of parameter and @ is not recognizes either.
    Do you have any idea which is the new format for oracle parameters?
    thanks

  18. titusm says
    25 Jan 12 at 1:13am

    [..YouTube..] Hy,
    I have a little question maybe you can help me.
    I use bids 2008 (i worked on 2005 with no problems) with oracle database.
    In 2005 i used to do the dataset parameters using “:parameter”. In 2008 it does not recognize this type of parameter and @ is not recognizes either.
    Do you have any idea which is the new format for oracle parameters?
    thanks

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security