SQL Server 2016 Database Reporting
4.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
55 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server 2016 Database Reporting to your Wishlist.

Add to Wishlist

SQL Server 2016 Database Reporting

Create impressive reports from your SQL Server data
4.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
55 students enrolled
Created by Packt Publishing
Last updated 4/2017
Current price: $12 Original price: $125 Discount: 90% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
  • 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.

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.

About The Author

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.

Who is the target audience?
  • This course is for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016.
Compare to Other Database Management Courses
Curriculum For This Course
56 Lectures
Installation and setup
7 Lectures 29:46

This video gives an overview of the entire course.

Preview 03:19

In order to follow along with the on-screen examples, the viewers should install and configure SQL Server 2016 developer edition.

Installing and Configuring SQL Server 2016 Developer Edition

In previous versions of SQL Server, Management Studio was installed with the database instance. With SQL Server 2016, Management Studio is a separate installation. Let us learn how to install it.

Installing SQL Server Management Studio

Visual Studio is the integrated development environment for developing, testing and managing the objects that make up SQL Server Reporting Services Reports. Let's go through the steps of installing Visual Studio.

Installing Visual Studio

Some editions do not come with the reporting services development kit, as the tools needed to develop reports are in the SQL Server Data tools. Let's go through the steps of installing SQL Server 2016 Data Tools.

Installing SQL Server 2016 Data Tools

Go through the steps for installing SQL Server sample databases.

Installing SQL Server Sample Databases

To use reporting services Manager effectively, you need to know the features available in SQL Server 2016 Reporting Services Configuration Manager.

SQL Server 2016 Reporting Services Configuration Manager
Wizarding Your First Report
5 Lectures 20:43

Populating the Select the Data Source Screen in the Report Wizard.

Preview 04:40

The user is given a choice of pressing the "Query Builder…" button or entering their query in the "Query string:" textbox.

Report Queries

The report type we choose is heavily dependent upon the query and the type of information we are trying to convey in the report.

Tabular Report Types and Their Configuration

The Report Wizard's Design the Table screen will save much time and effort when creating new tabular and matrix reports.       

Matrix Report Types and Their configuration

The Choose the Deployment Location screen of the Report Wizard only appears the first time a report is created in a new SSRS project. The deployment settings can be changed by selecting the Project properties in Visual Studio.

Deployment Location and Completing the Wizard
Formatting a Tabular Report
7 Lectures 27:13

I need to add a column to an existing report, but I don't want to recreate it through the wizard. 

Preview 04:45

The Report Wizard will not automatically format the column width to fit the header or the data. 

Formatting Column Headers

SSRS provides a mechanism to change the data from the sort order provided by the report query.

Interactive Sorting

Within the report, fields can be calculated using the data returned from the query, using SSRS built-in fields, using Expressions or a combination of all three. Expressions will allow for greater flexibility in the display of data and formatting. 

Adding Calculated Fields and Using Expressions

The formatting of cells in SSRS is similar to formatting cells in Excel. Most of the terminology is the same. 

Formatting Cells

Your organization's report server should be controlled by your database administrator and quite possibly by your network administrator.

Viewing the Report on the Report Server

Just because the report displays nicely on the screen does not mean the report is formatted properly on paper.

Formatting the Report for Printing
Adding Headers and Footers
5 Lectures 14:46

The Report Wizard does not automatically add a header and footer to the report. We will add them manually.

Preview 02:46

There are numerous built-in fields that come with SSRS which we can add to the header or footer which can help the viewer to navigate the report.

Using Built-in Fields

Adding query-defined fields to a report can be tricky, especially if more than one row is returned.

Adding Query-Defined Fields

An organization's logo in the header of the report makes a report look official.

Adding Images to the header

Printed reports still remain a security issue when confidential information is contained within these reports. For printed reports, metadata can be used to identify who accessed the data, when the data on the report was last updated, and when they accessed the data.

The Importance of Displaying Report Metadata on the Report
Creating a Drill-Down Report
5 Lectures 17:27

It is important to write queries that take advantage of the database server's processing power, especially for drill-down reports. 

