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

Tables

Creating tables
Interactive sorting
Floating headers

Grouping

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

Expressions

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

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