Book description
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're running SQL Server as your database engine.
Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic.
Provides best practices for using Reporting Services
Covers the very latest in new features for SQL Server 2012
Your key to delivering business intelligence across the enterprise
Table of contents
- Title
- Dedication
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewers
- Acknowledgments
- Introduction
- Chapter 1: Introducing the Reporting Services Architecture
- Chapter 2: Report Authoring: Designing Efficient Queries
- Chapter 3: Introduction to Reporting Services Design with SQL Server Data Tools
- Chapter 4: Laying Out a Report
- Chapter 5: Implementing Dashboard-Style Report Objects
-
Chapter 6: Building Reports
- Creating a Report with the Report Wizard
- Building Reports from Scratch
- Formatting the Output
- Adding Subtotals
- Adding Interactivity
- Setting Report Parameters with Stored Procedures
- Working with Multivalued Parameters
- Applying a Filter
- Adding a Chart
- Adding Tablix Elements
- Configuring Report and Group Variables
- Adding the Gauge Control
- Adding the Final Touches
- Summary
-
Chapter 7: Using Custom .NET Code with Reports
- Using Embedded Code in Your Report
- Using the ExceedMaxCosts Function
- Using the ExceedMaxCost Function in a Report
- Accessing .NET Assemblies from Embedded Code
- Using Custom Assemblies with Your Report
- Adding a Class Library Project to Your Reporting Solution
- Deploying a Custom Assembly
- Troubleshooting Your Project
- Summary
- Chapter 8: Deploying Reports
- Chapter 9: Rendering Reports from .NET Applications
-
Chapter 10: Managing Reports
- Exploring Management Roles in SSRS Deployment
- Managing Content
- Setting Up a Data Source for the Report
- Altering Report Data Sources
- Creating Snapshots for the Report History
- Performing Execution Auditing and Performance Analysis
- Designing the Log Report
- Monitoring Performance
- Controlling SSRS Programmatically
- Summary
- Chapter 11: Securing Reports
- Chapter 12: Delivering Business Intelligence with SSRS
- Chapter 13: Creating Reports Using Report Builder 1.0, 2.0, and 3.0
- Index
Product information
- Title: Pro SQL Server 2012 Reporting Services, Third Edition
- Author(s):
- Release date: August 2012
- Publisher(s): Apress
- ISBN: 9781430238102
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
Beginning SQL Server Reporting Services
Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports …
book
Microsoft® SQL Server® 2008 Reporting Services Step by Step
Teach yourself how to build, manage, and access SQL Server 2008 reports one step at a …
book
Microsoft® SQL Server® 2012 Integration Services
Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services …