SSRS Tutorial Part 126- How to Check Error Log file for SQL Server Reporting Services(SSRS) Errors

In this video of SSRS Tutorial, we are going to learn how to find out the error details in SSRS Error Log file.

In this video we will learn


  1. How to locate Reporting Server Log file
  2. How to find error information from Log file
  3. How to Locate SSRS Log Files?
  4. Where does Reporting Services store its log files?
  5. Where are all the places Sql Reporting Server Logs Errors?


How to get detail error log information from ReportingServer Log file- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 125- How to Join Two DataSets in SSRS Report by using Lookup Function

In this video of SSRS Tutorial, We are going to learn how to use Lookup Function in SSRS Report to Join two DataSets.

You will learn below items in this video

  1. How to create SSRS Report from Scratch
  2. How to create Multiple DataSets in SSRS Report
  3. How to Join two Datasets in SSRS Report and Display fields on Single Tablix from two Datasets
  4. Understand Syntax of Lookup Function in SSRS Report

=Lookup(Fields!id.Value,Fields!SalePersonId.Value,Fields!City.Value,"DSET_Sales_2016")



 How to join two DataSets in SSRS Report by using Lookup Function - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 94.1 - How to create Expand Collapse Parameter in SSRS Report

In this video of SSRS Tutorial, you will learn how to create a parameter by using that you will be able to Expand or Collapse groups/detail rows in single click.

In this video of SSRS Tutorial, you will learn

  1. How to create Drilldown reports in SSRS
  2. How to create Static parameter in SSRS Report for Expand/Collapse
  3. How to set default Value for Parameter
  4. How to write expressions to Expand/Collapse rows by using Parameter in SSRS Report


Expressions used in the video
=iif(Parameters!Expand.Value,FALSE,TRUE)


How to Expand Collapse Rows in Drilldown SSRS Report by Parameter - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 124 - Export SSRS Report to PDF with Expanded Drilldown

In this video of SSRS Tutorial, you will learn How to Export SSRS Report to PDF with Expanded Drilldown.

In this video of SSRS Tutorial, we will learn

  1. How to manually expand the groups in SSRS Report and Export to PDF
  2. How to write expressions to expand all the groups and detail records when export the SSRS Report to PDF


Expressions used in the video:
=iif(Globals!RenderFormat.Name="PDF",FALSE,TRUE)

How to export SSRS Report to PDF with expanded drill-down rows- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 123- How to Export SSRS Report to PDF ( Detailed Report and DrillDown)

In this video of SSRS Tutorial, you will learn how to export SSRS Report to PDF.
We will learn below items in this video


  1. How to Export Detail or Table Report to PDF
  2. How to adjust Report Size, Page Size to handle column Splitting on multiple pages
  3. How to export Drill down report to PDF


How to Export SSRS Detail and Drill Down Report to PDF - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 122-How to Export SSRS Report to csv/Tab/Pipe Delimited File

In this video of SSRS Tutorial, you will learn How to export SSRS Report to Tab/Pipe delimited file.

We will learn below items in this video

  1. How to export SSRS Report to csv file
  2. How to add option for Tab Delimited in SSRS report drop down list
  3. How to modify reportserver.config file
  4. How to add option for Pipe delimited by making change in report server config
  5. Export Report to Pipe Delimited file from Report Manager



Microsoft link for CSV Device options



How to export SSRS report to Tab/Pipe delimited file in SQL Server Reporting Services(SSRS) - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 121- Export SSRS Report To Excel and Name Sheets to Group Values Automatically

In this video of SSRS Tutorial, we are going to learn How to Export SSRS Report To Excel and Name Sheets to Group Values Automatically.

You will learn below items

  1. How to use Page break between Groups and Export to Excel
  2. How to Export Report to Excel so each group have its own Sheet


Export SSRS Report To Excel and Name Sheets to Group Values Automatically- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial 120- How to Export detail and Drilldown SSRS Reports to Excel

In this video of SSRS Tutorial, we are going to learn How to export Detail and Drill Down Reports to Excel.

You will learn below items in this video

  1. How to Export Detail Report to Excel
  2. How to Export Drill Down report to Excel



How to Export Detail and Drill Down Report to Excel- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 118- How to Create Chart Report by Report Builder

In this video of SSRS Tutorial, we will learn how to create Chart Report from Scratch in Report Builder.

You will learn below items while creating this report


  1. How to start Report Builder
  2. How to use Chart Item in Report Builder to create Column Chart/ Column Stacked Chart
  3. How to create Bar Chart/Bar Stacked Chart
  4. How to publish or deploy Report from Report Builder to Report Server
  5. How to View Report on Report Server by using Report Manager Interface


How to use Chart Item in Report Builder to create Chart Report - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 117- How to use Shared DataSet in Report Builder to Create Report

In this video of SSRS Tutorial, we will learn How to use Shared DataSet in Report Builder to create report and publish to Report Server.

We will also learn below items in SSRS Tutorial video
  1. How to connect to existing Data Source on Report Server
  2. How to use Shared Data Set from Report Server
  3. Create Table Report by using Shared Data Set fields
  4. Save Report to Report Server from Report Builder

