Report Builder (SSRS)

Report Builder is a report authoring environment for business users who prefer to work in the Microsoft Office environment. 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 the report.

Benefits of Report Builder

Report Builder enables you to:

  • Use the Report Builder ribbon to quickly add items your reports, launch table, chart, and map wizards, and format report data.

  • Add data from built-in data providers by using query designers that help you specify which data to include in your report.

  • Create and use report parameters and other interactive features that enable your report readers to customize data and vary report presentation.

  • Create expressions from built-in fields, collections, operators, and functions.

  • Open reports directly from a report server.

  • Preview reports that use local or published shared data sources and shared datasets.

  • Preview reports in HTML or print format.

  • Export reports to other file formats such as Microsoft Excel.

  • Save your report and related items s to a SharePoint library, a report server, or your local computer.

Report Builder and Report Designer share many features. For more information about Report Builder, see Report Builder documentation on

See Also


Configure Report Builder Access


Tools (SSRS)

Design Reports with Report Designer (SSRS)