Introduction

K2 blackpearl makes use of Microsoft SQL Server Reporting Services (SSRS) to provide workflow reports. These reports are installed as part of the K2 blackpearl Reporting Services Components and can be viewed using the K2 blackpearl Workspace or the Report Manager web site.

Reporting information can be easily displayed to users that are connecting to a Microsoft Office SharePoint Server (MOSS) 2007 web site. This is done by using the Reporting Services web parts. This article will describe the steps necessary to display the workflow reports to users by making use of these web parts.

Implementation Example

By default the Reporting Services web parts are not available on the MOSS server. Before these web parts can be used they have to be installed. Detailed instructions on how to accomplish this are described in the MSDN article Viewing Reports with SharePoint 2.0 Web Parts.
 

Important: This article assumes that all the steps in the above article have been followed to enable the Reporting Services web parts. This article also assumes that the K2 blackpearl Reports have been installed and that these reports are visible through the Report Manager web site.


Step 1: Add Reporting Web Parts

  1. In a SharePoint site, open a Web Part Page
  2. In Site Actions, click Edit Page
  3. In a zone on the page, click Add a Web Part
  4. In the Add Web Parts dialog box, scroll down to Miscellaneous. If you are using Office SharePoint Server, you might need to expand All Web Parts first
  5. Select the Report Explorer and Report Viewer Web Parts
  6. [Figure 1. Report Explorer and Report Viewer Web Parts]

  7. Click Add


Step 2: Configure the Report Explorer Web Part

  1. While the page is in edit mode, click Edit in the Report Explorer Web Part
  2. Click Modify Shared Web Part


  3. [Figure 2. Modify Shared Web part]
  4. In the Report Manager URL, enter a URL to the report server that hosts the K2 blackpearl Reports. By default, a Report Manager URL has the following syntax: http:///reports
  5. Set the Start Path to /Standard Reports to have the Report Explorer Web Part display the standard K2 reports. Your properties should resemble the following:


  6. [Figure 3. Report Explorer Configuration]
  7. Click Apply

 
Step 3: Configure the Report Viewer Web Part

  1. While the page is still in edit mode, click Edit in the Report Viewer Web Part
  2. Click Modify Shared Web Part
  3. In the Report Manager URL, type the same URL used by the Report Explorer Web Part
  4. Leave the Report Path blank


  5. [Figure 4. Report Viewer Configuration]
  6. Click Apply

 
Step 4: Connect Report Explorer and Report Viewer Web Parts

  1. While the page is still in edit mode, click Edit on the Report Explorer Web Part menu
  2. Select Connections > Show report in > Report Viewer


  3. [Figure 5. Connect Report Explorer to Report Viewer]
  4. Click Edit on the Report Viewer Web Part menu
  5. Select Connections > Get report from > Report Explorer


  6. [Figure 6. Connect Report Viewer and Report Explorer]

Step 5: Testing the Web Parts

  1. Exit edit mode
  2. The Report Explorer web part will now display the standard K2 blackpearl reports
  3. Click on the Process Overview report in the Report Explorer web part to display the report
  4. The Report Viewer web part will display the report detail


  5. [Figure 7. Process Overview Report]