SSRS Matrix control - concern

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  May 10, 2017 at 1:30 am

  #330222

  Hi All,

  I am developing a SSRs report to view the Application allocation in Matrix format. Here are the details [Please note that I have shared the dummy data herewith];
  
Create Table dbo.Allocation
(
    EnggName    VarChar(10),
    App            VarChar(10),
    OwnerType    VarChar(10)
)
Go

  Insert Into dbo.Allocation
    Select    'Engg1', 'App1', 'Primary' Union All
    Select    'Engg1', 'App2', 'Secondary' Union All
    Select    'Engg1', 'App3', 'Secondary' Union All
    Select    'Engg2', 'App1', 'Secondary' Union All
    Select    'Engg2', 'App2', 'Primary' Union All
    Select    'Engg2', 'App6', 'Secondary' Union All
    Select    'Engg3', 'App3', 'Primary' Union All
    Select    'Engg3', 'App4', 'Primary' Union All
    Select    'Engg3', 'App5', 'Secondary' Union All
    Select    'Engg4', 'App4', 'Secondary' Union All
    Select    'Engg4', 'App5', 'Primary' Union All
    Select    'Engg3', 'App6', 'Primary'

  The SSRS Report is getting created however I am facing the problem. Please refer the screen attached for more details.

  

  Please can anyone will guide on how to make correction to the report to get the expected O/P?

  Thanks in advance,

  MH-09-AM-8694