29. August 2019 - 11:00 till 18:00
Share it on:

Data Analysis using Microsoft SQL Report Builder 2-Day Course, London | PCWorkshops at Regus, near Trafalgar Square | Thursday, 29. August 2019

Data Analysis using Microsoft SQL Report Builder
Course summary

This course focus on producing reports using MS SQL Server Report Builder 3.0 : 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.
MS SQL Server Report Builder 3.0 gives you a user-friendly visual interface to create report.
Course Outline
Report Models

Data source views
Creating a model
Entities, attributes and roles


Creating tables
Interactive sorting
Floating headers


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


The expression builder
The ReportItems 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


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


Row and column groups
Sorting and filtering matrices
Creating subtotals


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


Page-per-record lists
Dashboard lists
Other list ideas


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

Report parts

Publishing report parts
The report part gallery
Updating report parts