SQL Server Reporting Services (SSRS) course

SQL Server Reporting Services (SSRS)

$280.00
8 hours
Beginner
Instructor Led Online Training

Course Overview

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

Skills Required

This course is suitable for those who already have basic knowledge on Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our Database Design with Microsoft SQL Server and Querying Data with SQL and T-SQL training courses cover all of the prerequisites.

Booking Request

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

book a course on different dates
book for a group of delegates
book corporate training
book a customised training
book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

How many hours you want book?

Booking for how many people?

Here is the total cost of booking:

Price per person for this course:

Preferred Dates and Times

Any other information

You must need to Register / Sign In first to submit this booking request form.

Study Path

Delegates might be interested in the following courses too:

Career Path

This is a possible career path after completing this course:

SQL Server Report Designer > Senior SQL Server Report Designer

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

Younus Kazi

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, development, software development and project management. He graduated from London Metropolitan University in Computing and Information Systems. He is also a Microsoft Certified Application Developer (MCAD).

SQL Server Reporting Services (SSRS) Training Course