SharePoint is first and foremost a web portal full of reportable data that offers numerous possibilities within an organization. With SQL Server Reporting Services (SSRS), Microsoft offers its own server-based report generation software that is tightly integrated within the SQL Server infrastructure. Integrating SharePoint with SSRS allows the two technologies to create awe-inspiring reports that actively provide information to those who need it. This book walks you through the various challenges of combining SharePoint 2007 with SSRS 2008, and provides you with tips and tricks for handling the obstacles that you may face when attempting to develop reports in your SharePoint environment.
You'll discover the new features of SSRS 2008 while also learning helpful techniques for creating quick and engaging reports when using it. The author team explains special considerations you'll need to take into account when setting up SSRS to run in SharePoint integration mode with WSS 3.0 or MOSS 2007. From the beginning stages of creating an environment that supports SSRS in SharePoint integration mode to the process of planning, developing, and deploying reports to a SharePoint site, this book clearly explains why SharePoint integration mode is ideal for SSRS when dealing with a SharePoint environment.
What you will learn from this book
The best way to set up SQL Server Reporting Services for SharePoint 2007
Best practices for effectively developing and deploying reports in SharePoint
Tips for creating your first report
Ways to configure reporting services to run in SharePoint integration mode
Various advanced reporting and deployment techniques
How to manage reports in SharePoint and use gauges in SharePoint dashboards
Who this book is for
This book is for SharePoint developers who want to know the new features of Microsoft SQL Server 2008 Reporting Services so they can develop and deploy reports in SharePoint.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.