Microsoft SQL Server SSRS Course, 2-Day, Webinar Virtual Classroom

About this event

Visual data with Microsoft SQL Server SSRS Course

This SQL SSRS 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.

Virtual Classroom: Attend online, Instructor-led, Interactive, Practical, Online.

Duration: 2 consecutive days, the first of which is displayed in the booking options.

SQL SSRS 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

SQL SSRS 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

SQL SSRS 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

SQL SSRS Report parts

• Publishing report parts
• The report part gallery
• Updating report parts

 

FEE : £580 – £800

Register :  microsoft-sql-server-ssrs-course-2-day-webinar-virtual-classroom