Professional Microsoft SharePoint 2007 Reporting with SQL Server 2008 Reporting Services

by Cavusoglu, Coskun; Sanford, Jacob J.; Alirezaei, Reza

• ISBN13: 9780470481899
• ISBN10: 0470481897
• Edition: 1st
• Format: Paperback
• Copyright: 2009-09-22
• Publisher: Wrox

Summary

Many companies have adopted SharePoint (over 75 million licenses), and now they are looking at different ways in which they can leverage this core investment. This book is aimed at SharePoint developers who need to know the new features of Microsoft SQL Server 2008 Reporting Services so they can effectively develop and deploy reports in SharePoint. SharePoint administrators will also use this book to learn how to set up SharePoint to use SQL Server Reporting Services in SharePoint integration mode. Finally, SQL Server administrators get the most out of configuring reporting services to run in SharePoint integration mode, and in many cases SharePoint administrators and SQL Server admins may be the same person.This book illustrates the new features of Microsoft SQL Server 2008 Reporting Services (SSRS), specifically targeting its SharePoint integration mode. It covers not only topics relevant to any developer interested in creating quick and great looking reports using SSRS, it also goes into the specific nuances of using these reports in a SharePoint environment, including the special considerations when setting up SSRS to run specifically in SharePoint integration mode with WSS 3.0 or MOSS 2007.Professional SharePoint 2007 Reporting with SQL Server 2008 Reporting Services takes the reader from the beginning stages of creating an environment that supports SSRS in SharePoint integration mode through the processes of planning, developing, and deploying reports to a SharePoint site. This book provides tips and tricks to get around some of the known limitations of the product when used in this fashion. It also helps the reader understand why SharePoint integration mode is preferable for SSRS when dealing with a SharePoint environment.Some topics covered 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 Reporting Techniques Advanced Reporting Techniques Deploying to SharePoint 2007 Displaying your Report Bringing it all together

Author Biography

Coskun Cavusoglu is the Director of Consulting Services and the Chief Solution Architect of Captaré Consulting, LLC. He has been architecting and implementing technology solutions for more than 10 years in both large, enterprise organizations and fast - growth midmarket firms. As a Software Engineer specializing in the .NET Framework and the Office Server System, specifically Windows SharePoint Services and Microsoft Office SharePoint Server, he has extensive experience designing, implementing, and supporting Internet solutions using Microsoft technologies. Coskun is a technology writer, blogger, and published author on Microsoft server products. His latest book which he co - authored with fellow SharePoint experts is Professional Microsoft SharePoint 2007 Design by Wrox Publishing. He also is a speaker who attends various community events both locally and internationally where he talks about SharePoint topics and his past and future engagements can be found at his blog, www.Share-PointCoskun.com . Coskun is a Microsoft Certified Professional and is also an MCTS for SharePoint Portal Server 2003 and Microsoft Office SharePoint Server 2007.

Jacob J. Sanford is a senior consultant with Resolute Solutions Corporation, a Microsoft Gold Certified Partner and a National Systems Integrator. He has been working with web application development using Microsoft technologies for more than 10 years, specializing in .NET solutions since the 1.0/1.1 Framework. Jacob is a frequent speaker at local and regional .NET and SharePoint events and is the creator of the Tallahassee SharePoint Experts Exchange for Developers (SPEED), a SharePoint User Group in Tallahassee, FL. He has written two previous books for Wrox Press: ASP.NET 2.0 Design (September 2007) and Professional Microsoft SharePoint 2007 Design (September 2008). Jacob is a Microsoft Certified Technology Specialist in the .NET Framework 2.0 (Web Applications) and a Microsoft Certified Technology Specialist (Microsoft Dynamics CRM 4.0 Customization and Configuration).

Reza Alirezaei is an independent consultant and Microsoft Office SharePoint Server MVP with a focus on developing custom solutions with SharePoint, Office, Reporting Services, and the .NET platform. As a technical leader with more than 10 years of experience in software, he has helped many development teams architect and build large - scale, mission - critical applications. This former SQL Server Reporting Services MVP has been also nominated and awarded three times as one of the Top 20 Contributors to the Microsoft Developer Network (MSDN) Wiki since 2006. In addition to consulting, Reza is a SharePoint instructor and speaker. He speaks at many local and international conferences. Reza frequently blogs at http://blogs.devhorizon.com/reza and can be reached at [e-mail] .

Table of Contents

Introduction.

Chapter 1: An Introduction to SQL Server Reporting Services.

Chapter 2: Setting up SQL Server Reporting Services for SharePoint 2007.

Chapter 3: Planning Your Report Project.

Chapter 4: Overview of Business Intelligence Design Studio (BIDS) 2008.

Chapter 5: Creating Your First Report.

Chapter 6: Intermediate Reporting Techniques.

Chapter 7: Advanced Reporting Techniques.

Chapter 8: Deploying Reports to SharePoint.

Chapter 9: Advanced Deployment Techniques.

Chapter 10: Displaying Your Reports in SharePoint Integrated Mode.

Chapter 11: Managing Reports.

Chapter 12: Using Gauges in SharePoint Dashboards.

Index.