SQL Server Reporting Services in SharePoint Server
SQL Server Reporting Services gives you the services that help you generate and manage reports for a firm.
This is done on a Website or in SharePoint server as well. It has also some programming features, which enabls you to perform customization of the reports. The report tools generally work with an Office-type application. These are fully compiled and compatible with SQL Server components.
The compatibility is also to a great deal within the SharePoint Server environment. One can easily generate reports on SharePoint lists, and publishing the reports to SharePoint Server 2007 or to the SharePoint Server 2010 can be done quite easily. In addition, full management of your published reports in SharePoint libraries is also accomplished.
While using the SQL Server Reporting Services with SharePoint Server, there are usually two modes available to you and you can choose the one you think is good for you to work with.
The standard mode is called as the "Connected mode". It needs the SharePoint Server, the SQL Server Reporting Services add-in and the the SQL Server 2008 R2 Report Server to work efficiently.
The other mode is called to be "Local mode". It is a light setup. It is used for the Reporting Services to apply them with the SharePoint Server. It also needs the SharePoint Server and the SQL Server Reporting Services add-in.
You can also make use of the SQL Server Reporting Services when you want to deliver the reports, which are published at the set intervals and are specially ordered on demand. It is also appropriate where the report requirements are well needed and customers are not much familiar with the dataset for the work.
(Excerpted from the Microsoft website.)
Comments