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,
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:
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..
Thanks in advance!!