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.
| 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.. |
 |
|
|
|
|
|
Problem with SSRS Recursive grouping