This is Online Microsoft SQL Server Reporting Services Online Tutorial using Visual Studio 2017 or SQL Server Data Tools. The following topics are covered in this SSRS Reporting Video Training Course. After learning this course, you will be able to handle real-world reporting scenarios.

SSRS Reporting Process

• Shared and Embedded DataSource and DataSet
• Report Generation using Report Wizard
• SSDT Components Explained
• DataSet used in SSRS Reporting Explained
• Tablix Report
• SSRS Grouping
• Why create Black and White Report
• DrillDown Option
• Page Break in SSRS
• Merge and Sort a column based on another column
• Add Calculated Field
• How to display loss in Red Color
• Advantage of Creating Calculated Field
• Report Header, Report Footer, Page Header and Page Footer
• How to Reset Page Number based on a Group
• How to create Document Map
• How to display the first three characters of every month for the consistent report
• How to Repeat Column Header on each Page of a Report in SSRS
• How to Freeze the Headers of a Table in the SSRS Report
• How to hide the Advanced Mode
• How to Display Different Currency Symbols in SSRS
• How to Display Different Currency Symbols in SSRS

Parameterized Reports

• How to Add Parameters in the Report
• How to use DropdownParameters in SSRS Report
• How to implement Multi-Select Parameters Option for SSRS Reports
• How to add All option to SSRS dropdown
• Fixing the No Record issue in the Report
• How to Manually Add the Options in SSRS Dropdown
• How to set up the Default Value in the Dropdown
• How to Generate Cascading Parameters in the SSRS Report
• How to deal with Multiple Values in the Cascading Parameters
• Display No Data Available for Empty Dataset and Dynamically play with Parameters
• How to use a Column which has Date Datatype as a Parameter

Chart Reports

• Creating Charts
• How to make Lower Values Visible in SSRS charts using Scale Breaks Option
• Tooltip DataLabels and Changing Chart Types
• A mixture of Columns and Lines in a Single Chart
• Dynamically changing the Chart Title based on the Dropdownlist Selected Options
• How to display a Table Report after clicking on a Chart using Drillthrough Option
• Changing Vertical Axis values in the Chart
• Major Ticks, Minor Ticks, Major Gridlines & Minor GridLines
• Pie Chart
• Legends in the Pie Chart

Advanced Reporting

• Matrix Report
• How to convert Detailed Data into Summary
• List in SSRS
• Table inside a List
• Sum Function with different Scopes in an expression
• Indicators
• Database
• Creating trends using Sparklines
• How to Name Worksheets with the Group Name Values when Exporting Report to Excel
• Using Stored Procedures as Dataset
• Subreport in SSRS