Integrate Reporting Services 2008 with SharePoint Server 2010

Short instruction:

1. Install MS SQL Server Reporting Services (SSRS) 2008 R2 in SharePoint Integrated mode. The service should run under domain account, do not use built-in account like SYSTEM.
2. Enable reporting services for SharePoint farm. Go to SharePont Administration Center, open General Application Setings - Reporting Services - Add Report Server. Specify RS URL (http:///reportserver), domain account to connect. If feature activated successfully for all site collections, on Defaults settings page make sure parameters 'Enable Windows Authentification' and 'Enable RS ActiveX sownload' are on.
3. Create reports library. Open your SharePoint site and create new Document Library (by default), open Library settings - Advances Settings and set 'Allow management of content types' on. Return to library settings and click 'Add from existing types' link in Content Types settings. In dialog, choose 'Reporting Services content types' group and add all available types.
4. Deploy reports with SQL Server BI development studio. In your report project properties, set TargetServerURL = http://server, TargetReportFolder = http://server/site/list. The same for TargetDataSourceFolder. In common case you can use different lists to store reports and datasources. Instead VS you can deploy with PowerShell using this script.
5. You can add report on any page of SharePoint site with special RS webpart.