Microsoft SQL Server 2008 Reporting Services Unleashed

Description

Table of Contents

Introduction 1

Part I     Introduction to Reporting Services

1 Introduction to SQL Server Reporting Services (SSRS)

2 Reporting Services 2008 Architecture

3 Getting Started with Reporting Services Tools

4 What's New in SQL Server Reporting Services 2008

5 Reporting Services Deployment Scenarios

6 Installing Reporting Services

Part II Report Authoring from Basic to Advanced

7 Report Server Project Wizard

8 Report Designer(s)

9 Report Definition Language

10 Expressions

11 Accessing Data

12 Report Parameters

14 Grouping, Sorting, Aggregating Data, and Working with Scope

15 Advanced Report Formatting

16 Report Navigation

17 Working with Multidimensional Data Sources

18 Ad Hoc Reporting

Part III Reporting Services Management

19 Managing Reports, Data Sources, and Models

20 Securing Report Server Items

21 Report Execution and Processing

22 Subscribing to Reports

23 SSRS Administration

24 RS Utility

Part IV Reporting Services Customizations

25 Implementing Custom Embedded Functions

26 Creating and Calling a Custom Assembly from a Report

27 Using URL Access

28 Using Reporting Services Web Services

29 Extending Reporting Services

Part V SharePoint Integration

30 Reporting Services Integration with SharePoint

31 SSRS 2008 SharePoint Integration Architecture

32 Installation of Reporting Services Integrated with SharePoint

33 SharePoint Mode Administration

34 Tools Support for SSRS Integrated with SharePoint

35 Viewing Reports in SharePoint

36 Managing Reports in SharePoint

37 Ad Hoc Reporting in SharePoint

Part VI Appendixes

A References and Additional Reading

B Glossary

C Frequently Asked Questions and Additional Information

D What's New in SQL Server SP1

E What's New in SQL Server 2008 R

Back Cover

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

Author

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.