MS SQL Server Report Builder Course, 2 Days

SQL Course summary

This course focus on producing reports using MS SQL SSRS Report Builder, 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 using datasets.

SQL Course Description

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 Report Items collection
Built-in fields
Conditional formatting expressions
Page headers and footers
Page names and numbers

Exporting reports:

The various report formats
Using RenderFormat.


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

What is included in the SQL Courses:
  • SQL Course Certificate on completion (assessment based)
  • SQL Course notes
  • Practical SQL Course exercises, SQL Course Homework / SQL Course Revision work
  • Tea, coffees, but no lunch
  • To assist after the course, 1 free session for questions online SQL Course via Skype or Teamviewer.
  • Max group size on this SQL Course is 4.
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops Manchester
MANCHESTER: 53 Fountain Street, Manchester, M2 2AN
Read More
PCWorkshops Birmingham
BIRMINGHAM: One Victoria Square, Birmingham, B1 1BD
Read More
PCWorkshops Southend-on-Sea
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS
Read More
PCWorkshops Milton Keynes
MILTON KEYNES: Exchange House, 494 Midsummer Boulevard, Milton Keynes, MK9 2EA
Read More
PORTSMOUTH: Building 1000, Lakeside North Harbour, Western Road, Portsmouth, PO6 3EZ
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More

Subscribe our Newsletter

Sign up to receive lessons, tips, examples, quizzes and other training materials.