SQL Server 2016 Database Reporting

SQL Server 2016 Database Reporting

by Dr. Dallas Snider
Released February 2017
Publisher(s): Packt Publishing
ISBN: 9781787121249

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

With SQL Server 2016 Reporting Services, users are excited about being able to visualize their data in new, creative ways for use in presentations, analysis, and decision support—even on mobile devices.

In this course, users will receive step-by-step instructions on how to create stunning, high-impact reports. The course starts with an introduction to the technologies employed. Next, users are shown how to create a basic report and then how to format it and add features (such as headers and footers) to make it more readable, impressive, and practical. The course teaches how to create drill-down and drill-through reports. Pie charts, gauges. and maps are next on the agenda and the course wraps up with lessons on how to assemble a dashboard on the SQL Server Reporting Services web portal. This course will empower you to overcome any obstacle while creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services.

What You Will Learn

  • Define a SQL Server Reporting Services data source in the Report Wizard
  • Add a new column and change the column headers in a report
  • Create new data fields for use in the report without changing the query or stored procedure
  • Write queries that are specialized for drill-down reports, and create the drill-down report object
  • Explore different parameter types in SQL Server Reporting Services
  • Configure the parent report to support drill-through actions
  • Write queries that are optimized for maps and add maps to your reports
  • Write queries to utilize gauges, spark lines, and indicators in a report
  • Deploy and secure reports on the web portal

Audience

This course is for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016. Previous experience with SSRS would be useful, but is not mandatory. A basic working knowledge of SQL Server is required to get the most out of this course.

About The Author

Dr. Dallas Snider: Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida. He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received a B.A. in Physics from Hendrix College. Before joining UWF, he worked as a data warehouse developer for Northrop Grumman Information Systems and prior to that as a database application developer for Acxiom. Dr. Snider's teaching and research interests include data mining, data warehousing, information visualization, and cyber security.

Table of contents

  1. Chapter 1 : Installation and setup
    1. The Course Overview
    2. Installing and Configuring SQL Server 2016 Developer Edition
    3. Installing SQL Server Management Studio
    4. Installing Visual Studio
    5. Installing SQL Server 2016 Data Tools
    6. Installing SQL Server Sample Databases
    7. SQL Server 2016 Reporting Services Configuration Manager
  2. Chapter 2 : Wizarding Your First Report
    1. Data Sources
    2. Report Queries
    3. Tabular Report Types and Their Configuration
    4. Matrix Report Types and Their configuration
    5. Deployment Location and Completing the Wizard
  3. Chapter 3 : Formatting a Tabular Report
    1. Adding a Column after the Wizard
    2. Formatting Column Headers
    3. Interactive Sorting
    4. Adding Calculated Fields and Using Expressions
    5. Formatting Cells
    6. Viewing the Report on the Report Server
    7. Formatting the Report for Printing
  4. Chapter 4 : Adding Headers and Footers
    1. Adding the Header and Footer
    2. Using Built-in Fields
    3. Adding Query-Defined Fields
    4. Adding Images to the header
    5. The Importance of Displaying Report Metadata on the Report
  5. Chapter 5 : Creating a Drill-Down Report
    1. Queries Specialized for Drill- Down Reports
    2. Creating the Drill- Down Report
    3. Grouping in SSRS
    4. Toggling the Display
    5. Adding Summary Rows
  6. Chapter 6 : Using Parameters in a Report
    1. Parameter Types
    2. Available and Default Values
    3. Filtering by the Parameter Value
    4. Displaying Parameter Values Within the Report
  7. Chapter 7 : Creating a Drill-Through Report
    1. Creating a Child Report
    2. Adding a Parameter to a Query
    3. Configuring the Drill-Through Reporting Action
    4. Deploying the Drill-Through Reports to the Report Server
  8. Chapter 8 : Baking Pie and Bar Charts
    1. Queries Optimized for Pie Charts and Bar Charts
    2. Creating the Pie Chart Report
    3. Creating the Bar Chart Report
    4. Formatting the Legends and Labels
    5. Placing Two Subreports Onto One Report
  9. Chapter 9 : Gauges, Sparklines, and Indicators
    1. Queries Optimized for Gauges, Sparklines, and Indicators
    2. Creating a Report Containing a Gauge
    3. Creating a Report Containing a Sparkline
    4. Creating a Report Containing an Indicator
    5. Creating a Dashboard
  10. Chapter 10 : Analytical Maps
    1. Queries Optimized for Analytical Maps
    2. Creating a Point Map
    3. Creating an Analytical Line Map
    4. Creating a Bubble Map
    5. Creating a Polygon Map
  11. Chapter 11 : The Reporting Services Web Portal
    1. Web Portal Folder Structure
    2. Deploying Reports to the Portal
    3. Securing Reports on the Portal
    4. Web Portal Functionality

Product information

  • Title: SQL Server 2016 Database Reporting
  • Author(s): Dr. Dallas Snider
  • Release date: February 2017
  • Publisher(s): Packt Publishing
  • ISBN: 9781787121249