The SQL SSRS online training course provides students with the knowledge and skills to create and run SQL reports. The course focuses on teaching individuals how to use the SQL SSRS product features and tools related to created reports, charts, dashboards, and more.
Overview
Skills Learned
After completing this online training course, students will be able to:
Install SSRS
Create new Projects
Set up data sources
Create and customize Reports
Format Reports
Create Charts and Dashboards
Install report builder
This SQL course is suitable for IT professionals who work with all versions of SQL, and who would like to know how to use this system and expand their knowledge.
There are no required pre-requisites for this course, however, we do suggest that students have a prior understanding of SQL.
01. Preparing the Work Environment
- SSRS Installation
- SQL Server Database Engine Required
- Download SSMS
- Download VS Community 2019
- Download SSDT SSRS Extension
- SSRS Configuration
- Report Server Configuration Manager
- SSRS Web Service URL
- Web Service API
02. Web Portal URL
- Exploring SSRS Web Portal URL
- New
- Upload
- Report Manager Upload Text, PDF, and Images
- Manage Folder
- Tiles
- Settings
- Download
- Help
03. Data Sources and Datasets
- Report Data
- Query types
- Text
- Table
- Views
- Stored Procedures
- Reports
- Table
- Matrix
- List
- Report Add-Ins
- Image
- Textbox
- Rectangle
- Line
04. Report Formatting
- Formatting Basics
- Table Report Groups
- Matrix Report Row and Column Groups
- Report Totals and Subtotals
- Report Headers and Footers
- Report Headers
- Scrolling Headers
- Exporting to PDF, XML, Excel, Word
- Formatting Properties
- Properties
- Alignment
- Border
- Fill
- Font
- General
- CanGrow/CanShrink
- Number
- Format
- Position
- Visibility
- PageName
- Properties
- Filters and Sorting
- Filters
- Tablix
- Dataset
- Sorting
- Tablix
- Interactive
- Filters
05. Charts and Formatting
- Charts
- Column
- Line
- Shape
- Funnel
- Pie
- Pyramid
- Tree Map
- Bar
- Area
- Range
- Boxplot
- Scatter
- Bubble
- Polar
- Radar
- Data Bars & Gauges
- Data Bars
- Gauges
- Radial
- Linear
- Sparklines & Indicators
- Sparklines
- Indicators
06. Advanced Reports
- Expressions
- Add Custom Code
- Expressions
- Dashboards & Drill Functions
- Dashboards
- Document Map
- Report Drill Functions
- Drill Down
- Drill Through
- Matrix Drill Down
- Go to URL Action
- Page Breaks
- Subreports
- Parameters
- Dataset
- Data type
- Drop down
- Multiple Values
- Available Values
- Defualt Values
- Cascading
07. Report Manager & Deployment
- Report Manager & Configuration Manager
- Configuration Manager
- Report Manager Title
- Deploy Reports
- Visual Studio
- Report Manager
- Report Builder
- Report Customization
- Shared Data Sources in Report Manager
- Shared Datasets in Report Manager
- Cached Reports
- Linked Reports
- Report Parts
- Report Snapshot
- Security
- Subscriptions
08. Report Builder
- Install Report Builder
- Creating and Managing Reports
- Report Wizards
- Create a new Dataset using Report Builder
- New Table or Matrix Report using Wizard
- Table Report Without Wizard
- Pie Chart Using Wizard
- Bar Chart without a Wizard
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Install SSRS
Create new Projects
Set up data sources
Create and customize Reports
Format Reports
Create Charts and Dashboards
Install report builder
WHO SHOULD ATTEND
This SQL course is suitable for IT professionals who work with all versions of SQL, and who would like to know how to use this system and expand their knowledge.
PREREQUISITES
There are no required pre-requisites for this course, however, we do suggest that students have a prior understanding of SQL.
COURSE OUTLINE
01. Preparing the Work Environment
- SSRS Installation
- SQL Server Database Engine Required
- Download SSMS
- Download VS Community 2019
- Download SSDT SSRS Extension
- SSRS Configuration
- Report Server Configuration Manager
- SSRS Web Service URL
- Web Service API
02. Web Portal URL
- Exploring SSRS Web Portal URL
- New
- Upload
- Report Manager Upload Text, PDF, and Images
- Manage Folder
- Tiles
- Settings
- Download
- Help
03. Data Sources and Datasets
- Report Data
- Query types
- Text
- Table
- Views
- Stored Procedures
- Reports
- Table
- Matrix
- List
- Report Add-Ins
- Image
- Textbox
- Rectangle
- Line
04. Report Formatting
- Formatting Basics
- Table Report Groups
- Matrix Report Row and Column Groups
- Report Totals and Subtotals
- Report Headers and Footers
- Report Headers
- Scrolling Headers
- Exporting to PDF, XML, Excel, Word
- Formatting Properties
- Properties
- Alignment
- Border
- Fill
- Font
- General
- CanGrow/CanShrink
- Number
- Format
- Position
- Visibility
- PageName
- Properties
- Filters and Sorting
- Filters
- Tablix
- Dataset
- Sorting
- Tablix
- Interactive
- Filters
05. Charts and Formatting
- Charts
- Column
- Line
- Shape
- Funnel
- Pie
- Pyramid
- Tree Map
- Bar
- Area
- Range
- Boxplot
- Scatter
- Bubble
- Polar
- Radar
- Data Bars & Gauges
- Data Bars
- Gauges
- Radial
- Linear
- Sparklines & Indicators
- Sparklines
- Indicators
06. Advanced Reports
- Expressions
- Add Custom Code
- Expressions
- Dashboards & Drill Functions
- Dashboards
- Document Map
- Report Drill Functions
- Drill Down
- Drill Through
- Matrix Drill Down
- Go to URL Action
- Page Breaks
- Subreports
- Parameters
- Dataset
- Data type
- Drop down
- Multiple Values
- Available Values
- Defualt Values
- Cascading
07. Report Manager & Deployment
- Report Manager & Configuration Manager
- Configuration Manager
- Report Manager Title
- Deploy Reports
- Visual Studio
- Report Manager
- Report Builder
- Report Customization
- Shared Data Sources in Report Manager
- Shared Datasets in Report Manager
- Cached Reports
- Linked Reports
- Report Parts
- Report Snapshot
- Security
- Subscriptions
08. Report Builder
- Install Report Builder
- Creating and Managing Reports
- Report Wizards
- Create a new Dataset using Report Builder
- New Table or Matrix Report using Wizard
- Table Report Without Wizard
- Pie Chart Using Wizard
- Bar Chart without a Wizard
