How to: Start Report Builder

To start Report Builder in native mode, users can click the Report Builder button in Report Manager or use the URL that corresponds to the trust mode being used. Report Builder can run in partial trust or full trust mode. The default is full trust mode.

Note

To start Report Builder with a model loaded or a specific report displayed, you can append additional parameters to the URL. To learn more about these parameters, see Starting Report Builder.

To start Report Builder in SharePoint integrated mode, users can use the New menu or the Actions menu, or point to the file and then click the down arrow.

For more information about deploying ClickOnce applications, applying ClickOnce application security, or running ClickOnce applications in the Internet zone, see the "ClickOnce Deployment for Windows Forms Applications", "Security in Windows Forms Overview", or "Trusted Application Deployment Overview" articles on the Microsoft Developer Network Web site at www.microsoft.com/msdn.

To verify that you have configured the report server and roles correctly in native mode, see Configuring a Report Server for Report Builder Access, Role Assignments, Report Builder Role, and Role Assignments for Report Builder Access. To verify that you have configured the report server in SharePoint integrated mode and added the Report Builder Report content type to the SharePoint library, see Configuring Reporting Services for SharePoint 3.0 Integration and How to: Add Report Server Content Types to a Library (SharePoint Integrated Mode).

Note

Note: Do not pass user credentials in the URL when attempting to start Report Builder. Report Builder will not start or connect to the server using the supplied credentials and Internet Explorer does not support this syntax by default any longer. For more information about Internet Explorer, see https://support.microsoft.com/kb/834489.

To start Report Builder from Report Manager

  1. In your Web browser, type the URL for your report server in the address bar. By default, the URL is http://<servername>/reports.

  2. Click Report Builder.

    The Report Builder window opens.

  3. In the Getting Started pane, select a data source and then click OK.

    You can begin to create a report.

To start Report Builder using a URL

  1. In your Web browser, type the following URL in the address bar:

    http://<servername>/reportserver/reportbuilder/reportbuilder.application

    - or -

    http://<servername>/reportserver/reportbuilder/reportbuilderlocalintranet.application

    Note

    Which URL you use depends on the trust level in which you are running Report Builder.

  2. Press Enter.

    The Report Builder window opens.

  3. In the Getting Started pane, select a data source and then click OK.

    You can begin to create a report.

To start Report Builder in SharePoint integrated mode

  1. Navigate to the site that contains the library you want.

  2. Open the library.

  3. On the New menu, click Report Builder Report.

    The Report Builder window opens.

  4. In the Getting Started pane, select a data source and then click OK.

    You can begin to create a report.

To start Report Builder in SharePoint integrated mode with a report or model pre-loaded

  • To open a report in Report Builder:

    • Point to the report (.rdl) file, click the down arrow, and select Edit in Report Builder.
      OR
    • View the report and on the Actions menu, select Open with Report Builder.
  • To load a model when you start Report Builder:

    • Point to the model (.smdl) file, click the down arrow, and select Load in Report Builder.

See Also

Concepts

Report Builder
Starting Report Builder
Working with Report Builder (Ad Hoc Reports)
Report Builder How-to Topics
Creating a Report (Report Builder)
Designing a Report (Report Builder)

Other Resources

Tutorial: Creating a Report Model
Integrating Reporting Services Using URL Access

Help and Information

Getting SQL Server 2005 Assistance