Tutorial: Creating Advanced Filters and Calculated Fields (Report Builder)
New: 14 April 2006
Depending on the data that you want to retrieve, you may have to create filters and/or formulas. In Report Builder, you can create anything from simple filters to incredibly complex filters. In addition, you can create calculated fields that can be added to the report or used within a filter. In this tutorial, you will use Report Builder to create a simple report, create two calculated fields, and then apply filters.
Requirements
Your system must have the following installed to use this tutorial:
- Microsoft .NET Framework 2.0.
The report server from which you launch Report Builder must have the following:
- The AdventureWorks database installed on a computer that is accessible to the report server.
- The AdventureWorks Sample Report Model uploaded to the report server.
Note This tutorial assumes that you are using an unmodified version of the report model sample included with SQL Server. If you use a model that has been previously modified, the results of your tutorial might not match what is described in this tutorial.
- Permissions for you to access the sample report model.
- Permissions for you to use Report Builder.
- Permissions for you to retrieve data from the AdventureWorks database.
- Permissions for you to save reports to the report server.
Note
To verify that the samples are installed and you have permissions to access them, contact your database administrator. For more information about installing sample databases, see the "Installing Samples" topic in SQL Server Books Online. For more information about publishing a report model, see the "Publishing a Report Model" topic in SQL Server Books Online.
Tasks
Lesson 1: Creating a Report (Report Builder)
Lesson 2: Creating a Calculated Field (Report Builder)
Lesson 3: Applying an Existing Filter to a New Calculated Field (Report Builder)
Lesson 4: Apply a Filter to the Entire Report (Report Builder)
See Also
Concepts
Other Resources
Working with Filters (Report Builder)
Working with Formulas (Report Builder)
Working with Literals in Formulas and Filters (Report Builder)