- You have a Microsoft SQL Server Reporting Services 2008 R2 (SSRS 2008 R2) or Microsoft SQL Server Reporting Services 2012 (SSRS 2012) report for a Microsoft SharePoint list or Document Library.
- The report uses a built-in SQL Server Reporting Services SharePoint List data extension.
- You build a dataset query that is based on the SharePoint list or Document Library, and then you run the query in the report designer.
- You deploy the report to the SharePoint farm that hosts the SharePoint list or Document Library.
For example, you create a new view in SharePoint in which you select the Show all items without folders view option in a Document Library. You set the new view as the default view for the document library. In this situation, the report returns different data in the SharePoint farm than in the report designer.
Note If you deploy the report to the SharePoint site, only the top level folders and files of the Document Library are returned. However, the report designer returns all files that reflect the default view change regardless of folder locations.
However, when the report designer runs the report, the report uses the SPRemoteConnection path. This path uses SOAP calls that resemble the GetListCollection function. This function accesses the site through a remote HTTP connection instead of the local connection. Therefore, changes will be reflected in the default view configuration.
- Deploy the report to a native mode report server, and then run the report from the native mode report server.
Note If you have to view the report in SharePoint, install the native mode Report Viewer Web Part in SharePoint, and then call the report from your native instance of Reporting Services.
For more information about how to view and explore native mode reports by using SharePoint Web Parts, go to the following MSDN website:
- Deploy the SharePoint List or Document Library to a different SharePoint farm that can be accessed by the farm that you have the report deployed to. Therefore, the report in the local farm can access the list remotely.
- Use an XML data extension to build an XML query without using the SharePoint List data extension.
Article ID: 2826162 - Last Review: Mar 19, 2013 - Revision: 1