SQL Server 2016 Database Reporting

SQL Server 2016 Database Reporting

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

Read 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

Create impressive reports from your SQL Server data

About This Video

  • Utilize graphical report elements in the SQL Server 2016 Reporting Services developer toolbox

  • Write SQL Server queries that are optimized for specific report types

  • Learn advanced concepts such as drill-through reports and analytical maps

    • In Detail

    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.

    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.

    Publisher resources

    Download Example Code

    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