Keywords: SAP R/3 4.6c, SQL2005, SharePoint Portal Server 2003, Business Scorecard Manager 2005
In this tip, I will demonstrate how to present reports on SQL report server on SharePoint page and explore the possibility of using Business Scorecard Manager to present KPIs based on analysis cubes.
Below paragraphs are copied from MSDN, http://msdn2.microsoft.com/ms159772.aspx and some minor adjustments are taken.
Install Web Parts
1. Go to SharePoint server
2. To install the .cab file from the command line, run the following code: C:Program FilesCommon FilesMicrosoft Sharedweb server extensions60BINSTSADM.EXE -o addwppack -filename “C:Program FilesMicrosoft SQL Server90ToolsReporting ServicesSharePointRSWebParts.cab”
Add the Web Parts to a Web Part Page
Once the Web parts are installed, users can then add Report Explorer and Report Viewer Web parts to a Web Part Page through the SharePoint window. You must have permission to create Web sites and add content.
To add the Report Explorer and Report Viewer Web Parts to a Web Part Page 1. From an existing site in SharePoint, click the Create button in the SharePoint toolbar.
2. Scroll down to the Web Pages section, and then click Web Part Page.
3. Type a name, select a layout template, and then enter the location where you want to save your Web Part Page.
4. The Web Part Page appears and is divided into sections called zones.
5. Click the Create button at the bottom of the page. A new Web parts page appears in the layout you selected.
6. At the top of the new page, click Modify Shared Page, point to Add Web Parts, and then click Browse.
7. Select the name of the gallery where the Reporting Services Web parts were installed. In SharePoint Services, the default gallery is Virtual Server Gallery.
8. From the Web part list, select the Report Explorer Web part or the Report Viewer Web part, and then drag it to the zone where you want the Web part to appear.
9. Modify the Report Explorer Web part -> Change its web part property -> Input the report manager URL & start path.
Connect Reporting Services Web Parts
If you add the Report Explorer and the Report Viewer Web parts to the same SharePoint page, you can connect them so that when you select a report in the Report Explorer, the report appears in the Report Viewer. If the Report Explorer and Report Viewer are not connected, the selected report appears in a separate page.
To connect the Report Explorer and Report Viewer Web Parts
1. Click Modify Shared Web Part on the Web part page, and then select the Report Explorer Web part.
2. On the Report Explorer toolbar menu, click the down arrow, point to Connections, point to Show Report In, and then click Report Viewer.
3. Click OK.
Finally the SharePoint web part page is like below figure.
For Business Scorecard Manager 2005, the road map is like below figure. I will not give the details.
1. Viewing Reports with SharePoint Web Parts , Microsoft, http://msdn2.microsoft.com/ms159772.aspx, accessed in Jan., 2006
2. Use SQL2005 to Connect and Present SAP on SharePoint / Business Scorecard Manager Part I, Ted Teng, /people/ted.teng/blog/2005/12/28/use-sql2005-to-connect-and-present-sap-on-sharepoint-business-scorecard-manager-150-part-i, accessed in Jan., 2006.
3. Use SQL2005 to Connect and Present SAP on SharePoint / Business Scorecard Manager Part II, Ted Teng, /people/ted.teng/blog/2005/12/28/use-sql2005-to-connect-and-present-sap-on-sharepoint-business-scorecard-manager-150-part-ii , accessed in Jan., 2006.
4. Use SQL2005 to Connect and Present SAP on SharePoint / Business Scorecard Manager Part III, Ted Teng, /people/ted.teng/blog/2005/12/29/use-sql2005-to-connect-and-present-sap-on-sharepoint-business-scorecard-manager-150-part-iii , accessed in Jan., 2006