Book Image

SQL Server 2016 Database Reporting [Video]

By : Dallas Harold Snider
Book Image

SQL Server 2016 Database Reporting [Video]

By: Dallas Harold Snider

Overview of this book

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.
Table of Contents (11 chapters)
Chapter 9
Gauges, Sparklines, and Indicators
Content Locked
Section 1
Queries Optimized for Gauges, Sparklines, and Indicators
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. - For gauges, it is best that the query returns an amount, a target value, and a percentage for a specific item - For sparklines, the query needs to return a series of numbers, preferably showing how a value changes over time - For indicators, the query can return an amount, a target value and a percentage for multiple items