How to use Shared DataSet in Report Builder- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 116- How to Create Report with Shared Data Set and Deploy to Report Server

In this video of SSRS Tutorial, We are going to create a report with Shared DataSet and then deploy the Report with Shared DataSet to Report Server.


We will also learn below items in this SSRS Tutorial video
  1. How to create Report with Shared Data Set in SQL Server Data Tools
  2. How to deploy Shared Data Set to Report Server from SSDT
  3. How to preview report in Report Manager after deployment

How to create Shared Data Set, Use in Report and Deploy to Report Server- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 115- How to create Report with Parameters by Report Builder from Scratch

In this video of SSRS Tutorial, we are going to learn how to create Report with Parameters by using Report Builder.

We will learn below items
  1. How to use existing Data Source from Report Server in Report Builder
  2. How to Create Data Set with Parameters
  3. How to create Table Report and Publish to multiple Report Servers
  4. How to create report with  Cascading Parameters in Report Builder

How to create Report with Parameters in Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 114- How to Modify Existing Report and Republish to Report Server by Report Builder

In this video of SSRS Tutorial, we are going to learn how to modify existing report on Report Server by using Report Builder.

We will learn following items in this video

  1. How to open existing report from Report Server for Modification
  2. How to Connect to Report Server from Report Builder and modify report and save

How to modify existing Report by using Report Builder- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 113 - How to Create Matrix Report from Scratch in Report Builder

In this video of SSRS Tutorial, we will learn how to create Matrix Report from Scratch in Report Builder.

We will learn following items in this video

  1. How to prepare SQL Query for Matrix Report or Query Designer in Report Builder 
  2. How to use Matrix Item in Report Builder to Create Matrix Report
  3. How to use Row Groups and Column Groups in Matrix
  4. How to Format Report Text and Header Column Background Color
How to create Matrix Report from Scratch in Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 112- How to Create Table Report from Scratch in Report Builder

In this video of SSRS Tutorial, we will learn how to create Table Report from Scratch in Report Builder.

We will learn following items in this video

  1.  How to start Report Builder from Report Manager
  2. How to start Wizard from Getting Start Window or File Tab
  3. How to Choose Blank Report and use Table Item to create Tabular Report
  4. How to format Text, Add Title etc. to Report
How to Create Table Report from Scratch in Report Builder- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 111- How to Create Chart Report by using Chart Wizard in Report Builder

In this video of SSRS Tutorial, we will learn how to create Chart Report in Report Builder.

We will learn following items in this video

  1.  How to start Report Builder from Report Manager
  2. How to start Wizard from Getting Start Window or File Tab
  3. How to use Chart Wizard to Create Chart Report in Report Builder

How to Create Chart Report by using Chart Wizard in Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 110 - How to create Report with Parameters in Report Builder By Wizard

In this video of SSRS Tutorial, we will learn how to create report with parameters in Report Builder.

We will learn following items in this video

  1.  How to start Report Builder from Report Manager
  2. How to start Wizard from Getting Start Window or File Tab
  3. How to use Query Designer to add Parameter/s to report in Report Builder
  4. How to create Tabular Report by using Report Builder

How to create report with Parameters in Report Builder - SQL Server Reporting Services(SSRS) Tutorial







SSRS Tutorial Part 109 - How to Create Matrix Report by using Wizard in Report Builder

In this video of SSRS Tutorial, we are going to learn How to create Matrix Report by using Report Builder

We will learn below items in this video
  1. How to start Report builder from Report Manager
  2. How to Start Wizard from Getting Start Window or File Tab
  3. How to create Matrix Report by using Report Builder

How to Create Matrix report by using  Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 108- How to create Stepped Report with SubTotal in Report Builder By Wizard

In this video of SSRS Tutorial, we are going to learn How to create Stepped report with Subtotals by using Report Builder

We will learn below items in this video
  1. How to start Report builder from Report Manager
  2. How to Start Wizard from Getting Start Window or File Tab
  3. How to create Stepped Report with Subtotals by using Wizard in Report Builder

How to Create Stepped Report with SubTotals in Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial 107- How to Create Blocked Report with SubTotals in Report Builder

In this video of SSRS Tutorial, we are going to learn How to create Blocked report with Subtotals by using Report Builder

We will learn below items in this video
  1. How to start Report builder from Report Manager
  2. How to Start Wizard from Getting Start Window or File Tab
  3. How to create Blocked Report with Subtotals by using Wizard in Report Builder

How to Create Blocked Report with SubTotals in Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 106- How to create Detail Report in Repot Builder By Wizard

In this video of SSRS Tutorial, we are going to learn How to create detail report in Report Builder by using Table/ Matrix Wizard.

We will learn below items in this video
  1. How to start Report builder from Report Manager
  2. How to Start Wizard from Getting Start Window or File Tab
  3. How to create detail report by using Table/ Matrix Wizard

How to create Detail Report in Report Builder by using Table/ Matrix Wizard - SQL Server Reporting Services(SSRS) Tutorial