Microsoft SQL Server 2012 Reporting Services

by Misner, Stacia

• ISBN13: 9780735658202
• ISBN10: 073565820X
• Edition: 1st
• Format: Paperback
• Copyright: 2013-04-15
• Publisher: Microsoft Press

Summary

Conquer Microsoft® SQL Server® 2012 Reporting Services-from the inside out! You're beyond the basics, so dive right in and really put this report generation application to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts prepare and deliver a variety of interactive and printed reports using SQL Server 2012-and challenge yourself to new levels of mastery. Install and configure SQL Server Reporting Services Put Report Builder and Report Designer tools to work Create interactive, online reports that enable users to sort and filter data Add charts and gauges to present data visually Deploy reports to Microsoft SharePoint® Server Monitor server performance and help secure content Use subscriptions to distribute reports via email Build ad hoc reports and extend them with custom code

Author Biography

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.

Table of Contents

• 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