Step by Step process of Integrating SSRS to SharePoint 2010
Using Reporting Services in Sharepoint 2010. What is SSRS ? SQL Server Reporting Services 2008 (SSRS) is a feature included in the SQL Server 2008 product. SSRS is used to design, develop, test, and deploy reports. When SSRS is installed, there are two databases i.e. ReportServer$SQLSTANDARD and ReportServer$SQLSTANDARDTempDB created by default. You can also configure these databases manually using the Reporting Services Configuration Manager. Also a developer-centric tool called Business Intelligence Development Studio (BIDS) is installed automatically, which can be used through Visual Studio 2008. BIDS uses Report Designer, a developer tool for building complex reports. Report Builder 3.0 on the other hand provides a simpler user interface for creating reports, directed primarily at business users rather than developers. Prerequisite to integrate SSRS with SharePoint 2010 . 1) Download and Install the prerequisite SSRS 2008 R2 Add-in for SharePoint along with other re...