Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag United Kingdom
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Argentina
Country selected
country flag Austria
Country selected
country flag Belgium
Country selected
country flag Bulgaria
Country selected
country flag Chile
Country selected
country flag Colombia
Country selected
country flag Cyprus
Country selected
country flag Czechia
Country selected
country flag Denmark
Country selected
country flag Ecuador
Country selected
country flag Egypt
Country selected
country flag Estonia
Country selected
country flag Finland
Country selected
country flag Greece
Country selected
country flag Hungary
Country selected
country flag Indonesia
Country selected
country flag Ireland
Country selected
country flag Italy
Country selected
country flag Japan
Country selected
country flag Latvia
Country selected
country flag Lithuania
Country selected
country flag Luxembourg
Country selected
country flag Malaysia
Country selected
country flag Malta
Country selected
country flag Mexico
Country selected
country flag Netherlands
Country selected
country flag New Zealand
Country selected
country flag Norway
Country selected
country flag Philippines
Country selected
country flag Poland
Country selected
country flag Portugal
Country selected
country flag Romania
Country selected
country flag Singapore
Country selected
country flag Slovakia
Country selected
country flag Slovenia
Country selected
country flag South Africa
Country selected
country flag South Korea
Country selected
country flag Sweden
Country selected
country flag Switzerland
Country selected
country flag Taiwan
Country selected
country flag Thailand
Country selected
country flag Turkey
Country selected
country flag Ukraine
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Home > Data > Databases > SQL Server 2016 Database Reporting
SQL Server 2016 Database Reporting
SQL Server 2016 Database Reporting

SQL Server 2016 Database Reporting: Operational reporting and mobile dashboards with SSRS 2016

Arrow left icon
Profile Icon Dallas Harold Snider
Arrow right icon
$137.99
Video Feb 2017 3hrs 45mins 1st Edition
Video
$137.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon Dallas Harold Snider
Arrow right icon
$137.99
Video Feb 2017 3hrs 45mins 1st Edition
Video
$137.99
Subscription
Free Trial
Renews at $19.99p/m
Video
$137.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents

Key benefits

  • 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

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.

Who is this book for?

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.

What you will learn

  • Define data source and create drill-down reports in SQL Server Reporting Services.
  • Modify column headers, add new columns, and fields without altering queries.
  • Explore parameter types and configure drill-through actions.
  • Optimize queries for maps, gauges, spark lines, and indicators in reports.
  • Deploy and secure reports on the web portal.

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Feb 15, 2017
Length: 3hrs 45mins
Edition : 1st
Language : English
ISBN-13 : 9781787121249
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Databases
Tools :
SQL Server

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Feb 15, 2017
Length: 3hrs 45mins
Edition : 1st
Language : English
ISBN-13 : 9781787121249
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Databases
Tools :
SQL Server

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

SQL Server 2016 Database Reporting
SQL Server 2016 Database Reporting
Read more
Feb 2017 3hrs 45mins
Video
Video
  • Video Video $137.99
$137.99
SQL Server 2016 Reporting Services Cookbook
SQL Server 2016 Reporting Services Cookbook
Read more
Nov 2016 596 pages
Full star icon 4 (1)
eBook
eBook
  • eBook eBook $32.99
  • Paperback Paperback $60.99
$32.99 $47.99
$60.99
SQL Server 2017 Integration Services Cookbook
SQL Server 2017 Integration Services Cookbook
Read more
Jun 2017 558 pages
Full star icon 2.6 (12)
eBook
eBook
  • eBook eBook $35.99
  • Paperback Paperback $65.99
$35.99 $51.99
$65.99
Stars icon
Total $ 264.97
SQL Server 2016 Database Reporting
$137.99
SQL Server 2016 Reporting Services Cookbook
$60.99
SQL Server 2017 Integration Services Cookbook
$65.99
Total $ 264.97 Stars icon

Table of Contents

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

Recommendations for you

Left arrow icon
Python Machine Learning By Example
Python Machine Learning By Example
Read more
Jul 2024 518 pages
Full star icon 4.9 (8)
eBook
eBook
  • eBook eBook $24.99
  • Paperback Paperback $31.99
$24.99 $36.99
$31.99 $45.99
Building AI Applications with OpenAI APIs
Building AI Applications with OpenAI APIs
Read more
Oct 2024 252 pages
eBook
eBook
  • eBook eBook $21.99
  • Paperback Paperback $39.99
$21.99 $31.99
$39.99
Unlocking Data with Generative AI and RAG
Unlocking Data with Generative AI and RAG
Read more
Sep 2024 346 pages
eBook
eBook
  • eBook eBook $21.99
  • Paperback Paperback $27.98
$21.99 $31.99
$27.98 $39.99
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
Full star icon 4.2 (22)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $34.98
$27.98 $39.99
$34.98 $49.99
RAG-Driven Generative AI
RAG-Driven Generative AI
Read more
Sep 2024 334 pages
Full star icon 4.5 (13)
eBook
eBook
  • eBook eBook $24.99
  • Paperback Paperback $43.99
$24.99 $35.99
$43.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 4.4 (95)
eBook
eBook
  • eBook eBook $29.99
  • Paperback Paperback $54.99
$29.99 $43.99
$54.99
Python for Algorithmic Trading Cookbook
Python for Algorithmic Trading Cookbook
Read more
Aug 2024 404 pages
Full star icon 4.6 (15)
eBook
eBook
  • eBook eBook $32.99
  • Paperback Paperback $41.98
$32.99 $47.99
$41.98 $59.99
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Read more
Jan 2023 14hrs 31mins
Video
Video
  • Video Video $109.99
$109.99
Principles of Data Science
Principles of Data Science
Read more
Jan 2024 326 pages
Full star icon 4.8 (4)
eBook
eBook
  • eBook eBook $21.99
  • Paperback Paperback $27.98
$21.99 $31.99
$27.98 $39.99
Mastering NLP from Foundations to LLMs
Mastering NLP from Foundations to LLMs
Read more
Apr 2024 340 pages
Full star icon 4.9 (24)
eBook
eBook
  • eBook eBook $29.99
  • Paperback Paperback $36.99
$29.99 $42.99
$36.99 $52.99
Right arrow icon

People who bought this also bought

Left arrow icon
Machine Learning Engineering with Python
Machine Learning Engineering with Python
Read more
Aug 2023 462 pages
Full star icon 4.6 (36)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 4.6 (45)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Modern Generative AI with ChatGPT and OpenAI Models
Modern Generative AI with ChatGPT and OpenAI Models
Read more
May 2023 286 pages
Full star icon 4.2 (34)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 368 pages
Full star icon 4 (34)
eBook
eBook
  • eBook eBook $27.98
  • Paperback Paperback $49.99
$27.98 $39.99
$49.99
Causal Inference and Discovery in Python
Causal Inference and Discovery in Python
Read more
May 2023 456 pages
Full star icon 4.5 (49)
eBook
eBook
  • eBook eBook $21.99
  • Paperback Paperback $27.98
$21.99 $31.99
$27.98 $39.99
Right arrow icon

About the author

Profile icon Dallas Harold Snider
Dallas Harold 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.
Read more
See other products by Dallas Harold Snider
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.