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.
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 raj.com.
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.
Share this:
Categories: SharePoint 2013, sharepoint2010, SSRS