Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Using Report Builder

Report Builder 3.0 is a tool for designing, authoring, and publishing reports, designed for end

users and business users. The tool allows users to create reports by:

Starting from scratch



Using a built-in wizard (table, matrix, or map)



Using a shared dataset



Using report parts



No matter the design method, once the report is complete it can be saved to the file system or

published to the Report Manager. Choosing the latter allows those who have permissions to

view the report. In addition, end users can open and edit reports in Report Builder from the

Report Manager or SharePoint if they have permissions to access the report. Once open, the

report can be modified and then published to the Report Manager. The users can either pub-

lish it as a new report or overwrite the existing report with the appropriate permissions.

Report Builder 3.0 is a tool that enables end users to perform several of the tasks that were the

responsibility of the IT staff. They can now build new reports, modify existing reports, and

leverage existing components that have been published to the Report Manager or SharePoint.

OPENING REPORT BUILDER

Report Builder can be opened from SharePoint or the Report Manager. You may also down-

load it and install it on your machine. If you do this, you can open it from your Windows Start

menu, though how you open it will often depend on what you are t ...