Microsoft SQL Server 2008 Reporting Services Unleashed
Published on 6. August 2009
Book
Paperback/Softback
696 pages
978-0-672-33026-1 (ISBN)
Description
Microsoft (R) SQL Server (TM) 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
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
More details
Persons
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.
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.
Content
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
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