Professional Microsoft SharePoint 2007 Reporting with SQL Server 2008 Reporting Services

Essential guide to developing and deploying high-profile reports in SharePoint

Build customized reports quickly and efficiently with SQL Server 2008 Reporting Services for SharePoint sites and this unique guide. Developers, you''ll learn report development and deployment; SharePoint or SQL Server Reporting Services administrators, you''ll see how to leverage SharePoint to use SQL Server Reporting Services in SharePoint Integrated Mode.

This valuable book walks users through the entire process: planning, developing, and deploying reports. You''ll discover techniques, tricks, and workarounds that allow you to produce great-looking charts and reports for your SharePoint sites.

• SQL Server Reporting Services (SSRS) is the customizable reporting solution for any developer using VB, C#, or ASP.NET who ties into SQL Server to build reports or generate data analysis; SharePoint is Microsoft''s portal development platform and is central to the Microsoft Office and developer platform
• This book from an expert author team of Microsoft SharePoint 2007 developers covers not only topics relevant to developers, it also goes into the specific nuances of using these reports in a SharePoint environments, such as what to consider when setting up SSRS to run specifically in SharePoint integration mode with WSS 3.0 or MOSS 2007
• Topics include introduction to SQL Server Reporting Services, setting up SQL Server Reporting Services for SharePoint 2007, planning your report project, an overview of Business Intelligence Design Studio (BIDS) 2008, intermediate and advanced reporting techniques, deploying to SharePoint 2007, displaying reports, and more

Discover new, efficient ways to leverage your core investment in SharePoint 2007 with this one-of-a-kind guide.

Wrox Programmer to ProgrammerTM

Professional Microsoft® SharePoint® 2007 Reporting with SQL Server® 2008 Reporting Services

Coskun Cavusoglu, Jacob J. Sanford, Reza Alirezaei

Updates, source code, and Wrox technical support at www.wrox.com

Professional

Microsoft®

SharePoint® 2007 Reporting

with SQL Server® 2008 Reporting Services

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.