SSRS Training Overview
Accelebrate's Introduction to SQL Server Reporting Services (SSRS) training teaches attendees how to create both basic and advanced reports from scratch using Report Designer. Participants master populating and formatting their reports, then successfully deploying them for desktop and mobile consumption.
Note: the class can be taught in 2016, 2017, 2019, or later.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, we offer some courses as live, instructor-led online classes for individuals.
Objectives
- Use Report Designer and Mobile Report Publisher
- 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
- Render and deploy reports using the Web Portal
- Work with KPIs and Mobile Reports
- Utilize Web Portal
- Learn helpful tips that go beyond basic reports
Prerequisites
Students should have a general familiarity with database concepts and a working knowledge of Microsoft SQL Server or Microsoft Office applications.
Outline
Expand All | Collapse All
Introduction
SSRS Overview and Tools
- Reporting Services Features
- Tools Available with SQL Server 2016
Working with Solutions and Projects
- Working with SQL Server Data Tools
- Understanding Solutions and Projects
- Working with the Visual Studio Interface
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
Formatting Reports
- Working with Text Boxes
- Rich Text Formatting
- Managing Text Boxes
- Drawing Lines and Boxes
- Images
- Page Headers and Footers
Summarizing and Sorting
- Creating Groups
- Parent/Child vs. Adjacent Groupings
- Adding Totals and Aggregations
Introduction to Expressions
- Understanding Expressions
- Defining Expressions
- Working with Report Variables
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
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
Rendering, Deploying, and the Web Portal
- Deploying Reports
- The Web Portal
- Working with Shared Data Sources
- Viewing Reports
- Rendering Reports
KPIs and Mobile Reports
- Working with KPIs
- Working with Mobile Reports
- The SQL Server Mobile Report Publisher
- Exploring the Mobile Report Publisher
- Publishing Mobile Reports
Beyond Basic Reporting
- Utilizing Report Template
- Creating Document Maps and Bookmarks
- Recursive Parents
- Understanding Lookup, LookupSet, and Multilookup Functions
- Report Rendering
- Interactive Sorting
- Using the ReportItems collection
- 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 Part
Conclusion
Training Materials
All attendees receive comprehensive courseware.
Software Requirements
Attendees will not need to install any software on their computer for this class. The class will be conducted in a remote environment that Accelebrate will provide; students will only need a local computer with a web browser and a stable Internet connection. Any recent version of Microsoft Edge, Mozilla Firefox, or Google Chrome will be fine.
