TOIT Training

SQL SSRS

SQL SSRS
  • Overview
  • Curriculum
  • Reviews

 

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.

  • 8 Sections
  • 132 Lessons
  • 0 Quizzes
  • 9h 5m Duration
Expand All

Preparing the Work Environment

9 Lessons 0 Quizzes
  • 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 

Web Portal URL

9 Lessons 0 Quizzes
  • Exploring SSRS Web Portal URL
  • New
  • Upload 
  • Report Manager Upload Text, PDF, and Images
  • Manage Folder
  • Tiles
  • Settings 
  • Download 
  • Help 

 Data Sources and Datasets

15 Lessons 0 Quizzes
  • Report Data
  • Query types
  • Text
  • Table
  • Views
  • Stored Procedures 
  • Reports
  • Table
  • Matrix
  • List
  • Report Add-Ins
  • Image
  • Textbox
  • Rectangle
  • Line

Report Formatting

31 Lessons 0 Quizzes
  • 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 
  • Font 
  • Font 
  • General 
  • CanGrow/CanShrink 
  • Number 
  • Format 
  • Position 
  • Visibility 
  • PageName 
  • Filters and Sorting
  • Filters 
  • Tablix 
  • Dataset 
  • Sorting 
  • Sorting 
  • Tablix 
  • Interactive

Charts and Formatting

24 Lessons 0 Quizzes
  • 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  

Advanced Reports

20 Lessons 0 Quizzes
  • Expressions
  • Add Custom Code 
  • 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

Report Manager & Deployment

16 Lessons 0 Quizzes
  • 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

Report Builder

8 Lessons 0 Quizzes
  • 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

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Install SSRS
  • Create new Projects
  • Set up data sources
  • Create and customize Reports
  • Format Reports
  • Create Charts and Dashboards
  • Install report builder

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

SQL SSRS
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)