Creating Reports with SQL Server 2012 Reporting Services [Video]

Dr. Dallas Snider

Creating Reports with SQL Server 2012 Reporting Services [Video]
Downloadable video: $39.99
save 15%!

Packt Video. Stream online or download for unrestricted offline use. Learn more

Course Contents
The Author
Sample Clip
  • New! Packt Video courses: practical screencast-based tutorials that show you how to get the job done. Bite sized chunks, hands on instructions, and powerful results.
  • Create reports with tables, matrices, pie charts, gauges, and other attention-grabbing visualizations
  • Add flexibility to your reports by implementing various parameters
  • Step-by-step instructions and practical examples for shorter report development times and to help you format reports to createa professional appearance

Video Details

Language : English
Release Date : Tuesday, November 26, 2013
Course Length : 1 hour and 41 minutes
ISBN : 1782177183
ISBN 13 : 9781782177180
Author(s) : Dr. Dallas Snider
Topics and Technologies : Video, e-Learning, Enterprise

Table of Contents

  1. The Report Wizard [16:12 minutes]
    • Data Sources
    • Report Queries
    • Tabular Report Types and Their Configuration
    • Matrix Report Types and Their Configuration
    • Deployment Location and Completing the Wizard

  2. Creating a Tabular Report [16:51 minutes]
    • 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

  3. Formatting of Report Headers and Footers [10:18 minutes]
    • Adding the Header and Footer
    • Using the Built-in Fields
    • Adding Query-Defined Fields
    • Adding Images to the Header
    • The Importance of Displaying Report Metadata on the Report

  4. Creating a Drilldown Report [9:56 minutes]
    • Queries Specialized for Drilldown Reports
    • Creating the Drilldown Report
    • Grouping in SSRS
    • Toggling the Display
    • Adding Summary Rows

  5. Using Parameters in a Report [11:39 minutes]
    • Parameter Types
    • Available and Default Values
    • Filtering by the Parameter Value
    • Displaying Parameter Values within the Report

  6. Creating a Drillthrough Report [11:34 minutes]
    • Creating a Child Report
    • Adding a Parameter to a Query
    • Configuring the Drillthrough Reporting Action
    • Deploying the Drillthrough Reports to the Report Server

  7. Creating Pie and Bar Charts [13:17 minutes]
    • 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

  8. Utilizing Gauges, Sparklines, and Indicators [11:51 minutes]
    • 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

Dr. Dallas Snider

Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida (UWF). He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received his B.A. in Physics from Hendrix College in Conway, Arkansas. 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 and Euronet. Dr. Snider's research and teaching interests include data mining, data warehousing, software development, and security.

Sorry, there are currently no downloads available for this video.

Code Downloads

Download the code and support files for this video.

Support, complaints and feedback.

Packt is committed to making Packt Video courses a valuable, useful way for IT professionals to learn new skills. We have made every effort to ensure that this course reaches the required standard and will work on our customer's devices. Please go to our support page.

What you will learn from this video course

  • Utilize the Report Wizard to quickly get a report started
  • Format data in tables and matrices
  • Add interactive sorting and high-impact visualizations such as pie charts, gauges, and bar graphs
  • Build expressions and implement built-in variables
  • Create drill-down and drill-through reports
  • Maximize report flexibility through the use of parameters
  • Combine report objects to create a dashboard

Who this video course is for

Creating Reports with SQL Server 2012 Reporting Services is designed for those who have a working knowledge of SQL and who need to deliver business intelligence via impressive, interactive reports. You will need a version of SQL Server 2012 that includes the SQL Server Data Tools. This thorough course requires basic experience with SQL Server and reporting.

In Detail

A key component of delivering business intelligence, SQL Server 2012 Reporting Services allows for the effective communication of critical information. SSRS enables users to quickly and easily generate reports from Microsoft SQL Server databases. This provides you with an extensive range of tools to create, manage, and customize reports for your organization.

Creating Reports with SQL Server 2012 Reporting Services will show you how to develop practical reports that utilize tables and matrices, along with bold objects such as pie charts and gauges that quickly gain the attention of the viewer and deliver your message. With this course, you can acquire the essential skills you need to make an impression on your customers, your audience, or your boss.

Starting with the queries needed to populate areport, you will learn how to build, layout, and format informative multifunctional reports.You will be able to deliver your organization’s message clearly through high-impact visual objects. The viewers of your reports will be able to interact with the information by filtering, sorting, drilling down, or drilling through to find what is important to them.

Creating Reports with SQL Server 2012 Reporting Services will give you all the knowledge you need to create reports that will impress your stakeholders.


Packt video courses are designed to cover the breadth of the topic in short, hands-on, task-based videos. Each course is divided into short manageable sections, so you can watch the whole thing or jump to the bit you need. The focus is on practical instructions and screencasts showing you how to get the job done.

The content is delivered in a concise, conversational style that emphasizes efficiency in development while empowering you to maximize the functionality and impact of your reports created with SQL Server Reporting Services.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software