Book description
The Definitive Guide to Microsoft SQL Server 2012 Reporting Services
Create, deploy, and manage business intelligence reports using the expert tips and best practices in this hands-on resource. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2012 Reporting Services, Fourth Edition covers the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are included in this practical reference.
- Plan for, install, configure, and customize SQL Server 2012 Reporting Services
- Retrieve data with SELECT queries
- Generate reports from the Report Wizard and from scratch
- Enhance your reports with charts, images, gauges, and maps
- Add value to reports through summarizing, totaling, and interactivity
- Build reusable report templates
- Embed Visual Basic, .NET functions and subreports into your reports
- Enable end-user access to reports via the Report Server and its Report Manager web interface
- Integrate SSRS reports with your own websites and custom applications
- Follow along with sample reports from the book's case study
Table of contents
- Cover
- Title
- Copyright
- Dedication
- About the Author
- Contents at a Glance
- Contents
- Foreword
- Acknowledgments
- Introduction
- The Galactic Database and Other Supporting Materials
- Part I: Getting Started
-
Part II: Report Authoring
- Chapter 3: DB 101: Database Basics
- Chapter 4: A Visit to Emerald City: The Report Wizard
- Chapter 5: Removing the Training Wheels: Building Basic Reports
- Chapter 6: Graphic Expression: Using Charts, Images, and Gauges
- Chapter 7: Geography Lesson: Using Maps and Spatial Data Types
- Chapter 8: Kicking It Up a Notch: Intermediate Reporting
- Chapter 9: Beyond Wow: Advanced Reporting
-
Part III: Report Serving
- Chapter 10: How Did We Ever Manage Without You? The Report Manager
- Chapter 11: Delivering the Goods: Report Delivery
- Chapter 12: Teamwork: Integrating Reporting Services
-
Chapter 13: Well Begun: Best Practices
- Report-Authoring Practices
-
Report Deployment Practices
- Create a Backup of the Encryption Key
- Review Reports Before Deploying
- Use Linked Reports
- Use Folders and Descriptions to Organize Reports
- Assign Security at the Folder Level
- Assign Security to Domain Groups
- Assign Only the Rights Needed
- Hide Items
- Deploy Supporting Items to the Report Server
- Use Caching and Snapshots
- Where Do We Go from Here?
- Index
Product information
- Title: Microsoft SQL Server 2012 Reporting Services 4/E, 4th Edition
- Author(s):
- Release date: October 2011
- Publisher(s): McGraw-Hill
- ISBN: 9780071760485
You might also like
book
Microsoft SQL Server 2012 Reporting Services
Use your SQL Server skills to create and manage key data reports Deliver interactive business intelligence …
book
Microsoft SQL Server 2008 Reporting Services, 3rd Edition
The Definitive Guide to Microsoft SQL Server 2008 Reporting Services Create and deliver data-rich reports across …
book
Pro SQL Server 2012 Reporting Services, Third Edition
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your …
book
Microsoft® SQL Server 2012 Management and Administration, Second Edition
If you need to deploy, manage, or secure Microsoft SQL Server 2012, this is the complete, …