This video is from our "SQL Server 2005 Reporting Services" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: Part 1 - An introduction to Parameters and Parameterized Reports in SSRS

  • ·Skill level: 300 (Intermediate)
  • ·Run Time: 9:00
  • ·Instructor: Scott Whigham

Description:

You often need more advanced reporting such as drop down lists and the ability to use parameters when working in Sql Server Reporting Services. This first video in the section will give a great introduction of how to work with parameters in SSRS, as well as get you started with working with parameters by briefly demonstrating how to create a drop-down list for managing your parameters.

Highlights from this video:
  • Using variables that have not been declared in SSRS vs TSQL
  • Viewing what happens with Auto-Parameterization
  • Viewing Report Parameters
  • How to create a drop-down list
and much more

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Chapter 5: Developing Reports Using the Business Intelligence Development Studio (BIDS)
1 How Solutions and Projects Work in the Business Intelligence Development Studio (BIDS)
2 An Introduction to the Business Intelligence Development Studio (BIDS) Environment
3 Pt. 1 - How to Create your First Report With the Report Server Project Wizard
4 Pt. 2 - How to Create your First Report With the Report Server Project Wizard
5 Pt. 1 - An Overview of the AdventureWorks Sample Reports
6 Pt. 2 - How to Install the AdventureWorks Sample Reports
7 Pt. 3 - How to Configure and Deploy the Sample Reports
Part 1 - An introduction to Parameters and Parameterized Reports in SSRS
9 Part 2 - Basics of Parameters: datatypes, Nullability, and Default Values
10 Part 3 - Syntax for Parameters in OLE - DB, Oracle, and SQL Server
11 Part 4 - Dropdown Lists and PickLists
12 Part 5 - Using Stored Procedures With Parameters
13 Part 6 - Working With NULL Parameters and Tricks for SSRS
14 Part 7 - More on Nullable Parameters Including How to Use UNIONs
15 Part 8 - Multi-value Parameters
16 Part 1 - An Overview of How to Use Reporting Services Within ASP.NET
17 Part 2 - Creating a Drillthrough Report and Binding It to the ReportViewer
18 Part 3 - Details On Using the ReportViewer's Properties, ReportDataSources and More
19 Part 4 - Manipulating The ReportViewer Properties
20 Part 5 - Using the Remote Processing Mode and Understanding ServerReport and LocalReport
21 Part 1 - How to Create a Drilldown/Drillthrough Report
22 Part 2 - Creating a Drillthrough Report Without Using the Wizard
23 Part 1: What Are Templates and How Can I Make My Own?
24 Part 2: Customizing Templates and How to Work With Multiple Templates
25 Part 1 - The Goals of the Project and Defining the Data to Use for Invoices
26 Part 2 - Still Working on Choosing the Data Items for the Invoices
27 Part 3 - Determining Whether to Use One Result Set or Multiple Result Sets
28 Part 4 - Creating the 'Shell' of the Invoice and Adding the Datasets
29 Part 5 - Completing the Basic Invoice Layout and Adding Data
30 Part 6 - Making Your Invoices Dynamically Generated With Report Parameters and DropDownLists
31 Part 7 - An Example of Using Multiple Result Sets to Build Your Invoice
32 Part 1 - The Chart Control: Understanding the Query/Database for the Demo
33 Part 2 - Creating Our First Report With the Chart Control
34 Part 3 - Customizing Your Charts Using the GUI and Category Groups, Groupings, and How to Manage Hierarchies
35 Part 4 - Customizing Your Charts Using Series and Formatting
36 Part 5 - More on Working with Series and How to Customize the Legend
37 Part 6 - Customizing Your Charts Using Labels, Gridlines, and Markers
38 Part 7 - Miscellaneous Formatting Options

NOTE: This video is part of our SQL Server 2005 Reporting Services course.
This video is from Chapter 5: Developing Reports Using the Business Intelligence Development Studio (BIDS)

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.