Booking Enquiry

Visual Data with MS SQL Server SSRS - Online Classroom

Course summary:

This course focus on producing reports using MS SQL SSRS: how to use the product features and tools related to data retrieval, visualisations and deployment.
The Target Audience: end-users who will produce reports for their department or group without in-depth SQL knowledge.

Course Outline:

Report Models:

Data source views
Creating a model
Entities, attributes and roles
Tables

Creating tables
Interactive sorting
Floating headers
Grouping

Inserting groups
Group headers/footers
Displaying group totals
Expanding and collapsing
Expressions

The expression builder
The Report Items collection
Built-in fields
Conditional formatting expressions
Page set-up

Page headers and footers
Page names and numbers
Exporting reports

The various report formats
Using RenderFormat.Name
Parameters

Creating parameters
Filtering using parameters
Drop list parameters
Coping with empty tables
Matrices

Row and column groups
Sorting and filtering matrices
Creating subtotals
Charts

Creating charts
The parts of a chart
Formatting charts
Basic reports

Text boxes and images
Selecting report items
Formatting parts of a report
Miniature charts

Creating sparklines
Creating data bars
Graphical indicators

Creating and customising indicators
Linear and radial gauges
Lists

Page-per-record lists
Dashboard lists
Other list ideas
Subreports

Creating a child report
Creating the main report
Linking the two reports
Report parts

Publishing report parts
The report part gallery
Updating report parts