Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Creating Reports with SQL Server 2012 Reporting Services
The Report Wizard
Data Sources (3:23)
Report Queries (2:19)
Tabular Report Types and Their Configuration (3:47)
Matrix Report Types and Their Configuration (3:28)
Deployment Location and Completing the Wizard (3:15)
Creating a Tabular Report
Formatting Column Headers (3:17)
Interactive Sorting (2:35)
Adding Calculated Fields and Using Expressions (2:49)
Formatting Cells (3:18)
Viewing the Report on the Report Server (3:26)
Formatting the Report for Printing (1:26)
Formatting of Report Headers and Footers
Adding the Header and Footer (2:04)
Using the Built-in Fields (2:35)
Adding Query-Defined Fields (2:15)
Adding Images to the Header (1:45)
The Importance of Displaying Report Metadata on the Report (1:39)
Creating a Drilldown Report
Queries Specialized for Drilldown Report (2:19)
Creating the Drilldown Report (2:15)
Grouping in SSRS (2:03)
Toggling the Display (1:31)
Adding Summary Rows (1:49)
Using Parameters in a Report
Parameter Types (3:59)
Available and Default Values (3:18)
Filtering by the Parameter Value (1:52)
Displaying Parameter Values within the Report (2:30)
Creating a Drillthrough Report
Creating a Child Report (3:17)
Adding a Parameter to a Query (2:56)
Configuring the Drillthrough Reporting Action (3:00)
Deploying the Drillthrough Reports to the Report Server (2:21)
Creating Pie and Bar Charts
Queries Optimized for Pie Charts and Bar Charts (2:56)
Creating the Pie Chart Report (1:50)
Creating the Bar Chart Report (1:40)
Formatting the Legends and Labels (3:57)
Placing two Subreports onto One Report (2:54)
Utilizing Gauges, Sparklines, and Indicators
Queries Optimized for Gauges, Sparklines, and Indicators (1:53)
Creating a Report Containing a Gauge (2:20)
Creating a Report Containing a Sparkline (1:58)
Creating a Report Containing an Indicator (3:04)
Creating a Dashboard (2:36)
Tabular Report Types and Their Configuration
Complete and Continue