Preview 02:45

With a well-written query, the Report Wizard can efficiently create a drill-down report that will minimize the development effort. 

Creating the Drill- Down Report

The symbols on the left side of the tablix relates to the row groups below the report in Design mode.

Grouping in SSRS

By default, groups are collapsed.       

Toggling the Display

Grand total rows and columns can be added to drill-down reports.

Adding Summary Rows
Using Parameters in a Report
4 Lectures 15:48

The different parameter types affect the behavior of the report and the way in which the user interacts with the report.

Preview 04:11

Setting available parameter values and default values reduces the likelihood of a user creating a report with unintended data. As report developers, building this robustness into the report is beneficial to the user and us.

Available and Default Values

Parameters can allow the user to change the data displayed in the report without changing the report query. Defining a parameter alone will not impact what data is displayed on the report. Filters can be created that utilize the defined parameters. 

Filtering by the Parameter Value

If we export the report to a PDF or print the report, the parameter value is not displayed. We need to display the parameter value so that the user will know what parameter value was used to generate the report. 

Displaying Parameter Values Within the Report
Creating a Drill-Through Report
4 Lectures 15:03

Drill-through reporting requires a parent report and a child report. The child report contains additional details about an item found in the parent report. 

Preview 03:50

The child report needs to display only the data associated with the item in the parent report. Report parameters can be used in the report query's WHERE clause. In SQL Server Reporting Services, a report parameter is a separate entity from a query parameter. 

Adding a Parameter to a Query

The text box of the item of interest in the parent report must be enabled to allow drill-through actions to occur. The child report for drill-through purposes must already exist. 

Configuring the Drill-Through Reporting Action

Both the parent and the child reports in drill-through reporting must be deployed together for the proper operation of the reports.

Deploying the Drill-Through Reports to the Report Server
Baking Pie and Bar Charts
5 Lectures 19:25

Pie chart queries need to return labels, counts, and percentages. The percentages in the pie chart queries need to add up to 100 percent. Bar chart queries need to return a label and a numeric value. 

Preview 05:57

Pie charts are an excellent way to demonstrate how data is distributed by percentage across different categories. 

Creating the Pie Chart Report

A bar chart is an excellent way to show two dimensional data when you have a few data points. The SSRS Bar Chart shares many properties and attributes with the Column Chart.

Creating the Bar Chart Report

There are a myriad of ways to configure report legends, titles, labels, and other properties for chart objects.

Formatting the Legends and Labels

SSRS report definitions are reusable objects which may be embedded into other reports as subreports.

Placing Two Subreports Onto One Report
Gauges, Sparklines, and Indicators
5 Lectures 21:25

Gauges, sparklines, and indicators are report objects in SSRS which provide an impressive way to display summarized information for presentations, documents, and web pages. Each object requires specific data elements for proper operation and to give the user the scope of the data.

Preview 02:31

Gauges are an excellent way to show progress towards a numeric goal.       

Creating a Report Containing a Gauge

Sparklines can help add a historical perspective to numbers displayed in a table.

Creating a Report Containing a Sparkline

SSRS indicators are an excellent way to show progress towards a categorical goal or the current status of a process.       

Creating a Report Containing an Indicator

Dashboards allow for online reporting of high-level information to allow management to quickly find where the business is performing well and where attention needs to be placed. 

Creating a Dashboard
Analytical Maps
5 Lectures 24:00

Point, line, bubble, and polygon maps are report objects in SSRS, which provide an impressive way to display information about a particular geographic area. Each object requires specific data elements for proper operation and to give the user the scope of the data.

Preview 02:58

Points are an excellent way to show the location of objects on a map.

Creating a Point Map

Analytical line maps allow for the visualization of data that relates to two points on a map.       

Creating an Analytical Line Map

Bubble maps allow us to compare the sizes of data values that exists among various points on a map. process.

Creating a Bubble Map

Polygon maps can be created from a variety of ESRI shape files.

Creating a Polygon Map
1 More Section
About the Instructor
Packt Publishing
3.9 Average rating
8,274 Reviews
59,287 Students
689 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.