SSRS Tutorial Part 105 - Get familiar with Getting Start Window and Diff Menus in Report Builder

In this video of SSRS Tutorial, you will get familiar with Getting Start Window in Report Builder.

Following items will be covered in this video
  1. How to Start Report Builder from Reporting Manager or as separate program from Windows machine
  2. Understand Different Tabs and take detail look into each Option
  3. Report Data Menu
  4. File, Home, Insert, View Drop Downs
  5. Understand Report Builder Options
  6. Enable Show the Getting Started Dialog Box at Startup

Get familiar with Getting Start Window and Diff Menus in Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 104 - How to Install Report Builder for SQL Server

In this video of SSRS Tutorial series, we are going to learn How to Install Report Builder 3.0 and Report builder for SQL Server 2016 Reporting Services.

We will learn
  1. How to download Report Builder directory from Microsoft Website and Install
  2. How to download/install Report Builder from Report Manager


How to download and Install Report Builder - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 103 - How to Deploy Single or Multiple Reports to Report Server from BIDS/SSDT

In this video of SSRS Tutorial series, You will learn How to Deploy Single or Multiple Reports to Report Server from BIDS/SSDT

You will learn below items as part of this video
  1. How to find Reporting Server URL and Take a look
  2. How to open Report Manager UI
  3. How to open Report Solution in BIDS/SSDT
  4. How to Configure deployment path in SQL Server Data Tools / BIDS
  5. How to deploy Single Report to Report Server
  6. How to deploy Multiple Reports to Report Server (Choose the one you like to deploy)
  7. How to deploy all the reports from SSRS Project to folder
  8. How to Configure Data Source after deployment to Report Server

How to Deploy Single or Multiple Reports to Report Server from BIDS/SSDT- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 102- How to Deploy Data Source to Report Server from SSRS Project( BIDS/SSDT)

In this video of SSRS Tutorial series, we are going to learn  How to Deploy Data Source to Report Server from SSRS Project( BIDS/SSDT)

You will learn below items as well while deploying Data Source to Report Server
  1. How to find Reporting Server URL and Take a look
  2. How to open Report Manager UI
  3. How to open Report Solution in BIDS/SSDT
  4. How to Configure deployment path in SQL Server Data Tools / BIDS
  5. How to deploy Data Source to Report Server
  6. How to Configure Data Source after deployment to Report Server


v
How to Deploy Data Source to Report Server from SSRS Project( BIDS/SSDT) - SQL Server Reporting Services(SSRS) Tutorial


SSRS Tutorial Part 101-How to download report from Report Server to Local Folder by using Report Manager

In this video of SSRS Tutorial series, you are going to learn How to download report from Report Server by using Report Manager UI.

  1. How to open Report Manager Web Interface and connect to Report Server
  2. How to download report from Report Server and save to local folder
  3. How to add report to Project Project in BIDS/SSDT
  4. How to make changes to report in SQL Server Data Tools and redeploy to Report Server

How to download report from Report Server to Local Folder by using Report Manager - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 100 - How to move report between folders by using Report Manager in SSRS

In this video of SSRS Tutorial, we are going to learn How to move reports between different folders by using Report Manager.

We will learn below items in this video

  1. How to open Report Manager
  2. How to move single report from one folder to other folder
  3. How to move Multiple Reports from a Folder to another Folder
  4. How to Move Reports from Main Folder to Sub Folder and from Sub Folder to Main Folder

How to move Reports between Folders by using SSRS Report Manager- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 99- How to Deploy Report and Data Source by using Report Manager

In this video of SSRS Tutorial Series , we are going to learn How to deploy Data Source and Reports to Reporting Server by using Report Manager Web Interface.

While deploying report/s and Data Sources to Report Server by using Report Manager, we will learn

  1. How to locate report file/s and Data Source Files in Solution on Local Drive
  2. How to open Report Manager so we can upload Report and Data Source
  3. Upload Report and Data Source, Configure Report to use Data Source after deployment
  4. Preview Report in Report Manager


How to Upload Report/Data Source by using Report Manager - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 98 - How to Create Data Source in Report Manager Web Interface in SSRS

In this video of SSRS Tutorial series, we are going to learn How to create Data Source in Report Manager Web Interface.

We will learn
  1. How to open Report Manager on Windows Machine
  2. How to Create new Data Source by using Report Manager
  3. How to create SQL Server  Login and provide permissions on Database

How to create Data Source in Report Manager Interface- SQL Server Report Services(SSRS) Tutorial

SSRS Tutorial Part 97- How to create Folders for different Departments, Data Source, Data Sets by using Report Manager UI

In this video of SSRS Tutorial series, we are going to learn how to create different folders for Data Sources, Data Set and Business Types by using Report Manager.

We will learn below items in this video
  1. How to find the Report URL which is installed on machine
  2. How to open Report Server and Report Manager Web App in IE, Chrome and FireFox
  3. How to create Different Folders by using Report Manager Web Interface
  4. How to Delete Folders or Rename existing Once by using Report Manager Web Interface
  5. How to move folder/s to Another Folder or Out of Folder
  6. How to Hide folder/s by using Report Manager Web Interface

How to create difference folders by using Report Manager Web Interface- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 96 - How to use Top N Rows in SSRS Report Parameter for Default Values

In this video of SSRS Tutorial series, we are going to learn How to Pass Top N Rows to a Parameter as default Values in SSRS Report.

While we will create this SSRS Report, we will learn following Items
  1. How to create SSRS Report with Multi Value Parameter
  2. How to provide Default values to Parameter from Query
  3. How to Filter the Records for Parameter DataSet (Top N Rows)
  4. How to provide different list of values for Available Values for Parameter
How to provide Top N Values to Parameter as Default Values in SSRS Report - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial 95 - How to Toggle Report Contents by Image Clicking in SSRS Report

This video is part of SSRS Tutorial, you will be learning How to change the contents in SSRS report by clicking on Image.

As part of demo, you will learn below items

  1. How to create report from scratch
  2. How to add images to SSRS Report
  3. How to use embedded Images in SSRS Report
  4. How to use Bookmark in SSRS report

How to Toggle Report Contents by Image Clicking in SSRS Report - SSRS Tutorial

SSRS Report Part 94- How to Change Color of Text and Header Row after Interval in SSRS Report

In this video of SSRS Tutorial, We are going to learn how to change the color of Text and Header row in SSRS Report continuously on interval.

Here are the things we will learn this video
  1. How to use Second Function in SSRS Report
  2. How to use Switch in expressions 
  3. How to Change Background Color and Text Color in SSRS Report on interval

How to Change the Color of Text and Background in SSRS Report with Time- SSRS Tutorial

SSRS Report Part 93- How to Auto Refresh SSRS Report Data

In this video of SSRS Tutorial, We are going to learn How to Set Interval for Auto Refresh SSRS Data.

We will learn following items in this demo
  1. How to create SSRS Report from Scratch
  2. How to Set Auto Refresh Property of Report to on specific interval

How to Refresh SSRS Report Data on Specific Interval in SSRS Report - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 92- How to use Filters in SSRS Report

In this video of SSRS Tutorial, we are going to learn How to use Filters in SSRS Report.

While performing this demo, we will learn following items
How to create DataSet for SSRS Report
How to use Table Item in SSRS Report to create Tabular report
How to get to Filter Property and Explore different options such as
Top N Row
Bottom N Row
In Operation in SSRS Filter
Like Operation in SSRS Report
Other Operators  such as =, <>,>= etc.

How to use Filters in SSRS Report- SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial Part 91- How to Create BookMarks in SSRS Report

In this video of SSRS Tutorial, we are going to learn How to create BookMarks in SSRS Report.

While creating report with Bookmarks, we will be learning below items as well
  1. How to create Multiple Data-sets in SSRS Report
  2. How to use Matrix and Multiple Table Items in single Report
  3. How to use Textbox to Create Main Heading so On Click can go to Details
  4. How to use Bookmark to navigate between different parts of SSRS Report
  5. How to use Page Break to separate different Items in same Report
  6. How to use Image to come back to Main Page from Other Report Items

How to use Bookmarks in SSRS Report - SQL Server Reporting Services(SSRS) Tutorial

SSRS Tutorial 90- How to Create SSRS Report When Number of Columns Can change Anytime in Source Object

In this video of SSRS Tutorial, we are going to create a report in which the number of columns can change anytime. This report that we want to create should be Tabular report ( Detail Report).
The problem with the scenario is , we are using a table/view in which we can add or drop columns anytime. If we create simple tabular report , the problem is that every time our Table/View Definition change, we have to alter our report definition and redeploy.

In this video, we are going to learn some tricks, How to create report with Dynamic Columns. Here are the steps involved

We will create our SQL queries with Unpivot, Convert the columns to the Rows
Use Matrix Item in SSRS Report, so the dynamic columns can be handle dynamically
Use the Primary Key or ID as part of Rows so we have detail level data
Delete the Row level Column to hide the Primary Key
Change the definition of Table/View and check if everything working for our Dynamic Column SSRS Report

here are the queries, those we will use in our report.


CREATE PROCEDURE dbo.Sp_TotalSale
AS
    BEGIN

        IF OBJECT_ID('tempdb..##Temp') IS NOT NULL
            DROP TABLE ##Temp; 

        DECLARE @ObjectName VARCHAR(100) = 'vw_TotalSale' ,
            @KeyColumn VARCHAR(100)       = 'id';

        DECLARE @ColumnNames NVARCHAR(MAX)= '' ,
            @Values NVARCHAR(MAX)= '' ,
            @SQL NVARCHAR(MAX)= '';

        SELECT  @ColumnNames += ',

    ' + QUOTENAME(COLUMN_NAME) ,
                @Values += ',

    ' + QUOTENAME(COLUMN_NAME) + ' = CONVERT(VARCHAR(100), '
                + QUOTENAME(COLUMN_NAME) + ')'
        FROM    INFORMATION_SCHEMA.COLUMNS
        WHERE   TABLE_NAME = @ObjectName
                AND COLUMN_NAME <> @KeyColumn;


SET @SQL = N'Select * into ##Temp
FROM
(
  SELECT ' + @KeyColumn + @Values + '
  FROM ' + @ObjectName + '
) AS DRV
UNPIVOT
(
  Value FOR ColumnName IN (' + STUFF(@ColumnNames, 1, 1, '') + ')
) AS UnPVT;';
        EXEC sp_executesql @SQL;
        SELECT  *
        FROM    ##Temp;
    END;

How to create SSRS Report with Dynamic Columns- SQL Server Reporting Services(SSRS) Tutorial


  Check out related Posts / Videos in this Chapter  

SSRS Tutorial Part 89- CasCading Parameters with Dynamic SQL in Stored Procedures in SSRS Report

In this video of SSRS Series, we are going to work on Cascade Parameter. I got this question from one of the visitor.

here is the scenario
He would like to provide facility to his users to choose the Column name from the Drop down( Parameter). Once the Column name is chosen then Next parameter should show values available in the table for that column ( Cascaded Parameter). The user should be able to choose multiple values if he/she like. Once user choose the values for parameter, He/She should be able to see the results as per values provided in the parameters.

Let's create the Main Query with two Parameters

-- Main Query 
  CREATE  PROCEDURE dbo.MainQuery
  @ColumnName VARCHAR(100),
  @Values VARCHAR(MAX)
  AS 
  BEGIN
  IF OBJECT_ID('tempdb..##Temp') IS NOT NULL
    DROP TABLE ##Temp
  DECLARE @Val VARCHAR(MAX)
  SET @Val=Replace(@Values,',',''',''')

  DECLARE @SQL NVARCHAR(MAX)
  SET @SQL='Select SalepersonFName,City,State,Country,Region into ##Temp from  dbo.TotalSale where '+@ColumnName+'
  in ('''+@Val+''')'
  PRINT @SQL
  EXECUTE (@SQL)
  SELECT * FROM ##Temp
  END

  --Test your SP for Main Query
  EXEC dbo.MainQuery 'Country','Pakistan,India'


Stored Procedure for the Values Parameter ( Cascaded Parameter)
 -- Multi Value Parameter 
  Create PROCEDURE dbo.ColValues
  @ColumnName VARCHAR(100)
  AS 
  BEGIN

  IF OBJECT_ID('tempdb..##TempValues') IS NOT NULL
    DROP TABLE ##TempValues
  DECLARE @SQL NVARCHAR(100)
  SET @SQL='Select '+@ColumnName+' As val into ##TempValues from dbo.TotalSale'
  EXECUTE (@SQL)
  SELECT DISTINCT * FROM ##TempValues
  END

--Test your SP for Multiple values
  EXEC dbo.ColValues 'Country'



Query for ColumnName parameter
--Column Name Parameter Query
  SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_Name='TotalSale'


What we will learn while creating this video for Cascade Parameter report by using Stored Procedures
How to create Stored Procedures with Dynamic SQL
How to use Stored Procedure in SSRS for DataSet
How to use Stored Procedure for Parameters
How to create Cascading Parameter in SSRS Report

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

SSRS Tutorial 88- How to use SparkLine in SSRS Report

In this video series of SSRS Tutorial, we will learn how to use SparkLine in our SSRS Report.

As part of creating SSRS Report with sparkline, we will learn below items as well

  1. How to prepare Data for SSRS Report
  2. How to use Matrix Report Items with Sparkline item
  3. How to configure Sparkline Item in SSRS Report
  4. How to sort the Category values for Sparkline
  5. How to show Data Labels on Sparkline  for values and then change to Category Group value
  6. Play with different Types of Sparkline chart types

How to use Sparkline in SSRS Report - SQL Server Reporting Services(SSRS) Tutorial


  Check out related Posts / Videos in this Chapter  

SSIS Tutorial 87- How to use Data Bar in SSRS Report

In this video series of SSRS Tutorial, we will learn how to use Data Bar in SSRS Report.

We will learn below items while creating SSRS Report with Data Bars
  1. How to prepare our SQL Query for the Report
  2. How to use Matrix Item for Summary Report with Data Bars
  3. How to Configure Data Bar Item in SSRS Report
  4. How to show Data Labels on Data Bars
  5. How to enable ToolTip on Data Bars to see Category Group value on hover
  6. How to Sort the Category Group values in Data Bar

How to use Data Bar in SSRS Report - SQL Server Reporting Services(SSRS) Tutorial


  Check out related Posts / Videos in this Chapter  

SSRS Tutorial Part 86- How to Create Matrix Report in SSRS

In this video of SSRS Tutorial series, we are going to learn How to use Matrix Item in SSRS Reporting services to create Matrix Report.

While we create Matrix report in SSRS, we will learn below items
  1. How to prepare SQL Query for Matrix Report
  2. How to create Matrix Report from Scratch
  3. How to use Row Groups and Column Groups in Matrix Report
  4. How to Add Grand Total on Row Groups and Column Groups in Matrix Report


How to create Matrix Report in SQL Server Reporting Services- SSRS Tutorial


  Check out related Posts / Videos in this Chapter  

SSRS Tutorial Part 85- How to use Indicator in SSRS Report

In this video series of SSRS Tutorial, you will learn How to use Indicators in SSRS Report.

You will learn below items as well while using Indicators in SSRS Report
  1. How to create SSRS Report from Scratch
  2. How to use Indicator with default setting ( Percentage Rule)
  3. How to calculate percentage manually and use Indicator with Numeric Setting on Detail Row Level
  4. How to calculate Percentage by Group and use Indicator to show different states


How to use Indicators in SSRS Report- SQL Server Reporting Services(SSRS) Tutorial


  Check out related Posts / Videos in this Chapter  

SSRS Tutorial 84- Implement Interactive Sorting on Matrix in SSRS Report

In this video series of SSRS Tutorial, we will learn how to Implement Interactive Sorting on Rows and Columns in Matrix.

You will learn
  1. How to create Matrix Report in SSRS
  2. How to Enable Interactive Sorting on Rows Group
  3. How to Enable Interactive Sorting on Columns Groups
  4. Some Experiments and outcomes for Interactive Sorting on Matrix

How to Enable Interactive Sorting on Matrix Row and Column Groups in SSRS Report- SSRS Tutorial

SSRS Tutorial Part 83- How to Implement Interactive Sorting in SSRS Report

In this video of SSRS Tutorial series, we are going to learn how to Enable Interactive Sorting on Columns in SSRS Reports.

You will also learn below items while enabling Interactive Sorting in SSRS Report
  1. How to create reports with Group by in SSRS
  2. How to Apply Interactive Sorting on Group Column in SSRS Report
  3. How to Enable Interactive Sorting on Detail Column in SSRS Report


How to Add Interactive Sorting on Column in Sql Server Reporting Services Report - SSRS Tutorial

SSRS Tutorial 82- How to Sort the Results by using Parameters in SSRS Report

In this video of SSRS Tutorial Series, you will learn How to Sort the Results by using Parameters in SSRS Report

You will also learn
How to create static Parameters in SSRS Report for ColumnName and OrderBy
How to write expressions on Tablix to use the Parameters to Sort the Result set for Report
How to use IIF in SSRS Report
How to Sort the Data Ascending and Descending in SSRS Report


How to Sort Dynamically in SSRS Report by using Parameters - SQL Server Reporting Services(SSRS) Tutorial


SSRS Tutorial 81- How to Display Checkbox for Active and Inactive values in SSRS Report

In this video of SSRS Tutorial, You will learn How to Display Checkbox for Active and Inactive values in SSRS Report?

You will also learn
  1. How to create empty Report and create DataSet.
  2. How to Change Font Family in SSRS Report
  3. How to use Chr Function in SSRS to return character for Empty CheckBox and Checked CheckBox
  4. How to write Expression in SSRS Report



How to Display Checkbox for Active and Inactive values in SSRS Report- SSRS Tutorial 

SSRS Tutorial 80 - How to Create 100% Stacked Column / Bar Chart in SSRS Report

In this video series of SSRS Tutorial, you will learn How to Create 100% Stacked Column / Bar Chart in SSRS Report


You will also learn below items while creating 100% Stacked Chart in SSRS Report


  1. How to create SQL Query for your Stacked Chart Report
  2. How to Create Column Stacked Chart and then convert to 100% Stacked Column Chart
  3. How to Convert 100% Stacked Column Chart to 100% Stacked Bar Chart
  4. How to Display Data Labels on 100% Stacked Chart

 How to Create 100% Stacked Column / Bar Chart in SSRS Report - SSRS Tutorial



  Check out related Posts / Videos in this Chapter  

 


SSRS Tutorial 79 - How to Create Line Chart in SSRS Report

In this video series of SSRS Tutorial, you will learn How to create Line Chart in SSRS Report.

You will also learn below items while creating Line Chart in SSRS Report
  1. How to create SQL Query for your Line Chart Report
  2. How to create Line Chart by using Chart Item in SSRS Report
  3. Understand Different Types of Line Charts in SSRS Report
  4. How to Display Data Labels for Line Chart in SSRS Report



How to Create Line Chart in SSRS Report - SQL Server Reporting Services ( SSRS) Tutorial


  Check out related Posts / Videos in this Chapter  

SSRS Tutorial 78 - How to Create Scatter Chart in SSRS Report

In this video of SSRS Tutorial series, You will learn How to create Scatter Chart in SSRS Report.

You will learn
  1. How to create Query for your Report
  2. How to create DataSet in SSRS Report
  3. How to use Chart Item to Create Scatter Chart,Scatter Bubble Chart,Scatter 3D Bubble
  4. How to display Data Labels on Chart

How to Create Scatter Chart in SSRS Report - SQL Server Reporting Services Tutorial


  Check out related Posts / Videos in this Chapter  

SSRS Tutorial 77 - How to Create Area Chart in SSRS Report

In this video of SSRS Tutorial series, You will learn How to create Area Chart in SSRS Report.

You will learn
  1. How to create Query for your Report
  2. How to create DataSet in SSRS Report
  3. How to use Chart Item to Create Area Chart,Smooth Area Chart, Stacked Area Chart, 3 D Area, 3D Smooth Area and 3D 100% Stacked Area Chart.
  4. How to display Data Labels on Chart

How to Create Area Chart in SSRS Report - SQL Server Reporting Services Tutorial


  Check out related Posts / Videos in this Chapter  

SSRS Tutorial 76- How to Create Bar Stacked Chart in SSRS Report

In this video of SSRS Tutorial series, You will learn How to create Bar Stacked Chart in SSRS Report.

You will learn
  1. How to create Query for your Report
  2. How to create DataSet in SSRS Report
  3. How to use Chart Item to Create Bar Stacked Chart
  4. How to display Data Labels on Chart

How to Create Bar Stacked Chart in SSRS Report - SQL Server Reporting Services Tutorial


  Check out related Posts / Videos in this Chapter