How to Create Parameterized Reports in SQL Server Reporting Services - Video Series Video Category: Developing Your Reporting Services Reports Using the Business Intelligence Development Studio (BIDS) Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2008 In this 8-part video series, Scott will give you an introduction to the world of parameters and parameterized reports in SSRS as you often need more advanced reporting such as drop down lists and the ability to use parameters when working in Sql Server Reporting Services. Highlights from this video series: Viewing what happens with Auto-Parameterization Viewing Report Parameters How to create a drop-down list Changing the default report parameters Oracle syntax and OLE-DB syntax vs SQL syntax How Stored Procedures work in Transact SQL What are the multi-value parameters? Using UNION statements to generate new drop-down items

Videos in this Series:

Title Skill Length Download Part 1 - An introduction to Parameters and Parameterized Reports in SSRS     300 9 mins. Download Part 2 - Basics of Parameters: datatypes, Nullability, and Default Values   300 11 mins. Download Part 3 - Syntax for Parameters in OLE - DB, Oracle, and SQL Server   300 6 mins. Download Part 4 - Dropdown Lists and PickLists   300 7 mins. Download Part 5 - Using Stored Procedures With Parameters   400 11 mins. Download Part 6 - Working With NULL Parameters and Tricks for SSRS   400 10 mins. Download Part 7 - More on Nullable Parameters Including How to Use UNIONs   400 8 mins. Download Part 8 - Multi-value Parameters   400 5 mins. Download

< Return to list of all videos