Share via


Starting Report Builder

Report Builder uses a deployment technology called ClickOnce that is part of the Microsoft .NET Framework 2.0. ClickOnce enables you to easily install and upgrade Windows-based applications. Report Builder can run in either full trust or partial trust. In full trust, Report Builder runs using the permissions that are granted to the user. In partial trust, Report Builder runs using the permissions granted to applications in the Local intranet zone. By default, Report Builder runs using full trust.

If you choose to have Report Builder users start Report Builder in full trust, users will see a security message asking them if they are willing to grant the application full trust to their computer the first time that they start Report Builder. If you choose to have Report Builder users start Report Builder in partial trust, local intranet users will not be prompted at all and Internet users will be prompted to grant more restricted permissions the first time that they start Report Builder.

Report Builder functionality is the same regardless of trust level, except that Report Builder Help cannot be accessed from Report Builder when it is running in partial trust. Instead, you need to provide a copy of the ReportBuilder.chm Help file to those Report Builder users.

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, see Configuring a Report Server for Report Builder Access, Role Assignments, Report Builder Role, and Role Assignments for Report Builder Access.

Changing the Trust Level for Report Builder

By default, clicking the Report Builder button in Report Manager starts Report Builder in full trust. If you do not want Report Builder to run using full trust, you can change the value of the element that controls which trust permissions are used. To change the trust level, you need to open the RSWebApplication.config file and change the <ReportBuilderTrustLevel> element from FullTrust to PartialTrust. You can find this file in the Report Manager installation directory.

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.

Using a URL to Start Report Builder

Because Report Builder is a Web application installed on your report server, you can use a URL to start the application.

To start Report Builder in full trust, use the following URL:

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

To start Report Builder in partial trust, use the following URL:

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

For both URLs, <servername> is the name of the computer that specifies the report server. For both URLs, reportserver is the name of the report server instance. For more information about virtual report server directories, see Configuring Report Server Virtual Directories.

Additional Parameters

The URLs used to start Report Builder can also support the following parameters:

  • To automatically open a specific report, add the following to the URL:
    ?<reportpath>
    For example, use the following to open Report Builder in full trust mode and display a report called Quarterly Sales by Region located in your MyReports folder:
    http://<servername>/reportserver/reportbuilder/reportbuilder.application?/My+Reports/Quarterly+Sales+By+Region
  • To automatically load a specific report model, add the following to the URL:
    ?model=<modelpath>
    For example, use the following to open Report Builder in full trust mode and load a report model located in the Models folder called Adventure Works:
    http://<servername>/reportserver/reportbuilder/reportbuilder.application?/?model=/Models/Adventure+Works
  • To automatically load a perspective of a specific report model, add the following to the URL:
    ?model=<modelpath>&perspective=<perspectiveID>
    For example, use the following to open Report Builder in full trust mode and load a perspective called Employees within a report model called Adventure Works:
    http://<servername>/reportserver/reportbuilder/reportbuilder.application?/?model=/Models/Adventure+Works&perspective=Gda518f2c-5598-418a-8bc4-bb9afe064a64

Note

You can find the perspective ID by opening SQL Server Business Intelligence Development Studio, selecting the perspective in list view, and then copying the General Category ID number in the Properties window. Alternatively, view the report model XML and search for the <Perspectives> tag. The perspective ID is listed within the <Perspectives> tag.

Starting Report Builder in SharePoint Integrated Mode

If your report server is configured to run in SharePoint integrated mode, you can run Report Builder only in full trust.

To run your report server in SharePoint integrated mode, the report server must be added to a SharePoint site or farm. For more information about configuring the report server for SharePoint integrated mode, see Configuring Reporting Services for SharePoint 3.0 Integration. After your report server is configured for SharePoint integrated mode, you must add the Report Builder Report content type to the SharePoint library. For more information, see How to: Add Report Server Content Types to a Library (SharePoint Integrated Mode).

After the SharePoint library is set up, you can start Report Builder by using any one of the following methods:

  • Open the New menu and click Report Builder Report.
    The Report Builder window opens and you select a model and report layout.
  • Point to the report (.rdl) file, click the down arrow, and select Edit in Report Builder.
    The Report Builder window opens with the model selected and the report displayed in design mode.
  • Point to the model (.smdl) file, click the down arrow, and select Load in Report Builder.
    The Report Builder window opens with the model selected. By default, a table report is the report layout selected.
  • View the report and then open the Actions menu and select Open with Report Builder.
    The Report Builder window opens with the model selected and the report displayed in design mode.

Change History

Release History

12 December 2006

Changed content:
  • Added running Report Builder SharePoint integration mode section.

17 July 2006

Changed content:
  • Added links to shared Report Builder content, to the Role content, and Report Builder Access content.

14 April 2006

New content:
  • Added entire Additional Parameters section.
Changed content:
  • Changed title of the topic from Launching Report Builder to Starting Report Builder.
  • Revised introductory paragraphs.

See Also

Tasks

How to: Start Report Builder

Concepts

Creating and Working with a Report

Other Resources

Understanding Security Policies
Introducing Code Access Security in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance