Report Servers and SharePoint Report Servers (Report Builder 2.0)
A report server is a computer that has SQL Server 2008 Reporting Services installed. It may also be a SharePoint site that is integrated with a report server. The report server stores published reports, shared data sources, shared schedules and subscriptions, and other resources. The report server system administrator can configure the report server to process report requests, maintain snapshot histories, and manage permissions for reports, data sources, and subscriptions.
When you save your report to a report server or SharePoint site integrated with a report server, individuals with appropriate permissions for the report server or the SharePoint site can then run your report. In addition, if you have adequate permissions, you can create subscriptions to your report so that the report can be updated and sent to users on a regular schedule. If you don't have adequate permissions, contact your report server system administrator.
You can specify a default report server or SharePoint site when you install Report Builder 2.0, or in the Options dialog box. For more information, see Working with and without a Report Server (Report Builder 2.0).
Wherever you open a report, you will save it back to the same location by default. For example, if you open a report from a report server, by default you will save it to the server. You can use Save As to save somewhere other than the default.
Saving a Report to a SharePoint Site
When you use Report Builder 2.0 to save reports and related files to a SharePoint library, the files are validated before they are added. If you upload reports and related files by using the Upload action on a SharePoint library, no validation check occurs. You will not know whether the file is valid until you access the report by managing, editing, or running it. You cannot save a report to the root folder of a SharePoint site. You must save to a document library.
In addition, references in a report definition to shared data sources, subreports, and resources such as Web-based images must all be fully qualified URLs to a SharePoint library. For more information, see Specifying Paths to External Items (Report Builder 2.0).