Problem with SSRS Recursive grouping

• rockstar283

  SSCrazy

  Points: 2704

  More actions

  August 20, 2014 at 4:59 pm

  #298689

  Hello..I have the following table:

  CREATE TABLE [dbo].[test](

  [EmployeeID] [char](6) NULL,

  [Employee] [varchar](102) NULL,

  [RollupToEmployeeID] [char](6) NULL,

  [RollupToEmployee] [varchar](102) NULL,

  [Title] varchar(100),

  [Allocation] decimal(3,2)

  )

  INSERT INTO [test]SELECT '000276','Rocky','000178','Arnold','Director',0.2

  INSERT INTO [test]SELECT '000276','Rocky','000411','Jason','Coach',0.8

  SELECT * FROM [dbo].[test]

  I am trying to create a recursive report in SSRS 2012, with RollupToEmployee -> Employee relationship. i have followed the exact instructions provided here:

  LINK

  I have set 'Group on' = EmployeeID, 'Recursive Parent' = RollupToEmployeeID and 'Visibility' = Show & Toggle on Employee..but I am getting following result in SSRS

  

  Can someone please tell me what am i doing wrong here.. Shall not I see..

  Arnold

  Rocky

  Jason

  Rocky

  Thanks in advance!!