Here are a list of references for those interested in setting up, configuring, operating and managing a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. If there's any area needing more attention or references, please add those topics to the comments below. Thanks for choos
Reporting Services and SharePoint Technology Integration at http://msdn.microsoft.com/en-us/library/bb326358.aspx
Setup and Configuration (Should we install Reporting Services on the SQL box? And answers to other such questions)
How to: Configure SharePoint Integration on Multiple Servers at
http://msdn.microsoft.com/en-us/library/bb677365.aspx
How to: Configure SharePoint Integration on a Standalone Server at
http://msdn2.microsoft.com/en-us/library/bb677368.aspx
(To pass SharePoint token or Kerberos token; whether stored credentials is enough for report data sources or integrated windows is a requirement)
Security Overview for Reporting Services in SharePoint Integration Mode at http://technet.microsoft.com/en-us/library/bb283324.aspx
Identity delegation for SQL Server Reporting Services (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/gg502598.aspx
Working with Report Server items on a SharePoint site
Working with Report Server Items in a SharePoint Site (Reporting Services in SharePoint Integrated Mode)
http://technet.microsoft.com/en-us/library/bb283321.aspx
Viewing and Managing Report Server Items from a SharePoint Site
http://technet.microsoft.com/en-us/library/bb326347.aspx
How to: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode)
http://msdn.microsoft.com/en-us/library/bb326289.aspx
Granting Permissions on Report Server Items on a SharePoint Site
http://technet.microsoft.com/en-us/library/bb326215.aspx
Setting Processing Options
How to: Set Processing Options (Reporting Services in SharePoint Integrated Mode)
http://technet.microsoft.com/en-us/library/bb283188.aspx
Caching Reports (SSRS) -
http://technet.microsoft.com/en-us/library/ms155927.aspx
For more information about cache refresh plans, see Scheduling Reports, Shared Datasets, and Subscriptions
Caching Shared Datasets (SSRS) -
http://technet.microsoft.com/en-us/library/ee636149.aspx
Creating, Modifying, and Deleting Snapshots in Report History
http://technet.microsoft.com/en-us/library/ms156325.aspx
How to: Create Report History (Reporting Services in SharePoint Integrated Mode)
http://technet.microsoft.com/en-us/library/bb326416.aspx
Use the Reporting Services web part
Report Viewer Web Part (Reporting Services in SharePoint Integrated Mode) http://technet.microsoft.com/en-us/library/ee210703.aspx
How to: Add the Report Viewer Web Part to a Web Page (Reporting Services in SharePoint Integrated Mode)
http://technet.microsoft.com/en-us/library/bb326362.aspx
Using the Report Viewer Web Part on a SharePoint Site
http://technet.microsoft.com/en-us/library/bb522800.aspx
How to: Connect Filter or Documents Web Part (Reporting Services in SharePoint Integrated Mode)
http://msdn.microsoft.com/en-us/library/bb283248.aspx (we can use the Web Part page option; we have to enable popup; when we select Connection on the Text Filter, we specify outgoing connection
– it is not complete till the popup dialog shows the report parameter option to bind the connection; for the scenario of using one web part to show multiple reports, the Incoming connection of the report viewer web part could be used when the page has the
other web part showing the reports available)
Programming against the end point
SharePoint Proxy Endpoints section of
http://msdn.microsoft.com/en-us/library/ms155398.aspx can be referred
Hope this is useful for those working with SQL Server Reporting Services in SharePoint integrated mode.
