Short course on Microsoft SQL Server Reporting Services (SSRS) Course level: Intermediate
Total Duration: 10 Hours
Certification: Certificate of Completion will be provided after completing the course

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 Training Courses cover all of the prerequisites.

Course Dates, Prices & Enrolment

DatesPriceEnrol
11 Dec 2016 - 18 Dec 2016
2 Sundays
£220Enrol Now
28 Dec 2016 - 30 Dec 2016
Wednesday & Friday
£180 (normal price £220)Enrol Now
16 Jan 2017 - 18 Jan 2017
Mon, Wed & Fri
£220Enrol Now
12 Feb 2017 - 19 Feb 2017
2 Sundays
£220Enrol Now
  1. Introduction to SSRS
    • BIDS and Report Manager
    • Solutions and projects
    • The 4 main Visual Studio windows
  2. Designing a Simple Report
    • Authoring a report
    • Using report items
    • Selecting and formatting report items
    • Number formats
  3. Data sources and datasets
    • Shared data sources
    • Shared versus embedded datasets
    • Using Query Designer
  4. Tables
    • Structure of a table
    • Formatting tables
    • Inserting rows
    • Interactive sorting
    • Repeating page headers
  5. Grouping tables
    • Using the grouping panes
    • Row and column groups
    • Displaying subtotals
    • Outlining
  6. Expressions
    • Calculated fields
    • The ReportItems collection
    • Using built-in fields
    • Conditional formatting using
    • expressions
  7. Parameters
    • Using query parameters
    • Creating drop lists
    • Multi-value drop lists
    • Formatting using parameters
  8. Indicators
    • Creating indicators
    • Changing the symbols displayed
    • Stopping indicators stretching
  9. Gauges
    • Creating and formatting gauges
    • Gauge panels
    • Pointers, scales and ranges
  10. Charts
    • The areas of a chart
    • Creating charts
    • Formatting charts
  11. Data bars and sparklines
    • Need for a grouped row
    • Creating data bars
    • Creating sparklines
  12. Lists
    • Creating and formatting lists
    • Grouping using lists
    • Using rectangles in list
  13. Subreports
    • Creating a child report
    • Creating the main report
    • Creating and formatting subreports
  14. Maps
    • ESRI shapefiles / SQL spatial data
    • Linking to datasets
    • Map layers
    • Center points and point layers
  15. Deploying Reports

"Great value for money, covers all aspects of SSRS!"

James Lutaya, 28/06/2016

"Good course for learning the most common features of SSRS. Helpful and kind teacher."

Michelangelo Rubino, 18/11/2015

Course Tutor

The course instructor is a .NET developer with 15 years of experience in software and web development. He is a Microsoft Certified Application Developer and skilled on C#, ASP.NET, Microsoft SQL Server, Ajax, HTML, and CSS.

Save Money with Packages

SAVE upto 25% by booking this course with other related courses as shown below:

SQL Server and SSRS

£620 (save £100)

This package combines
Find out more & book now

Microsoft SQL Server Immersive

£765 (save £135)

This package combines
Find out more & book now

Newsletter Sign-up

Have a Question?