Multi Level Hierarchy in SRS using MATRIX | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Multi Level Hierarchy in SRS using MATRIX

Hi,
I have to show a multilevel hierarchy. How is it possible to achieve that. I have achieved the functionality of grouping(two level) but its not going beyond that.
Its like employee-manager data and the employee who is at the last level, his salary should be shown for horizontally for 12 months.
+ Jan Feb mar apr…
(Diffrent row)
sumit-amit- 200 190 276 345… +
(Diffrent row)
sumit-kapil-jatin- 200 190 276 345…

http://msdn2.microsoft.com/ms174787.aspx
FYi Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya,<br /><br /><br /><br />Thanks & Regards<br />Sumit Mendiratta | Capgemini | Mumbai<br />Consultant,Custom Software Development<br />Office +91 22 5556 3323 | Mobile +91 9819249554 | www.capgemini.com<br />Fax +91 5642 1100 | [email protected]<br />Yahoo msg<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />[email protected]<br />Join the Collaborative Business Experience<br />
Hi Satya,<br /><br />This is sql server analysis services but i want this in sql server reporting services.<br /><br /><br /><br />Thanks & Regards<br />Sumit Mendiratta | Capgemini | Mumbai<br />Consultant,Custom Software Development<br />Office +91 22 5556 3323 | Mobile +91 9819249554 | www.capgemini.com<br />Fax +91 5642 1100 | [email protected]<br />Yahoo msg<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />[email protected]<br />Join the Collaborative Business Experience<br />
The problem is help on Reporting Services is thin, you may be better if you can lead the issue to Microsoft support for further help. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>