Let’s face it, Reports are the most important part of every application. This holds true for Sharepoint. Sharepoint may have been implemented and now you are storing Documents, using Lists, Workflows, …etc. Now you want to get reports on all this data. There also may be the need to combine data from Sharepoint with other systems such as Accounting. How is this done? Unfortunately, it is not as straightforward as one might think.
While Sharepoint content is stored in a SQL Database, it is not easily accessible with normal SQL Queries. To truly access your data, it needs to within a standard SQL table.
SQL Server Reporting Services (SSRS) is one option for reporting in Sharepoint. SSRS allows custom reports that can be built upon tables that store Sharepoint data as well as other application data.