25,000+ Courses Nationwide
0345 4506120

Visual Data with Microsoft SQL Reporting Services SSRS

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.

Select specific date to see price, venue and full details.

Course Content

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

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best