
SQL Server Reporting Services for Report Writers
Course Length: 4 days
Delivery Methods:
Multiple delivery options
Course Overview
This Introduction to SQL Server 2016/2019 Reporting Services (SSRS) training class teaches students how to create, format, and manage SQL Server 2016/2019 Reporting Services reports. This course focuses primarily on the Report Designer tool in the SSDT-BI for Visual Studio. Attendees will also work in and become familiar with Report Builder and Report Manager.
Course Benefits
- Use Report Designer and Report Manager.
- Work with solutions and projects.
- Create basic reports.
- Enhance reports with formatting, images, and charts.
- Effectively group and summarize data.
- Work with parameterized reports.
- Build dynamic reports with expressions and parameters.
- Incorporate charts and custom maps.
- Work with drillthrough reports.
- Manage reports.
- Utilize Report Builder.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Private classes are delivered for groups at your offices or a location of your choice.
Course Outline
- SSRS Overview and Tools
- Reporting Services Features
- Tools Available with SQL Server
- Working with Solutions and Projects
- Working with SQL Server Data Tools
- Understanding Solutions and Projects
- Working with the Visual Studio Interface
- Working with Solutions and Projects Lab (Optional)
- Answers to Exercises
- Creating Basic Reports
- What is a Data Source?
- What is a Dataset?
- Using the Report Wizard
- What is Tablix?
- Creating a Tabular Report
- Creating a List Report
- What is a Matrix?
- Understanding Drill-down
- Creating Basic Reports Lab
- Answers to Exercises
- Formatting Reports
- Working with Text Boxes
- Rich Text Formatting
- Managing Text Boxes
- Drawing Lines and Boxes
- Images
- Page Headers and Footers
- Formatting Reports Lab
- Answers to Exercises
- Summarizing and Sorting
- Creating Groups
- Parent/Child vs. Adjacent Groupings
- Adding Totals and Aggregations
- Summarizing and Sorting Lab
- Answers to Exercises
- Introduction to Expressions
- Understanding Expressions
- Defining Expressions
- Working with Report Variables
- Introduction to Expressions Lab
- Answers to Exercises
- Add Flexibility with Parameters
- Adding Parameters to a Report
- Report Parameters vs. Query Parameters
- Manage Report Parameter Properties
- Use Parameters with SQL Queries and Stored Procedures
- Work with Cascading Parameters
- Sort Based on a Parameter Setting
- Filtered Reports
- Add Flexibility with Parameters Lab
- Answers to the Exercise
- Enhanced Report Items
- Charts
- Gauges
- Add a Map to a Report
- Data Bar, Indicator, and Sparkline Report Items
- Nesting Data Regions
- Subreports and Drillthrough Reports
- Working with Drillthrough Reports
- Enhanced Report Items Lab
- Answers to Exercises
- Rendering, Deploying, and the Web Portal
- Deploying Reports
- The Web Portal
- Working with Shared Data Sources
- Viewing Reports
- Rendering Reports
- Rendering, Deploying, and the Web Portal Lab
- Answers to Exercises
- KPIs and Mobile Reports
- Working with KPIs 1
- Working with Mobile Reports 1
- The SQL Server Mobile Report Publisher 1
- Exploring the Mobile Report Publisher 1
- KPIs and Mobile Reports Lab
- Answers to the Exercise
- Beyond Basic Reporting
- Utilizing Report Template 1
- Creating Document Maps and Bookmarks 1
- Recursive Parents
- Understanding Lookup, LookupSet, and Multilookup Functions
- Report Rendering
- Using the ReportItems Collection
- Initial Toggle States
- Interactive Sorting
- Expression Samples
- Creating Aggregates of Aggregates
- Using Report Builder (If Time Permits)
- Desktop App
- Using the Report Builder Tool
- Creating Datasets
- Creating Reports
- Creating Reports Using Wizards
- Creating Reports Without a Wizard
- Opening Existing Reports
- Working with Report Parts
- Using Report Builder Lab
- Answers to Exercises
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this Microsoft SQL Server class:
- Working knowledge of Microsoft SQL Server or Microsoft Office applications is encouraged.
Experience in the following would be useful for this Microsoft SQL Server class:
- General familiarity with databases
Register for a Live Class
$1,900.00
Request a Private Class
- Private Class for your Team
- Online or On-location
- Customizable
- Expert Instructors