Tutorial: Advanced Features Using Parameters
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
This tutorial is designed to help you explore how parameters can be used to control content and appearance in a basic tabular report.
What You Will Learn
In this tutorial, you will start Report Designer and use the Report Wizard to create a report that uses the AdventureWorks sample database as a data source. In each lesson, you will learn about different types of parameters, different ways you can use parameters, and how to pass parameters from a main report to a subreport or a drillthrough report.
This tutorial is divided into eight lessons:
- Lesson 1: Using the Report Wizard to Set Up the Advanced Parameters Tutorial
In this lesson, you will create an Advanced Parameters Tutorial report server project and use the Report Wizard to create a report named "Resellers Worldwide".
- Lesson 2: Adding Cascading Parameters to a Report
In this lesson, you will add four cascading parameters that successively filter data from the data source before you process the Resellers Worldwide report.
- Lesson 3: Changing Initial Sort and Interactive Sort Using Parameters
In this lesson, you will add a parameter to control the way the table groups are sorted in the Resellers Worldwide report.
- Lesson 4: Adding a Boolean Parameter to Control the Initial Drilldown State
In this lesson, you will add a Boolean parameter to control the initial drilldown state of the Resellers Worldwide report.
- Lesson 5: Adding A Report Parameter to Pass to a User-Defined Function
In this lesson, you will add a new report named "Contact Information". You will add a parameter to provide contact information for a specific store contact and a multivalue parameter to specify which contact information to use.
- Lesson 6: Adding a Subreport with Parameters
In this lesson, you will add a subreport to the Resellers Worldwide report and bind it to the Contact Information report you created in the previous lesson.
- Lesson 7: Creating a Drillthrough Report
In this lesson, you will add the AdventureWorks sample report "Territory Sales Drilldown" to the project, add a parameter to it, and rename the report "Parameterized Territory Sales Drilldown". In the next lesson, you will drill through to this report from Resellers Worldwide using a parameter.
- Lesson 8: Adding a Linked Report with Customized Parameter Values
In this lesson, you will create a linked report based on the Resellers Worldwide report and name it "Resellers Pacific". Using Report Manager, you will change parameter properties for this report so that it only shows values for the Pacific sales territory group.
To use this tutorial, the system must have the following installed:
SQL Server 2005 Reporting Services with the AdventureWorks sample reports. The samples are not installed automatically during setup, but you can install them at any time. For information about how to install the samples, see Installing SQL Server Samples and Sample Databases.
To complete this tutorial, you must be running Reporting Services in native mode. If you are running Reporting Services in SharePoint integrated mode, the steps that use report server URLs will not work. For more information about Reporting Services modes, see Planning a Deployment Mode (Reporting Services). For more information about how to deploy projects, see Deploying Reports, Models, and Shared Data Sources to a SharePoint Site.
SQL Server Business Intelligence Development Studio.
Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.
SQL Server with the AdventureWorks sample database.
In addition, you must have the following permissions:
- To deploy and publish a report, you must be assigned to the Content Manager or Publisher role.
- To retrieve data from the AdventureWorks database.
This tutorial requires that you have completed the previous tutorial, Tutorial: Adding Parameters to a Basic Tabular Report.
Estimated time to complete this tutorial: 3 hours
How to: Add, Edit, or Delete a Report Parameter (Report Designer)
How to: Add a Subreport and Parameters (Report Designer)
How to: Associate a Query Parameter with a Report Parameter (Report Designer)
Working with Parameters in Reporting Services
Using Expressions in Reporting Services (Reporting Services)
Dataset Properties Dialog Box, Parameters Tab (Report Designer)
XNIB - Report Parameters Dialog Box (Report Designer)
Subreport Properties Dialog Box, Parameters Tab
Action Dialog Box (Report Designer)
Textbox Properties Dialog Box, Action Tab