SQL Server Performance

Multi Level Hierarchy in SRS using MATRIX

Discussion in 'SQL Server Reporting Services' started by smendira, Mar 10, 2006.

  1. smendira New Member

    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...
    smendira, Mar 10, 2006
    #2

  2. satya Moderator

    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.
    satya, Mar 10, 2006
    #2

  3. smendira New Member

    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 | sumit.mendiratta@capgemini.com<br />Yahoo msg<img src='/community/emoticons/emotion-7.gif' alt=':s' />umitmendiratta30@yahoo.com<br />Join the Collaborative Business Experience<br />
    smendira, Mar 12, 2006
    #2

  4. smendira New Member

    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 | sumit.mendiratta@capgemini.com<br />Yahoo msg<img src='/community/emoticons/emotion-7.gif' alt=':s' />umitmendiratta30@yahoo.com<br />Join the Collaborative Business Experience<br />
    smendira, Mar 12, 2006
    #2

  5. satya Moderator

    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.
    satya, Mar 13, 2006
    #2

Share This Page