SSRS - The Big Picture
- Course Introduction
- Installing SQL Server 2017
- Installing SQL Server Management Studio (SSMS)
- Installing SQL Server Data Tools (SSDT)
- Installing SQL Server Reporting Services 2017
- Configuring Reporting Services 2017
- Setting Up Sample Databases
- Overview of SQL Server Reporting Services (SSRS)
- COMPLETE COURSE EXERCISE FILES
Creating Simple Reports
- Creating a Report Using Report Wizard
- Creating a Report Manually Using Table Data Region
- Creating a Shared DataSource and Shared DataSet
- Creating a Report Manually Using List Data Region
- Creating a MailMerge Report Using List Data Region
Working with Image Control
- Using Embedded Images
- Using External Images
- Using DataBound Images
Working with Built-In Functions
- Creating Simple Expressions
- Using IIF Function
- Using Switch Function
- Writing Custom Code Functions
Grouping and SubTotals
- Report with Grouping and SubTotals using Wizard
- Report With Grouping and SubTotals Manually
- Creating Running Totals for a Report
- Creating Running Totals for each Group of a Report
- Working with Built-In Fields
Working with Bound and UnBound Parameters
- Creating a Simple Parameterized Report
- Creating a Report with DropDown Parameter
- Creating a Report with Multi-Valued Parameter
- Creating a Parameterized Report On Date Columns
- Creating a Report Using UnBound Parameters
- Parameterized Sorting
- Parameterized Sorting Using Dynamic SQL
- Creating a Report Using Cascading Parameters
- Creating a Parameterized Report with Boolean Columns
Enhancing Reports with More Functionalities
- Implementing InterActive Sorting
- Implementing InterActive Sorting Using Groups
- Implementing Drill-Down Reports
- Implementing Dynamic Column Visibility
- Implementing Conditional Formatting
- Implementing Document Map Functionality
- Repeating and Freezing Column Headers
Working with Report Actions
- Using BookMark Action
- Using GoTo Report Action
- Using GoTo URL Action
- Using Embedded HTML Feature
Working with Matrix Reports
- Creating a Basic Matrix Report
- Adding Row Groups
- Adding Column Groups
- Adding Data Cells
Working with Advanced Controls
- Working with Gauge Control
- Working with Indicator Control
- Working with SparkLine Control
- Working with DataBar Control
Working with Charts
- Creating Column Graph
- Creating PIE Graph
- Creating Bar Graph
Referencing a Custom Assembly From SSRS
- Need For Custom Assembly
- Creating an Assembly using C#
- Test Custom Assembly Methods from a Report
Deployment
- Configuring Reporting Services
- Deploying Reports
Working with Authentication Modes
- Adhoc Query
- Working with Stored Procedures
Implemeting Caching
- Creating Cached Reports
- Creating Parameterized Cached Reports
Implementing SnapShots
- Creating SnapShots for Reports
- Creating SnapShot for Parameterized Reports
Working with SubReports
- Creating Parent Report
- Creating Child Report
- Using SubReport Control
Working with Subscriptions
- Implementing File Share Subscriptions
- Implementing Data Driven Subscriptions - Part I
- Implementing Data Driven Subscriptions - Part II
- Working with Linked Reports
Working with Reporting Service Web Service
- Implementing a Custom Web Page - Part I
- Implementing a Custom Web Page - Part II
