Use your SQL Server skills to create and manage key data reports
Deliver interactive business intelligence reports using SQL Server 2012 Reporting Services, and help facilitate real-time decision making throughout the enterprise. SQL Server expert Stacia Misner shows you in detail how to design, manage, and access custom reports that capture data from multiple sources. This book is ideal for experienced SQL Server developers, whether you're new to Reporting Services or upgrading from an earlier version.
Discover how to:
Use the latest features, including the Power View ad hoc reporting tool
Design reports by understanding how your audience accesses and uses data
Add interactive features to help end users sort and filter data
Create rich data visualization with charts, gauges, indictors, and data maps
Configure your report server, provide security, and monitor report contents
Use SharePoint or Report Manager to search and access reports online
Create a library of report parts that clients can use for ad hoc reporting
Build and manage reports using Reporting Services as a development platform
Sprache
Verlagsort
Zielgruppe
Maße
Höhe: 232 mm
Breite: 189 mm
Dicke: 49 mm
Gewicht
ISBN-13
978-0-7356-5820-2 (9780735658202)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.
Introduction
Getting started with Reporting Services
Chapter 1: What's new in Microsoft SQL Server 2012 Reporting Services
Chapter 2: Introducing the Reporting Services environment
Chapter 3: Understanding deployment scenarios
Chapter 4: Installing Reporting Services
Chapter 5: Exploring Reporting Services fundamentals
Developing reports
Chapter 6: Planning your report design
Chapter 7: Working with report server projects
Chapter 8: Retrieving data for a report
Chapter 9: Designing the report layout
Chapter 10: Working with the tablix
Chapter 11: Developing expressions
Chapter 12: Using functions
Chapter 13: Adding interactivity
Chapter 14: Creating dynamic reports with parameters
Chapter 15: Managing the page layout
Chapter 16: Using Analysis Services as a data source
Adding data visualizations
Chapter 17: Creating charts
Chapter 18: Working with chart elements
Chapter 19: Comparing values to goals with gauges
Chapter 20: Displaying performance with indicators
Chapter 21: Mapping data
Chapter 22: Working with map elements
Managing the report server
Chapter 23: Deploying reports to a server
Chapter 24: Securing report server content
Chapter 25: Performing administrative tasks
Viewing reports
Chapter 26: Accessing reports online
Chapter 27: Working with subscriptions
Chapter 28: Data alerting
Ad hoc reporting
Chapter 29: Reusing report parts
Chapter 30: Preparing to use Power View
Chapter 31: Using Power View
Using Reporting Services as a development platform
Chapter 32: Understanding Report Definition Language
Chapter 33: Programming report design components
Chapter 34: Programming report server management
Chapter 35: Programming report access
About the authors
