Integrate Report Service 2008 with SharePoint

最新推荐文章于 2025-09-12 16:27:02 发布

原创最新推荐文章于 2025-09-12 16:27:02 发布 · 696 阅读

CC 4.0 BY-SA版权

文章标签：

Report Server Requirements

A report server that runs in SharePoint integrated mode has edition and software requirements:

The report server computer must satisfy the hardware and software requirements for SQL Server installations. For more information, see Hardware and Software Requirements for Installing SQL Server 2008.
Edition requirements for Reporting Services in SharePoint integrated mode include Developer, Evaluation, Standard, or Enterprise editions. There is no support for this feature in the Workgroup edition or in SQL Server Express with Advanced Services.
The report server database must be created for SharePoint integrated mode.
To join a report server to a SharePoint farm, the report server must be installed on a computer that has an instance of a SharePoint product or technology. You can install the report server before or after installing the SharePoint product or technology instance.
The version of the SharePoint product or technology that you install on the report server computer must be the same version that is used throughout the farm. If you are adding a report server to a Office SharePoint Server 2007 server farm, you must have at least a minimal installation of Office SharePoint Server 2007 on the report server computer. You cannot have a combination of Windows SharePoint Services 3.0 and Office SharePoint Server 2007 in the same server farm. For more information about how to join a report server to a SharePoint farm, see How to: Install a SharePoint Web Front-end on a Report Server Computer.

SharePoint Product and Technology Requirements

The SharePoint server farm that you integrate with Reporting Services has the following edition and software requirements:

Edition requirements for the SharePoint product or technology are Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. If you use Microsoft Office SharePoint Server , you must run either the Standard Edition or the Enterprise Edition of Microsoft Office SharePoint Server 2007.
Reporting Services Add-in for SharePoint Technologies must be installed on the Web front-end. The Reporting Services Add-in provides server integration features and Web application pages for accessing report server items from a SharePoint site. The add-in must be installed on each Web front-end in the server farm through which users will access reports and other items.
You must have at least 2 gigabytes of RAM on the Web front-end computer.
Anonymous access cannot be enabled on the SharePoint Web application. If Anonymous access is enabled, you will be able to configure integration settings but users will get an error when they run a report. All other authentication providers and options are supported. If you are configuring integration between a report server and a SharePoint farm, each SharePoint Web application in the farm can be configured to use different authentication providers.

To publish a report to a SharePoint site

In Business Intelligence Development Studio, open an existing or new Report Server project.
From the Project menu, click Properties. The <project> Property Pages dialog box opens.
In the Configuration list, select the name of a solution build configuration to use to build and publish your report. The current configuration is listed as Active(<configuration>).
If you want to publish the shared data sources in your project and overwrite previously published shared data sources, set OverwriteDataSources to True.
(Optional) For TargetDataSourceFolder, type a URL to a SharePoint library or library folder (for example, http://TestServer/TestSite/Documents/DataSources).

If you do not specify a value, the TargetReportFolder value is used.
For TargetReportFolder, type a URL to a library or library folder (for example, http://TestServer/TestSite/Documents/Reports).
For TargetServerURL, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used (for example, http://servername, http://servername/site, or http://servername/site/subsite).
Click OK.
In Solution Explorer, right-click the report you want to publish, and click Deploy. The report is published to the location specified in TargetReportFolder. Deployment errors appear in the Output window.