Visual Data with MS SQL Server Reporting Services (SSRS)

Click to Enquire

Categories: MySQL Training Courses

£760 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 2 days

Trainer: WC315P

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Course Overview
Course Dates

Duration: 2 days

Course Times: 11:00-18:00

Max Class Size: 4 delegates

Course Aims:

This course focus on producing reports using MS SQL Server Reporting Services: how to use the product features and tools related to data retrieval, visualizations and deployment.

The Target Audience:

Data analysts who will produce reports for their department or group without in-depth SQL knowledge. MS SQL Server Reporting Services gives you a user-friendly visual interface to create report.

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 ReportItems 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