Product Cover Image

Microsoft SQL Server 2012 Reporting Services

By Stacia Misner

Published by Microsoft Press

Published Date: Apr 15, 2013


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

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