SQL Server Reporting Services (SSRS)

Join our instructor-led classroom-based training course on SQL Server Reporting Services (SSRS), where attendees will gain comprehensive knowledge on designing and creating various report elements including indicators, charts, data bars, lists, and map layers, all managed seamlessly through SSRS. Through interactive sessions and hands-on exercises, participants will learn valuable skills and techniques to effectively utilize SSRS for impactful reporting solutions.

This course is tailored for individuals with a foundational understanding of SQL, making it ideal for those who already possess basic knowledge in the subject.

1: Getting Started with SSRS

• What is SSRS?
• Installing SQL Server with Reporting Services
• Report Design Environments
• Introduction to Visual Studio

2: Retrieving Data for Reports

• Solutions and Projects
• Create a New Project
• The Elements of a Report
• Data Sources and Datasets
• Creating a Report

3: Designing Report Layout

• Report Design Elements
• Adding a Table to display data
• Adding Page Header and Footer
• Formatting the Table

4: Expressions and Functions

• Introduction of Expressions
• Develop Expressions with a Built-in Field
• Using Function in an Expression
• Using IIF function
• Using SWITCH function

5: Making Reports Dynamic with Parameters

• Using Report Parameters
• Parameter Lists
• Create a Dynamic Parameter List
• Default Parameters

6: Creating Drill-down Reports

• Introduction to Drill-down Reports
• Create a Drill-down Report

7: Creating Multi-level Reports

• Introduction to Multi-level Reports
• Create a Multi-level Report
• Adding Subtotals and Totals
• Making Expandable/Collapsible Groups

8: Creating Matrix Reports

• Introduction of Matrix Reports
• Aggregate Data
• Creating a Matrix Report
• Grouping in a Matrix Report

9: Creating Charts

• Adding a Bar Chart
• Creating a Pie Chart

10: Using Indicators

• Introduction to Indicators
• Adding an Indicator Column

Our aim is not just to get you the qualification but also guide you through all processes while you are applying for your SIA Licence. Following are some of the reasons why you should choose us as your training provider:

• Excellent Success Rate!
• Fully accredited and authorized training center in London!
• Most competitive prices with NO HIDDEN COSTS!
• Prices are all inclusive of tuition, handbook, notebook, exams and certificate costs!
• Nationally recognized and Ofqual accredited training course!
• Highly skilled and qualified trainers with a great wealth of practical knowledge & experience!
• Post-qualification email support while you are preparing to book your licence application!
• Free guidance session on how to apply and obtain a SIA Licence!