Creating and Working with a Report (Report Builder)

Report Builder is a client-side application that you can use to create and design ad hoc reports. Using Report Builder, you can select data and design reports without having to understand how and where the data is stored. Nor do you need to know any complex programming languages in order to create reports. You simply need to be familiar with the contents of your data and how it relates to the other data within the database.

Using Report Builder, you can create table, matrix, or chart reports. To get started, select a report layout and then simply drag the fields or entities into the design area. The data can be manipulated by filtering, grouping and sorting, or working with formulas. You can specify parameters, such as the prompt parameter in filters. In addition, you can format your reports to use colors, fonts, lines, and different formats. Then, when you are ready to view the data in your report, simply run the report.

In This Section

Topic Description

Creating a Report (Report Builder)

Discusses working with sources of data, entities, and fields, exploring the available data, and understanding the difference between designing and running a report.

Designing a Report (Report Builder)

Discusses the available report layouts, formatting report items, and working with filters, formulas and grouping and sorting of data.

Running a Report (Report Builder)

Discusses report rendering and working with the data in Report Builder run mode.

See Also

Concepts

Saving a Report (Report Builder)
Exporting a Report as a Different File Type (Report Builder)
Printing a Report (Report Builder)
Report Builder How-to Topics

Other Resources

Report Builder F1 Help
Report Builder Tutorials

Help and Information

Getting SQL Server 2005 Assistance