SQL Server Reporting Services (SSRS)

Beginner
Online Classes
Total 8 hours in class

Multi-Day Course
2-8 learners per class

Requirements

This course suits those with basic knowledge of Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our SQL for Beginners covers all of the prerequisites.

Class Details

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

Tutors

Younus Kazi

A professional Online and Classroom Teacher

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, deve...
View More...