Create a Reporting Services report by using Dashboard Designer

  • Статья

 

Применимо к: SharePoint Server 2010 Enterprise

Последнее изменение раздела: 2016-11-30

By using Конструктор панели мониторинга PerformancePoint, you can create отчетов Microsoft SQL Server (SSRS) reports for your dashboards. A Службы Reporting Services report is a report that is published to Службы SQL Server Reporting Services and contains one or more charts and tables. By adding a Службы Reporting Services report to a PerformancePoint dashboard, you can reuse an existing report. In addition, if the Reporting Services report contains at least one parameter, you can connect PerformancePoint dashboard filters to the Службы Reporting Services report.

Совет

For information about creating a Reporting Services report and adding one or more parameters to the report, see the following resources:

Create a reference to a Reporting Services report

In Конструктор панели мониторинга, you do not actually create a Службы Reporting Services report. Instead, you create a PerformancePoint Web Part to display an existing Службы Reporting Services report.

To create a Reporting Services report, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS). To add parameters to the Reporting Services report that you can use to connect to dashboard filters, see Tutorial: Adding Parameters to a Report (SSRS).

ВажноImportant
Make sure that you have collected the following information:

  • The full name of the Reporting Services report that you want to use.

  • The server location where the Службы Reporting Services report is stored.

  • The server mode (SharePoint Integrated or Report Center) that you will use for the report, and whether Службы Reporting Services is configured to use the Trusted Account authentication mode in SharePoint Server 2010.

    Совет

    To view Службы Reporting Services configuration settings in SharePoint Server 2010, in Central Administration, under General Application Settings, click Службы Reporting Services Integration.

  • Any parameters that might exist in the Службы Reporting Services report, and information about how those parameters are configured. (You would typically need this information to connect a PerformancePoint dashboard filter to the Службы Reporting Services report.)

Also, make sure that you and the dashboard users have the necessary permissions to view the report.

When you create a Службы Reporting Services report by using Dashboard Designer, you do it in several stages, as described in the following list:

  1. Create the basic structure of the Web Part.

  2. Create the connection to the report. When you do this, you select between two modes in Конструктор панели мониторинга:

    • Report Center mode, which corresponds to Native mode in Службы Reporting Services

    • SharePoint Integrated mode

  3. Configure the report to display the information that you want to show.

To create the basic structure of your report Web Part

  1. In Конструктор панели мониторинга, in the Workspace Browser, click PerformancePoint Content.

  2. In the ribbon, click the Create tab.

  3. In the ribbon, in the Reports group, click Reporting Services.

    The blank report opens for editing in the center pane of the workspace.

  4. In the center pane, click the Properties tab.

  5. In the Name box, type the name that you want to use for the report.

  6. (This step is optional.) To specify a location for the report, click the Display Folder button, and then select or create a folder.

  7. In the Workspace Browser, right-click the report, and then click Save.

  8. Configure the report to display information by using either Report Center mode or SharePoint Integrated mode.

To connect to the report by using Report Center mode

  1. Begin with the report open for editing in Конструктор панели мониторинга. In the center pane, click the Editor tab.

  2. Use the Server mode list to select Report Center.

    Совет

    Report Center mode in Конструктор панели мониторинга corresponds to Native mode in Службы Reporting Services.

  3. In the Server name box, specify the Web site address (URL) for the server that hosts the report that you want to use.

    The server name typically takes the form http://<servername>/reportserver.

  4. Click the Browse button to locate the report that you want to use.

  5. Click the Preview button to view the report in the Preview pane.

  6. Proceed to finish configuring the report

To connect to the report by using SharePoint Integrated mode

  1. Begin with the report open for editing in Конструктор панели мониторинга. In the center pane, click the Editor tab.

  2. Use the Server mode list to select SharePoint Integrated.

    Совет

    SharePoint Integrated mode in Конструктор панели мониторинга corresponds to SharePoint Integrated mode in the Службы Reporting Services report server.

  3. In the Report Server URL box, specify the Web site address (URL) for the server that hosts the report that you want to use. Depending on how Службы Reporting Services is configured, the URL should resemble one of the following examples:

    • If Службы Reporting Services is configured to use Windows authentication, then the server name typically takes the form http://<servername>/reportserver.

    • If Службы Reporting Services is configured to use Trusted Account authentication in SharePoint Server, then the server name typically takes the form https://servername/_vti_bin/reportserver.

  4. In the Report URL box, specify the complete address for the report that you want to use.

    The report address typically takes the form http://<servername>/<document library>/<reportname>.rdl.

  5. Click the Preview button to view the report in the Preview pane.

  6. Finish configuring the report.

To finish configuring the report to display data

  1. Begin with the report open for editing in Конструктор панели мониторинга. In the center pane, click the Editor tab.

  2. Specify the following settings for your report:

    Item Description

    Show toolbar

    Select this check box to display the Службы Reporting Services toolbar.

    Show parameters

    Select this check box to display the filters that are specific to the report.

    Show docmap

    Select this check box to include a document map in a separate pane in your report view.

    Примечание

    Not all Службы Reporting Services reports have document maps. The document map is created by using either Службы SQL Server Reporting Services Report Builder or Microsoft Business Intelligence Development Studio. For more information, see How to Add Items to a Document Map (Reporting Services) (https://go.microsoft.com/?linkid=9733881)

    Zoom

    Select a value in this list to set the viewing size of the report.

    Format

    Select a value in this list to specify how you want your report to display in the dashboard.

    Section

    In this box, type the page number of the page that you want to display.

    For example, suppose that the Службы Reporting Services report contains three pages, and the information that you want to display is located on page 3. In this case, you would type 3 in the Section box in Конструктор панели мониторинга.

    DocMap ID

    Whether you use this option depends on the version of Службы SQL Server Reporting Services that was used to create the Службы Reporting Services report.

    • If Службы SQL Server 2005 Reporting Services was used, select this option to display a specific page or an item in the Службы Reporting Services report.

    • If Службы SQL Server 2008 Reporting Services was used, do not use this option. It does not work in the current version of PerformancePoint Services.

    1. Review the information in the Report parameters section.

      If the report that you selected contains parameters, they are displayed in the report parameters section. Depending on how those parameters are configured and the particular information that you want to display in the dashboard, you might not want to make any changes to the parameters. However, you might want to specify a default value for one or more parameters.

      If the report contains at least one parameter and you want to specify a particular default value for a parameter, follow these steps:

      1. In the Report parameters section, click a parameter.

      2. Click the Edit button. The Parameter Picker dialog box appears.

      3. In the Parameter Picker dialog box, use the drop-down menu to select a default value for the parameter, and then click OK.

        The default value that you specify will be selected automatically in the PerformancePoint dashboard when it is deployed to SharePoint Server. If Show toolbar and Show parameters are selected, dashboard users can change parameter selections.

      4. Repeat for each parameter that you want to configure.

    2. In the Workspace Browser, right-click the report, and then click Save.

    After you have created and saved your report, you can add it to a dashboard page.

    See Also

    Concepts

    Добавление на страницу элементов панели мониторинга с помощью конструктора панели мониторинга