I recently published a new series of blog posts on Fpweb.net’s blog about getting started with SSRS 08 and SharePoint 2007. Once you have setup the infrastructure for the Reporting Services and SharePoint integration, it is quite easy to build tables and bar graphs on your data in SQL using Report Builder 2.0, and display it through your SharePoint 2007 portal. These posts are based on my first experiences with this reporting solution. I’m also excited about the next version of SQL 2008 R2 Reporting Services and SharePoint 2010. SQL 2008 R2 has new spatial data types which allow you to store data like latitude and longitude within SQL. Then you can use Report Builder 3.0 and Reporting Services to build a map view of the data. This would be useful in a number of scenarios and extends the vast amount of solutions you can build on top of SharePoint.
Please visit my articles on the Fpweb.net blog:
Series – Surfacing Company Data with SharePoint and SSRS
Part 1 – It’s Time to Work Your SharePoint Ninja Magic
Part 2 – Configuring the Report Server
Part 3 – Configuring SSRS Add-In on the SharePoint Web Servers
Part 4 – Building a SQL Server Report Using Report Builder 2.0
Thank you for following!
Tags: sharepoint, sharepoint 2007, reporting services, ssrs, fpweb.net