SQL Server Reporting Services (SSRS)

Our SQL Server Reporting Services (SSRS) is an instructor-led virtual classroom-based training course that teaches attendees how to design and create reports, indicators, charts, data bars, lists, map layers and manage these by using SSRS.
 

Course Outline
Introduction to SSRS

• BIDS and Report Manager
• Solutions and projects
• The 4 main Visual Studio windows

Designing a Simple Report

• Authoring a report
• Using report items
• Selecting and formatting report items
• Number formats

Data sources and datasets

• Shared data sources
• Shared versus embedded datasets
• Using Query Designer

Tables

• Structure of a table
• Formatting tables
• Inserting rows
• Interactive sorting
• Repeating page headers

Grouping tables

• Using the grouping panes
• Row and column groups
• Displaying subtotals
• Outlining

Expressions

• Calculated fields
• The ReportItems collection
• Using built-in fields
• Conditional formatting using
• expressions

Parameters

• Using query parameters
• Creating drop lists
• Multi-value drop lists
• Formatting using parameters

Indicators

• Creating indicators
• Changing the symbols displayed
• Stopping indicators stretching

Charts

• The areas of a chart
• Creating charts
• Formatting charts

Data bars and sparklines

• Need for a grouped row
• Creating data bars
• Creating sparklines

Gauges

Lists

Subreports

Map Report

Deploying Reports