2 out of 29 rated this helpful - Rate this topic

How to: Start Report Builder

SQL Server 2005

SQL Server 2012

Updated: 12 December 2006

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 http://support.microsoft.com/kb/834489.

To start Report Builder from Report Manager

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

The Report Builder window opens.
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

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.
Press Enter.

The Report Builder window opens.
In the Getting Started pane, select a data source and then click OK.

You can begin to create a report.

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

To start Report Builder in SharePoint integrated mode

Navigate to the site that contains the library you want.
Open the library.
On the New menu, click Report Builder Report.

The Report Builder window opens.
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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

How to: Start Report Builder

Concepts

Other Resources

Help and Information

Community Additions