Microsoft SQL Server 2008 Reporting Services Unleashed

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Michael Lisin

Jim Joseph

Amit Goyal

The authoritative, example-rich guide to Microsoft’s powerful reporting platform

With Microsoft SQL Server 2008 Reporting Services you can quickly deliver relevant business intelligence data wherever it’s needed–across the entire enterprise, and through the entire reporting lifecycle. SQL Server 2008 Reporting Services Unleashed gives you all the authoritative information you’ll need to make the most of Microsoft’s most powerful reporting platform as a database professional, manager, or user. In-depth coverage makes this book an ideal reference, and its extensive set of practical examples help you address virtually any challenge in deployment, configuration, administration, or report building.

The authors have extensively expanded this edition with deeper reference information, many more practical examples, and insider perspective into Reporting Services 2008’s powerful new enhancements. You’ll discover how to take full advantage of Reporting Services’ significant architectural changes, its flexible new Tablix control, improved visualization through charts and gauges, deep SharePoint integration through SharePoint Integrated Mode, new output presentation formats, and much more.

Understand how to

• Learn about the new features of Service Pack 1 (SP1) and the SQL Server 2008 R2 release
• Quickly take advantage of Microsoft’s newest SQL Server Reporting Services enhancements
• Use Reporting Services to identify trends and solve real business problems
• Master report authoring–from basic, wizard-driven techniques to the cutting edge
• Group, sort, and aggregate data, and define the right scope for your information
• Utilize advanced report formatting techniques
• Work effectively with multidimensional sources
• Manage report data sources and models
• Secure reports against attacks and intrusions
• Customize Reporting Services with embedded functions, custom assemblies, URL access, Web Services, and other extensions
• Thoroughly integrate SQL Server reporting into any SharePoint site

Michael Lisin, lead author of Microsoft SQL Server 2005 Reporting Services, has years of field experience working with SQL Server Reporting Services at Microsoft and delivering solutions for Microsoft’s enterprise customers.

Jim Joseph, co-author of Microsoft SQL Server 2005 Reporting Services Unleashed, is an independent contractor with 10 years experience developing custom software solutions in a variety of industries. He has worked with SQL Server Reporting Services since the first beta release.

Amit Goyal, lead program manager for Microsoft’s Reporting Services team, has extensive insider’s knowledge of SQL Server 2008 Reporting Services.

ON THE WEB:

Download all examples and source code presented in this book from informit.com/sams

Category: Microsoft Databases

Covers: Microsoft SQL Server 2008 Reporting Services

User Level: Intermediate―Advanced

Michael Lisin

has been in the software industry for more than 17 years, with 10 of those years working with Microsoft. Most of his career, Michael has been consulting on SQL Server and business intelligence solutions for Microsoft’s enterprise customers. He has worked with SQL Server Reporting Services since the product’s first pre-beta version in 2002 and has taught Reporting Services classes and presented topics related to SQL Server at various events. Michael earned his MBA at Texas A&M University in 2006 and continues to be a dedicated scholar of Reporting Services. He is now working with business development for Microsoft.

Jim Joseph is an independent contractor with 10 years of experience developing custom software solutions in a variety of industries. He has worked with SQL Server Reporting Services since the first beta release in 2000. He earned his MBA from the University of St. Thomas in 2002. He has worked in a number of roles from developer to database administrator.

Amit Goyal is a senior lead manager for the SQL Server Reporting Services team at Microsoft. Before joining Microsoft, Amit was a director at Yahoo! and worked on development of the Panama search monetization platform. He has 14 years of industry experience at high-tech companies such as Microsoft, Yahoo!, Oracle, and Broadbase Software.He earned his bachelor of science degree from UIUC (University of Illinois at Urbana Champaign) and master’s degree from Stanford University.