Tutorial: Creating a Basic Tabular Report (Report Builder 1.0)

This tutorial is designed to help you create a basic table report based on the AdventureWorks database. In this tutorial, you will create a tabular report, add fields and entities to the report, filter the report, format the contents of the report, group and sort the report, run the report, and save the report to the report server.


Your system must have the following installed to use this tutorial:

  • Microsoft .NET Framework 2.0

The report server from which you will be launching 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.

Important   To verify that the samples are installed and you have permissions to access them, contact your database administrator. SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see the "Considerations for Installing SQL Server Samples and Sample Databases" 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.