COURSE FINDER

Booking Enquiry

Visual Data with MS SQL Server SSRS

£390 per delegate

Duration: 1 day

Trainer: WC315P

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

Duration:

2 day

Your Enquiry

Please select expected number of delegates

VCode

I am interested in...

In-Company/Own Venue Open Course All Course Types

Enquiry

Please enter your enquiry details below and leave the rest to us. Need different dates or venue? No problem! Please remember to include:
- Preferred dates
- Preferred location(s)

Your Details

Name

Company Name

Telephone

Mobile

Postcode

Address

City

County

Country

What happens next?
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

Email Enquiries

enquiries@bookmycourse.co.uk

GET A QUOTE