Issues faced while integrating Reporting Services with Sharepoint

Download and install Reporting Services Add-in for Sharepoint Technologies

[http://www.microsoft.com/downloads/details.aspx?familyid=200FD7B5-DB7C-4B8C-A7DC-5EFEE6E19005&displaylang=en]

After install open Central Administration, under Reporting Services section, you should see the following links: Manage integration settings, Grant database access, Set server defaults.

[http://mosshowto.blogspot.com/2009/01/integrating-ssrs-2008-sharepoint-2007.html]

To activate Reporting Services integration on a Site Collection

1. Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. Click Site Actions.
3. Click Site Settings.
4. Click Site Collection Features.
5. Find Report Server Integration Feature in the list.
6. Click Activate.

STSADM can also be used to forcefully activate the RS features if there is some issue with provisioning
stsadm -o activatefeature -name Reporting -url http://[server]/[sitecollection]/ -force