Report Builder 2.0 is a report authoring tool that you can use to design and publish your own reports. When you design a report, you specify where to get the data, which data to get, and how to display the data. When you run the report, the report processor takes all the information you have specified, retrieves the data and combines it with the report layout to generate each page as you view it. You can view your reports from within the Report Builder 2.0 tool, or you can publish your report to a report server where others can run it.
Sample of a report from the AdventureWorks 2008 sample database. Your system administrator can download the sample databases for you to use.
Using Report Builder 2.0, you can:
Create reports with tables, matrices, charts, or free-form areas. Start designing your report by using the Table, Matrix, or Chart Wizard. Choose a data source connection, drag and drop fields to create a dataset query, select a layout and style, and customize your report any way you want.
Modify your data by filtering, grouping and sorting data, or by adding formulas or expressions.
Change the appearance of your report by adding text boxes, images, or conditional formatting.
Add interactive features, such as interactive sorting, drillthrough reports, and toggling the visibility of report items.
Run the report to preview your changes. Toggle between design view and preview.
Save the report to your computer or to the report server, where you can manage it and share it with others.
To access the report server, you must have adequate permissions. If you need permissions, contact your report server administrator.
Export the report as a different file type, such as a TIFF, PDF, Excel, Word, or HTML file.
These sections of the documentation provide in-depth conceptual information about Report Builder 2.0 and Reporting Services, as well as procedural information about how to design, customize, and use Report Builder reports.
- Working in Report Builder 2.0
Describes the Report Builder menus, panes, and ribbon.
- Connecting to Your Data (Report Builder 2.0)
Provides information about connecting to your data source and adding your data to your report.
- Designing the Report Layout (Report Builder 2.0)
Provides information about choosing a data region template, adding text boxes, images, lines, and rectangles to your report. Also describes interactive functionality that you can add to your report.
- Working with Your Data (Report Builder 2.0)
Provides information about how to add parameters, filters, and expressions to the report, and group and sort the data.
- Administering Report Builder 2.0
Describes how to publish your reports and data sources to a report server.
- Finding, Saving, and Managing Reports (Report Builder 2.0)
Describes how to view your reports while running Report Builder or when viewing the report on the report server.
- Exporting Reports (Report Builder 2.0)
Provides information about how to save your reports in another file format.
- Printing Reports (Report Builder 2.0)
Provides information about how to print your reports.
- Administering Report Builder 2.0
Provides information for the report server administrator about how to configure Report Builder in a Reporting Services environment that is configured to use native mode or SharePoint integrated mode.
- Report Builder 2.0 F1 Help
Describes the options available in each dialog box, query builder, and expression editor.
- Properties in Report Builder 2.0
Describes each of the Reporting Services properties that appear in the Properties pane. Many of these properties can be changed in the Report Builder dialog boxes; however, the Properties pane provides an alternative way to see and update report item properties. The topic describes the available values and default values for each property.