SSRS Tutorial 05 - Intro to Embedded Data Sets and Shared Data Sets in SQL Server Reporting Services

In this video of SSRS Tutorial , we will learn
  1. Difference between Embedded Data Set and Shared Data Sets
  2. Create SSRS Project / Solution 
  3. Create Embedded DataSet and Shared DataSet
  4. Create Embedded Data Set and Convert to Shared DataSet
  5. Create Report by using Embedded DataSet and Shared Dataset


1 comment:

  1. To create dbo.Sale table:

    CREATE TABLE dbo.Sale
    (
    PersonName VARCHAR(100),
    SaleYear INT,
    SaleMonth VARCHAR(15),
    SaleAmount INT
    )

    go

    insert into dbo.Sale
    Select 'Aamir',2012,'January',100
    Union All
    Select 'Aamir',2012,'February',200
    Union All
    Select 'Aamir',2012,'March',900
    Union All
    Select 'Aamir',2012,'April',456
    Union All
    Select 'Aamir',2012,'May',123
    Union All
    Select 'Aamir',2012,'June',332
    Union All
    Select 'Aamir',2012,'July',543
    Union All
    Select 'Aamir',2012,'August',765
    Union All
    Select 'Aamir',2012,'September',900
    Union All
    Select 'Aamir',2012,'October',100
    Union All
    Select 'Aamir',2012,'November',500
    Union All
    Select 'Aamir',2012,'December',100
    Union All
    Select 'Aamir',2013,'January',20
    Union All
    Select 'Raza',2011,'February',1001

    ReplyDelete