Enable Technology

SQL Server Reporting Services 

Microsoft SQL Server Report Builder SSRS

Course Overview

Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.

Duration: 2 day course

Course Content

Introduction to SQL Server Report Builder
Planning Your Reports
Understanding Variances Between SQL Versions
Exploring the Report Builder Interface
Examining Management
Utilizing Data Sources
Working with Datasets

SQL Server Report Builder Wizards
Exploring Table or Matrix Wizard
Utilizing Chart Wizard
Working with Map Wizard

SQL Server Report Builder Basic Reports
Utilizing Lists
Using Tables
Exploring Matrix
Mastering Data Region(s)
Examining Parameters
Working with Expressions
Understanding Report Parts
Formatting Reports

SQL Server Report Builder Graphics
Understanding Visualizations
Utilizing Charts
Exploring Gauges
Examining Maps

SQL Server Report Builder Advanced Reporting
Filtering, Grouping, and Sorting
Utilizing Dynamic Headers and Footers
Visualizing Your Company Report Templates
Understanding HTML5 and Textboxes
Using the List Object to Combine Other Items
Creating Subreports and Drillthrough Reports
Exploring Subscriptions
Examining Security

Email us about this courses

Telephone on 01952 938014