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. titusm says
    25 Jan 12 at 1:12am

    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

  2. jamesroddeygarrity says
    08 Dec 11 at 7:53am

    Great Video! Thanks.

  3. 08 Dec 11 at 7:53am

    [..YouTube..] Great Video! Thanks.

  4. 08 Dec 11 at 7:53am

    Great Video! Thanks.

  5. 08 Dec 11 at 7:53am

    Great Video! Thanks.

  6. 08 Dec 11 at 7:53am

    Great Video! Thanks.

  7. 08 Dec 11 at 7:53am

    Great Video! Thanks.

  8. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  9. shilka99 says
    06 Dec 11 at 9:26pm

    [..YouTube..] Thanks, great video. You’ve given me some good ideas.

  10. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  11. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  12. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  13. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  14. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  15. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  16. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  17. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  18. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  19. shilka99 says
    06 Dec 11 at 9:26pm

    Thanks, great video. You’ve given me some good ideas.

  20. bcrie says
    04 Dec 11 at 2:47pm

    Excellent explanation…Thanks…

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security