Information workers need to access business data in order to make timely and effective decisions. They need a powerful, yet easy-to-use tool that allows them to explore and find information without having to understand the underlying data source structures. To help you reach these goals, Report Builder, a component of SQL Server Reporting Services, delivers ad hoc reporting functionality. Report Builder is fully integrated with Reporting Services.
The Report Builder tool is built using familiar Microsoft Office paradigms so that users can get started quickly. To build a table, matrix, or chart report, use a report layout template that contains predefined data regions and select a predefined report model, which contains report items such as data fields, then drag and drop the report items onto the data regions within the template. Filters can be applied to the report to refine which data gets displayed. The report model contains all of the information required for Report Builder to automatically generate a query to retrieve the requested data. Using Report Builder, users can find data that is related to the content in their report, add text and formatting, create new fields and calculations based on the data in the report model, and preview, print, and publish their reports.
Using Report Builder, users can interactively explore the related data within the report model. Clickthrough reports are automatically generated so that report viewers can follow the report model's navigation paths to explore the data. They can continue clicking through the data as long as there is a relationship to follow from the current item. When clicking through the data, queries are generated automatically by passing information about which data that the user is using to create their report, typically referred to as the context of the current data location.
Report Builder is a ClickOnce Windows Forms application that is accessed from the report server for easy centralized management. Report Builder reports are published in Report Definition Language (RDL), and therefore can be opened and modified using the advanced programming capabilities in Report Designer or Report Designer Preview to utilize the full capabilities of Reporting Services. Report Builder reports are managed, secured, and delivered using the same methods and APIs used to manage, secure, and deliver Report Designer reports. In addition, Report Builder can be launched from third party applications for integrated reporting.
If you open a Report Builder report in SQL Server 2008 Report Designer or Report Designer Preview and add additional functionality, you will not be able to open the report in Report Builder again.
Report Builder can be accessed through a URL or from Report Manager, a component of Reporting Services that enables users to publish and view reports on a report server. Users need assigned permission to access Report Builder. In the role-based security model that is implemented for Reporting Services, users who are assigned to the Content Manager role can create and edit reports in Report Builder. Local administrators are automatically assigned to this role. If you want other users to be able to work with a Report Builder report, you must create a role assignment for them that includes the default role "Report Builder." Alternatively, you can create a custom role definition. As long as the customized role includes the "Consume reports" task, users who are assigned to that role will have sufficient permission to create and modify reports using Report Builder.
When Report Builder is loaded on the client computer, a separate Help file is available for reference. This Help file discusses Report Builder concepts, and provides procedural and F1 help.