how to integrate the report service into SharePoint 2010

Report Service 可以整合進 SharePoint 2010. 因此 user 可在不同的site執行已經定義好的報表.例如我可以在sales的site執行跟sales 有關的報表且該報表受site permission管理.
設定如下:
1. 開啟 reporting services configuration manager
2. 進入 Database -> Change database -> select "sharepoint Integrated Mode" and DB Name is RS_SharePoint
3. RS will created a DB under SQL\MSSQLSERVER ( default instant name)
4. open Central Administrator by admin
5. select "General Application Setting -> Report Service Integration
6. set "report server web service URL to http://servername:80/reportserver and use "windows authentication"
7. SharePoint will auto configurate, sometime we need manually to turn on ( activate) Report service
8. click "Site Action" -> site setting
9. select "Site Collection features" under "Site Collection Administration" and active "Report Server Integration Feature" & "Report Server Central Administration Feature"
10. upload .rdl to document
11. right click this rdl to open setting.
12. run this report on SP