SharePoint Planet: Integrating SharPoint 2010 and Sql Reporting Services 2008

Integrating SharPoint 2010 and Sql Reporting Services 2008

We can configure reporting services with few easy steps:
1. Configuring Web Service URL
2. Create a Report Database
3. Creating a Report Manager URL
4. Report Service Integration
5. Adding a Report Server to the Integration
6. Verifying the server
Simply go to SQL Server 2008 à Configuration Tools–>Reporting Services Configuration Manager and choose Web Service URL and fill the information.

Next we need to create a database i.e. Report Database

Connect to the database where you want your Report Data to be stored:

Check the connection by clicking on the Test Connection once that is done click next

Mention the database name and Report Server Mode depending on the level, I mentioned Sharepoint Integrated Mode.
Specify the credentials that the report server will use to connect to the database.

Review configuration.

click next

Step3: Creating a Report Manager
What this does is that it configures the IIS for you depending on what Virtual Directory names you had declared.

Step4:
Reporting Service Integration
go to central admin– general application setting — reporting service integration

enter the fields that are required

check for the activation message

Step5:
Adding a Report Server to the Integration

Step6:
Checking the server by uploading a report
go to site setting–> in site collection administrator –> site collection feature and activate report server integration