SSRS Video Tutorial

Scripts for the Tutorial

Script to create TotalSale Table with Data for Practice

Introduction

1. Introduction to SSDT and  Create First Solution with default Project
2. How to Create Solution with Multiple Projects or Add Existing Projects
3. Understand Shared Data Sources
4. Understand Embedded Data Sources in SSRS 
5. Intro to Embedded Data Sets and Shared Data Sets
6. Overview of Reports Tab in SSRS Project

Report Wizard

1. Create Tabular Report by using Report Wizard
2. Create Tabular Report by using Page and Details in Group option by using Report Wizard
3. Create Stepped Report by using Report Wizard
4. Create Stepped Drill-down Report with Sub Total by using Report Wizard
5. Create Block Report with Sub Totals by using Report Wizard
6. Understand Page,Group and Detail in Report Wizard
7. Create Matrix Report by using Report Wizard
8. Use Query Builder Features in Report Wizard to create SQL Query for Report

Create Different Types of Reports from Basics

1. Create Tabular/Detail Report from Basics in SSRS
2. Create Stepped Grouped Report with Subtotal and Grand Total from Basics
3. Create Block Group Report with Sub Totals and Grand Total from Basics
4. Create Drill-down Group Report with Group Total and Grand Total from Basics
5. Create Multi Group Drill-down report with Group Totals and Grand Total
6. Create Report with Group on Page without Wizard in SSRS
7. Create List Reports in SQL Server Reporting Services
8. Display Report Name and Header Row on Each Page in SSRS Report
9. How to Display all the rows on Single Page in SSRS Report
10. How to Add Running Total To Tabular Report in SSRS
11. Add Running Total by Group and DataSet Level in SSRS Report
12. Add Row Number to rows in SSRS Report ( DataSet Scope and Group Scope)
13. Create Drill through Report
14. Create Sub Reports and Call them in Master( Main) Report
15. Create Report with Tabs
16. How to create report that get Image from Database Table in SSRS

Make Use of Report Items

1. How to create Matrix Report in SSRS
2. How to use Sub Report Report Item
3. How to Create Column Chart in SSRS Report
4. Highlight Columns in Chart for Max and Min Values in SSRS Report
5. How to Create Stacked Chart Report in SSRS
6. How to Display Total on top of Stacked Chart in SSRS Report 
7. How to Combine Column Chart with Line Chart in SSRS Report  
8. How to Plot multiple lines on Same Graph from Same Dataset in SSRS Report
9. How to Custom Color Columns in Column Chart in SSRS Report
10. How to Create Pie Chart in SSRS Report 
11. How to Display Percentage in Pie Chart in SSRS Report 
12. How to Change Data Labels Positions in SSRS Report
13. How to Show Data Labels in Tooltip on hover in SSRS Report 
14. How to Change the Width of Columns/Bars in SSRS Report 
15. How to Create Bar Chart in SSRS Report
16. How to Create Bar Stacked Chart in SSRS Report
17. How to Create Area Chart in SSRS Report 
18. How to Create Scatter Chart in SSRS Report  
19. How to Create 100% Stacked Column / Bar Chart in SSRS Report
20. How to Create Line Chart in SSRS Report
21. How to use Gauge in SSRS
22. How to use Data Bar in SSRS Report
23. How to use Spark-line in SSRS Report
24. How to make use of Indicator in SSRS Report

Dynamic Reports

1. How to create SSRS Report with Dynamic Columns ( When Definition of Source Table/View Change very often)
2. How to create SSRS Report Dynamically with Dynamic Schema, Dynamic Table Name and Dynamic Columns

SSRS Maps

1. How to Create Map Reports in SSRS ( Map Gallery - Basic Map)
2. How to create Map Report in SSRS ( Map Gallery - Color Analytical Map)
3. How to Create Map Reports in SSRS ( Map Gallery - Bubble Map)
4. How to create Map Reports in SSRS ( ESRI Shapefile)
5. How to create Map Reports in SSRS (SQL Server Spatial Query)
6. How to create Map Reports in SSRS (ESRI Shapefile and Bing Map Layer)

Parameters

1. How to Create Static Values Parameter with Default Value in SSRS Report
2. How to Create Single Value Parameter with Values from Query in SSRS Report
3. How to Create Multi Value Parameter in SSRS Report
4. How to create Date Parameters with Calendar in SSRS Report
5. How to Create Radio Button Parameters in SSRS reports
6. How to Create Cascade Parameters in SSRS Report
7. Allow Null Value Parameter Option to Pass Null value From Parameter In SSRS Report
8. How to make SSRS Report Parameter Optional ( Ignore the Parameter)
9. How to pass value to Parameter from Main Report ( drill through scenario)
10. How to use Stored Procedure with Single Value Parameter in SSRS Report
11. How to use Stored Procedure with Multi value Parameter in SSRS Report
12. Wildcard Search SSRS Report Parameter  LIKE '%' + @Param+ '%'
13. Show Null value for Multi Value Parameter in SSRS report
14. Default Multi Value Parameters are Not Selected in SSRS Report
15. Add/Delete/Rename Parameters in SSRS Report
16. How to show Report Parameter values while displaying Rows in SSRS Report 
17. Create Master Report with Report Selection Parameter To Display Selected Report 
18. CasCading Parameters with Dynamic SQL in Stored Procedures in SSRS Report 
19. How to use Filters in SSRS Report
20. How to use Top N Rows in SSRS Report Parameter for Default Values 
21. How to create Expand Collapse Parameter in SSRS Report

