Saturday, August 10, 2013

How to Configure SSRS for SharePoint Integration Mode in SharePoint 2010?

Here in this article we will discuss how to Configure SSRS for SharePoint Integration Mode in sharepoint 2010? Also you can check out my previous posts on:

- Change due date for Task list in SharePoint designer 2010 workflow

- How to create a Site Definition using Visual studio 2010 in SharePoint 2010?

- Working with SharePoint 2010 search web service

SSRS has two modes.
1-Native mode:Build reports by hand and then look at them.

2-Integration mode:SharePoint Integration mode allows you to add Reporting Services content types to SharePoint, and then build and manage your reports from SharePoint.
Below are the steps:

Step-1. Click Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Reporting Services Configuration Manager.

Step-2. On pop-up window, click Connect.

Step-3. From the left-hand side of the window, click Web Service URL.

Step-4. Click the Advanced button.

Step-5. Click Add for the HTTP section.

Step-6. Select Host Header Name and enter

Step-7. Click OK.

Step-8. Highlight the "all assigned listener" item above it and click Remove.

Step-9. Click OK.

Step-10. Click Database on the left.

Step-11. Click the Change Database button.

Step-12. Select "Create a new report server database" and click Next.

Step-13. For "Connect to Database Server," accept the defaults and click Next.

Step-14. From the Report Server Mode, select SharePoint Integrated Mode.

Step-15. Click Next.

Step-16. For Authentication Type, leave Service Credentials and click Next.

Step-17. From the Summary screen, click Next.

Step-18. Everything will be successful, and you can click Finish.

Step-19. All other settings should work as it is, so click Exit.