Saturday, August 10, 2013

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.


Post a Comment