Introduction to Built-in-Fields / Properties / Expressions

1. What Are Expressions in SSRS Report
2. How to Create Report Variable ( Global Variable) in SSRS Report
3. How to create Group Variable in SSRS Report
4. Show Different Images depending Upon Value of Cell in SSRS Report
5. How to add Page X or TotalPages in Report Footer or Report Header by using expressions
6. What is page break in SSRS and how to use it?
7. How to use Bookmark in SSRS report to navigate between Report Items
8. How to Limit Rows per Page in SSRS Report
9. Limit Rows per Page in SSRS Report with Group
10. Limit Number of Rows per Page by Parameter in SSRS Report
11. Hide/UnHide Columns and Shrink the Remaining Columns By Using Parameter in SSRS Report
12. Pass Parameter Value from Image Click in SSRS Report
13. How to Toggle Report Contents by Image Clicking ( Bookmark in SSRS Report)
14. How to use External Image in SSRS Report 
15. How to Rotate Text in SSRS Report 
16. How to Display Checkbox for Active and Inactive values in SSRS Report 
17. How to Auto Refresh SSRS Report Data on Interval
18. How to Change Color of Text and Header Row after Interval in SSRS Report

Conditional Formatting- Functions

1. How to use IIF and Switch Functions in SSRS to perform conditional formating
2. Change Null Values in cell in SSRS Report
3. How to hide Empty Rows in SSRS Report
4. How to change color of Rows per group in SSRS Report
5. How to change Color of Alternative Row in SSRS Report
6. How to Format Text Differently in the Same Text Box in SSRS Report ( Rich Text Box)
7. How to Join Two DataSets in SSRS Report by using Lookup Function

Sorting

1. How to Implement Interactive Sorting on Detail Columns and Group Columns in SSRS Report
2. How to Sort the Results by using Parameters in SSRS Report
3. How to Implement Interactive Sorting on Matrix Row Groups and Column Groups in SSRS Report 

Reporting Manager / Deployment

1. How to create Folders for different Departments, Data Source, Data Sets
2. How to Create Data Source in Report Manager Web Interface in SSRS
3. How to deploy Report and Data Source from Report Manager in SSRS Report
4. How to move report between folders by using Reporting Manager in SSRS
5. How to download report from Report Server to Local Folder
6. How to Deploy Data Source to Report Server from SSRS Project( BIDS/SSDT)
7. How to deploy Single/Multiple/All Reports to a Folder from BIDS/SSDT to Reporting Server
8. How to create Report with Shared DataSet and Deploy to Reporting Server

Report Builder

1. How to Install Report Builder for SQL Server
2. Get familiar with Getting Start Window and Diff Menus in Report Builder 
3. How to create Detail Report in Report Builder By Wizard
4. How to Create Blocked Report with Sub Totals in Report Builder
5. How to create Stepped Report with SubTotal in Report Builder By Wizard
6. How to Create Matrix Report by using Wizard in Report Builder
7. How to create Report with Parameters in Report Builder By Wizard 
8. How to Create Chart Report by using Chart Wizard in Report Builder
9. How to Create Table Report from Scratch in Report Builder 
10. How to Create Matrix Report from Scratch in Report Builder 
11. How to Modify Existing Report and Republish to Report Server by Report Builder  
12. How to create Report with Parameters by Report Builder from Scratch
13. How to Create Report with Shared Data Set and Deploy to Report Server
14. How to use Shared DataSet in Report Builder to Create Report
15. How to Create Chart Report(Column,Bar,Stacked,Pie) by Report Builder

Security

1. Built in Roles
2. Provide Browse Permission to user on Single/Multiple Reports
3. Provide Permission to user on Folder level
4. Provide Report Deploy permission to user in SSRS 

Scheduling/Subscription

1.  How to Setup a Windows File Share Subscription in SSRS
2. Create SSRS Report with DateTime By Using Standard Subscription In SQL Server Reporting Services
3. Setup Windows file share subscription in ssrs with Default Parameter Value
4. How to use Subscription to email report with default Parameter values
5. Write Report to different Folders according to the parameter value ( Data Driven Subscription)
6. Send Report in Email to different users according to the region they belong to ( Data Driven Subscription)

Report Database

1. Reporting Services Databases ( ReportServer and ReportServerTempDB)

SSRS Error Logs

1. How to check Report Server Errors from ReportServerService Log file

Exporting SSRS Reports

1. How to Export detail and Drilldown SSRS Reports to Excel
2. Export SSRS Report To Excel and Name Sheets to Group Values Automatically
3. How to Export SSRS Report to CSV ,Tab or Pipe Delimited File
4. How to export SSRS Detail and SSRS Drill Down Report to PDF
5. Export SSRS Report to PDF with Expanded Drilldown
6. Export Report Items ( Tablix,Matrix,Chart) to Different Sheets in Excel with Names