Problem with SSRS Recursive grouping

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Analysis Server and Reporting Services (2012)

Problem with SSRS Recursive grouping

Author

Topic

rockstar283
Yak Posting Veteran

96 Posts

Posted - 2014-08-20 : 18:56:48

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!!

[url][/url]

rockstar283
Yak Posting Veteran

96 Posts

Posted - 2014-08-20 : 23:13:56

Any help guys..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources