• Article

Tutorial: How to Locate and Start Reporting Services Tools

This tutorial introduces the tools used to configure a report server, manage report server content and operations, and create and publish reports and report models. The purpose of this tutorial is to help new users understand how to find and open each tool. If you are already familiar with the tools, you can move on to other tutorials that can help you learn important skills for using Reporting Services. For more information about other tutorials, see How Do I Find Tutorials (Reporting Services).

Requirements

You must have installed all of the Reporting Services components. For more information about which setup options to select in order to get specific components, see Considerations for Installing Reporting Services.

Reporting Services Configuration Tool

Use the Reporting Services Configuration Tool tool to specify the service account, create or upgrade the report server database, modify the connection properties, specify URLs, manage encryption keys, and configure the report server for unattended report processing and e-mail report delivery.

To start the Reporting Services Configuration tool

  1. Click Start, point to Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and click Reporting Services Configuration.

    The Report Server Installation Instance Selection dialog box appears so that you can select the report server instance you want to configure.

  2. In Server Name, specify the name of the computer on which the report server instance is installed. The name of the local computer is specified by default, but you can also type the name of a remote SQL Server instance.

    If you specify a remote computer, click Find to establish a connection. The report server must be configured for remote administration in advance. For more information, see How to: Configure a Report Server for Remote Administration.

  3. In Instance Name, choose the SQL Server Reporting Services instance that you want to configure. Only SQL Server 2008 report server instances appear in the list. You cannot configure earlier versions of Reporting Services.

  4. Click Connect.

  5. To verify that you launched the tool, compare your results to the following image:

    Reporting Services Configuration tool

Report Manager

Use Report Manager to set permissions, manage subscriptions and schedules, and work with reports and models. You can also use Report Manager to view reports.

Before you can open Report Manager, you must have sufficient permissions (initially, only members of the local Administrators group have permissions that provide access to Report Manager features). Report Manager provides different pages and options depending on the role assignments of the current user. Users who have no permissions will get an empty page. Users with permissions to view reports will get links that they can click to open the reports. To learn more about permissions, see Tutorial: Setting Permissions in Reporting Services.

To start Report Manager

  1. Open Microsoft Internet Explorer 6.0 or later.

  2. In the address bar of the Web browser, type the Report Manager URL. By default, the URL is http://<serverName>/reports. You can use the Reporting Services Configuration tool to confirm the server name and URL. For more information about URLs used in Reporting Services, see Configuring Report Server URLs.

  3. Report Manager opens in the browser window. The startup page is the Home folder. Depending on permissions, you might see additional folders, hyperlinks to reports, and resource files within the startup page. You might also see additional buttons and commands on the toolbar.

  4. To verify that you launched the tool, compare your results to the following image:

    Report Manager Home page

Management Studio

Report server administrators can use Management Studio to manage a report server alongside other SQL Server component servers. For more information, see Introducing SQL Server Management Studio.

To start SQL Server Management Studio

  1. Point to Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.

    The Connect to Server dialog box appears. It should look similar to the following diagram:

    Report Server Connection dialog box

  2. If the Connect to Server dialog box does not appear, in Object Explorer, click Connect and then select Reporting Services.

  3. In the Server type list, select Reporting Services. If Reporting Services is not on the list, it is not installed.

  4. In the Server name list, select a report server instance. Local instances appear in the list. You can also type the name of a remote SQL Server instance.

  5. Click Connect. You can expand the root node to set server properties, modify role definitions, or turn off report server features.

Business Intelligence Development Studio with Report Designer and Model Designer

Report Designer and Model Designer are two design tools that are available within Business Intelligence Development Studio. The design surfaces in the tools include tabbed windows, wizards, and menus used to access report and model authoring features. The design tools become available when you choose a Report Server Project, a Report Server Wizard, or a Report Model Project template. To learn more, see Introducing Business Intelligence Development Studio.

Note

In SQL Server 2008Reporting Services new and revised authoring tools are used to access new features. For more information, see What's New in Report Authoring.

To start Report Designer

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click Business Intelligence Development Studio.

  2. On the File menu, point to New, and then click Project.

  3. In the Project Types list, click Business Intelligence Projects.

  4. In the Templates list, click Report Server Project. The following diagram shows how the project templates appear in the dialog box:

    New Project template dialog box

  5. Type a name and location for the project, or click Browse and select a location.

  6. Click OK. Business Intelligence Development Studio opens with the Visual Studio start page. Solution Explorer provides categories for creating reports and data sources. You can use these categories to create new reports and data sources. Tabbed windows appear when you create a report definition. The tabbed windows are Data, Layout, and Preview. To get started on your first report, see Tutorial: Creating a Basic Table Report. To learn more about query designers you can use within Report Designer, see Query Design Tools in Reporting Services.

To start Model Designer

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click Business Intelligence Development Studio.

  2. On the File menu, point to New, and then click Project.

  3. In the Project Types list, click Business Intelligence Projects.

  4. In the Templates list, click Report Model Project.

  5. Type a name and location for the project, or click Browse and select a location.

  6. Click OK. Business Intelligence Development Studio opens with the Visual Studio start page. Solution Explorer provides categories for creating models, data sources, and data views. The design surface changes when you define a data source connection. To get started on your first model, see Tutorial: Creating a Report Model.

  7. To verify that you launched the tool, compare your results to the following image. The image shows Model Designer with an open model:

    Model Designer with an open model file

Report Builder 2.0

You can install Report Builder 2.0 as part of the Microsoft SQL Server 2008 Feature Pack. Use Report Builder 2.0 to create reports in a familiar, Microsoft Office-like authoring environment. You can customize and update all existing reports, regardless of whether they were created in Report Designer or in the previous version of the tool, Report Builder 1.0. To practice with Report Builder 2.0, see Tutorials (Report Builder 2.0).

To install standalone Report Builder 2.0

  1. Open Microsoft Internet Explorer.

  2. Go to the SQL Server 2008 Feature Pack.

  3. Search the Feature Pack for Report Builder 2.0.

  4. Follow the installation instructions.

To start standalone Report Builder 2.0

  1. Click the Start menu, point to All Programs, click Microsoft SQL Server 2008 Report Builder 2.0, and then click Report Builder 2.0.

  2. To verify that you launched the tool, compare your results to the following image:

    Design surface of Report Builder 2.0

To start Report Builder 2.0 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. Report Manager opens.

  2. Click Report Builder.

    The Report Builder 2.0 opens and you can begin to create a report or open a report on the report server.

To start Report Builder 2.0 using a URL

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

    http://<servername>/reportserver/reportbuilder/ReportBuilder/ReportBuilder_2_0_0_0.

  2. Press Enter.

    The Report Builder 2.0 opens and you can begin to create a report or open a report on the report server.

To start Report Builder 2.0 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 2.0 opens and you can begin to create a report or open a report on the report server.

Report Builder 1.0

Use Report Builder 1.0 to create ad hoc reports that use published models as a data source. You can save reports from Report Builder 1.0 to a report server. To practice these skills, see Report Builder 1.0 Tutorials.

To start Report Builder 1.0

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

  2. Click Report Builder. The Report Builder button is located alongside other buttons on the toolbar:

    Command bar in Report Manager

    If you do not see the Report Builder button, you might not have permissions. To find out what permissions you need, see How to: Configure Report Builder 1.0 and Report Builder 2.0 Access.

    You can also launch Report Builder directly from a URL. For more information, see How to: Start Report Builder.

  3. To verify that you launched the tool, compare your results to the following image:

    Report Builder startup page