locked
matrix summary issue RRS feed

  • Question

  • I have a matrix summarized in my report, like this

    -------------------- Qty

    PartNumber-1 -- 10

    PartNumber-2 -- 5

    Total ------------- 15

     

    How can I get what are the items in value 10 and 5 and in Total? Have I need to use some function?

     

    thanks in advance

     

     




    Wednesday, February 1, 2012 11:59 AM

Answers

  • Hi Juliano_Pessoa,

    To get the detail about the sum value, I suggest you to add a drillthrough action on the total value, like "15".

    For the drillthrough action contains links to the detail values in other report, we need create another report group all data by "Qty" and this subreport is filtered by a "Qty" parameter.

    More information about How to: Add a Drillthrough Action on a Report (Reporting Services), please see:
    http://msdn.microsoft.com/en-us/library/ms159847(v=sql.100).aspx

    Thanks,
    Lola


    Please remember to mark the replies as answers if they help.
    • Marked as answer by Juliano_Pessoa Friday, February 15, 2013 1:24 PM
    Friday, February 3, 2012 1:40 AM

All replies

  • http://blog.boxedbits.com/archives/84
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, February 1, 2012 12:13 PM
  • this blog can not help me I need to know what are the values inside de sum. thanks
    Wednesday, February 1, 2012 2:39 PM
  • does anyone can help me in this issue?
    Wednesday, February 1, 2012 6:55 PM
  • Hi Juliano_Pessoa,

    To get the detail about the sum value, I suggest you to add a drillthrough action on the total value, like "15".

    For the drillthrough action contains links to the detail values in other report, we need create another report group all data by "Qty" and this subreport is filtered by a "Qty" parameter.

    More information about How to: Add a Drillthrough Action on a Report (Reporting Services), please see:
    http://msdn.microsoft.com/en-us/library/ms159847(v=sql.100).aspx

    Thanks,
    Lola


    Please remember to mark the replies as answers if they help.
    • Marked as answer by Juliano_Pessoa Friday, February 15, 2013 1:24 PM
    Friday, February 3, 2012 1:40 AM