Book now

Visual data with Microsoft SQL Server SSRS Reports

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

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Buy a voucher
Starting How long Where Price

Mon 25th Sep
11:00am - 6:00pm

2 Days
Full time
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 25th Sep
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 25th Sep
11:00am - 6:00pm

2 Days
Full time
Southend-On-Sea,
SS1 1NE
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 26th Sep
11:00am - 6:00pm

2 Days
Full time
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 26th Sep
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 26th Sep
11:00am - 6:00pm

2 Days
Full time
Southend-On-Sea,
SS1 1NE
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 30th Oct
11:00am - 6:00pm

2 Days
Full time
London,
WC2N 5BY
Map

£750.00 17% off
£622.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 30th Oct
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750.00 17% off
£622.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 30th Oct
11:00am - 6:00pm

2 Days
Full time
Southend-On-Sea,
SS1 1NE
Map

£750.00 17% off
£622.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 01st Nov
11:00am - 6:00pm

2 Days
Full time
London,
WC2N 5BY
Map

£750.00 17% off
£622.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher