SSRS Tutorial 13 - Use Query Builder Features in Report Wizard to create SQL Query for Report

In this video of SSRS Tutorial , you will learn

  1. Understand different options/features of Query Builder in Report Wizard
  2. How to add Table in Query Builder 
  3. How to use Group by in Query Builder
  4. How to implement Filter on rows in Query Builder
  5. How to add Sort in Query Builder
  6. How to Import SQL Query from File for SSRS Report
  7. How to Import Data from RDL File Dataset
  8. How to create Report by using Report Wizard in SSRS


2 comments:

  1. Very good video about building SQL query within SSRS

    ReplyDelete
  2. It would have been helpful if you would have provided the scripts to create and populate the dbo.Region and dbo.Person table. Here they are:
    --CREATE AND POPULATE TABLE dbo.Region

    CREATE TABLE [dbo].[Region](
    [RegionID] [int] NOT NULL,
    [Region] [varchar](100) NULL,
    [RegionCD] [varchar](100) NULL
    ) ON [PRIMARY]
    GO

    INSERT INTO [dbo].[Region]
    ([RegionID]
    ,[Region]
    ,[RegionCD])
    VALUES
    (
    1
    ,N'Asia'
    ,N'AS'
    )
    ,
    (
    2
    ,N'Europe'
    ,N'EU'
    )
    ,
    (
    3
    ,N'North America'
    ,N'NA'
    )

    GO

    --CREATE AND POPULATE TABLE dbo.Person

    CREATE TABLE [dbo].[Person](
    [id] [int] NOT NULL,
    [SalesPersonFName] [varchar](50) NULL,
    [SalesPersonLName] [varchar](50) NULL,
    [RegionID] [int] NULL
    ) ON [PRIMARY]
    GO

    INSERT INTO [dbo].[Person]
    ([id]
    ,[SalesPersonFName]
    ,[SalesPersonLName]
    ,[RegionID])
    VALUES

    (
    1
    ,N'Aamir'
    ,N'Shahzad'
    ,1
    )
    ,
    (
    2
    ,N'M'
    ,N'Raza'
    ,1
    )
    ,
    (
    3
    ,N'Christy'
    ,N'Ladson'
    ,1
    )
    ,
    (
    4
    ,N'John'
    ,N'Rivers'
    ,1
    )
    ,
    (
    5
    ,N'Najaf'
    ,N'Ali'
    ,2
    )
    ,
    (
    6
    ,N'Sukhjeet'
    ,N'Singh'
    ,2
    )
    ,
    (
    7
    ,N'Chirag'
    ,N'Patel'
    ,2
    )
    ,
    (
    8
    ,N'Aleena'
    ,N'Aman'
    ,2
    )
    ,
    (
    9
    ,N'Petra'
    ,N'Henry'
    ,NULL
    )
    ,
    (
    10
    ,N'Rita'
    ,N'Roger'
    ,3
    )
    ,
    (
    11
    ,N'Tamara'
    ,N'Tony'
    ,3
    )

    GO

    ReplyDelete