Live Virtual Classroom
<

MS SQL Report Builder Course

MS SQL Report Builder Course summary

This course focus on producing reports using MS SQL Report Builder:
how to use the MS SQL Report Builder product features and tools related to data retrieval, visualisations and deployment.
MS SQL Report Builder provides execllenet data vsializations, reports and dashboard.
The Target Audience: end-users who will produce reports for their department or group without in-depth SQL knowledge, but still getting the benefit of power SQL Queries, to extract underlying data for the reports.

MS SQL Report Builder Course Description

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 headers and footers
Page names and numbers

Exporting reports:

The various report formats
Using RenderFormat.

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

What is included in the SQL Report Builder Courses:
  • SQL Report Builder Course Certificate on completion
  • SQL Report Builder Course notes
  • Practical SQL Report Builder Course exercises, Code Examples
  • After the course, 1 free session for questions online via Gotomeeting.com.
  • Max group size on this SQL Report Builder Course is 4.
Special Offers
PCWorkshops London
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
PCWorkshops Manchester
Special Offer: Python 3-weeks online Boot Camp
Read More
PCWorkshops Birmingham
Special Offer on the 'SQL Queries in 1-Day' webinar
Read More
PCWorkshops Southend-on-Sea
Special Offer on the 'Java Cross-Over for Coders' Webinar
Read More

Request a Free Webinar Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.