PRICE SLASH! Use the code BLACKFRIDAY2020 at check-out to get 30% OFF any course on the BitDegree Marketplace!
watching now
4 Students
65 Lessons
Beginner

What Will You Learn?

  • How to use Visual Studio for SSRS reporting
  • Use and meaning of DataSource, Dataset, Tablix, Matrix
  • Basics of lists, parameters, expressions
  • Basics of charts, image, subreporting
  • Advanced reporting techniques

Curriculum

7h 56m
Section 2: Report From the Scratch
2:10:40
SSDT Components Explained
14:46
DataSet used in SSRS Reporting Explained
10:55
Please download the Dataset used in the Report Creation
First Tablix Report
14:35
SSRS Grouping
06:25
Why to create Black and White Report
00:59
DrillDown Option
05:06
Page Break in SSRS
05:09
Merge and Sort a column based on another column
07:03
Add Calculated Field
06:52
How to display Loss in Red Color
08:06
How to create Profit% column using the keyword ReportItems in an Expression
09:12
Advantage of Creating Calculated Field
01:23
Report Header, Report Footer, Page Header and Page Footer
14:20
How to Reset Page Number on the basis of a Group
08:36
How to create Document Map
04:46
How to display first 3 characters of every month for the consistent report
04:36
How to Repeat Column Header on each Page of a report in SSRS
01:40
How to Freeze the Headers of a Table in the SSRS Report
01:57
How to hide the Advanced Mode
00:13
How to Display Different Currency Symbols in SSRS
03:56
Section 3: Parameterized Reports
1:20:34
How to Add Parameters in the Report
02:46
How to use Dropdown Parameters in SSRS Report
12:05
How to implement Multi-Select Parameters Option for SSRS Reports
04:24
How to add All option to SSRS dropdown
07:58
Fixing the No Record issue in the Report
04:21
How to Manually Add the Options in SSRS Dropdown
05:34
How to setup the Default Value in the Dropdown
05:23
How to Generate Cascading Parameters in the SSRS Report
18:12
How to deal with Multiple Values in the Cascading Parameters
04:13
Display No Data Available for Empty Dataset and Dynamically play with Parameters
10:24
How to use a Column which has Date Datatype as a Parameter
05:14
Section 4: Chart Reports
1:08:03
Creating Charts
08:51
How to make Lower Values Visible in SSRS charts using Scale Breaks Option
02:14
Tooltip DataLabels and Changing Chart Types
06:47
Mixture of Columns and Lines in a Single Chart
08:09
Dynamically changing the Chart Title based on the Dropdownlist Selected Options
15:58
Displaying a Table Report after clicking on a Chart using Drillthrough option
12:10
Changing Vertical Axis values (in Millions or Billions) in the Chart
03:14
Major Ticks, Minor Ticks, Major Gridlines & Minor GridLines
05:48
Pie Chart
03:46
Legends in the Pie Chart
01:06
Section 5: Advanced Reporting
2:22:02
Matrix Report
16:27
Please download Dataset used in the following Report
How to convert Detailed Data into Summary
08:09
Please download the Dataset used in the following Report Creation
List in SSRS
22:05
Table inside a List
08:55
How to Name Worksheets with the Group Name Values when Exporting Report to Excel
04:06
Please download the Dataset used in the following Report Creation
Sum Function with different Scopes in an expression
11:22
Indicators in SSRS
15:25
Please download the Dataset used in the following Report Creation
Databars and Creating Trends using Sparklines
17:18
Gauge in SSRS
08:31
Please download Dataset used in the following Report
Using Stored Procedures as Dataset
11:18
Subreport in SSRS
17:58

Description

Requirements

  • Basic knowledge of T-SQL, Joins and SSMS is necessary

About the Instructor

Reviews 0
Students 3
Courses 2

I am a Microsoft Certified Trainer. Having more than 11 Years of rich experience. Successfully self-employed, I am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence. Also worked as a SQL Server Developer. Lives in Delhi, India.

My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind. Because I believe we understand, remember, and learn all the things in pictures, diagrams or images. This is the science of learning.

My Microsoft Certifications are:

Microsoft Certified Solution Expert Data Platform

Microsoft Certified Solution Expert Business Intelligence

Microsoft Certified Solution Expert Data Management and Analytics

Microsoft Certified Solution Associate SQL Server 2012/2014

Microsoft Certified Trainer

Microsoft Certified Professional

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo