Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem with SSRS Recursive grouping Expand / Collapse
Author
Message
Posted Wednesday, August 20, 2014 4:59 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:42 PM
Points: 114, Visits: 529
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!!
Post #1605632
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse