SSRS Video Tutorial

Scripts for the Tutorial

Introduction

Report Wizard


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



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


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


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


SSRS Error Logs