locked
Expand Collapse in SSRS Filters RRS feed

  • Question

  • Hi,

    I want to add the feature of Expand Collapse on the SSRS Reports Filters. I have a hierarchy of Geop Hierarchy of 5 levels which is always expanded in filter when i load the report.

    I want to be able to

    + North America

    + South America

    Currently it is showing as

    North America

       USA

       Canada

    South America

       Merico

    Thanks


    Amit

    Wednesday, May 2, 2012 4:27 PM

Answers

All replies

  • Not possible.  Not out of the box anyway.  Out of the box, you can use cascading parameters but that is pretty much it. Custom developed parameter page may be needed if you must implement this sort of functionality. 
    Wednesday, May 2, 2012 4:34 PM
  • Hello Amit,

    In Reporting Services, we can enable a user to interactively expand or collapse report items or, for a table or matrix, expand or collapse rows and columns associated with a group.

    Here is an article about hiding and showing report items by adding drilldown for your reference, please see:
    http://technet.microsoft.com/en-us/library/dd207042(v=sql.105).aspx

    Regards,
    Bin Long

    TechNet Subscriber Support
    If you are
    TechNet Subscription user and have any feedback on our support quality, please send your feedback here. 


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Wednesday, May 9, 2012 1:41 AM
    Thursday, May 3, 2012 5:12 AM
  • Hello,

    Check out the threads below. It may help you.

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/cba00cd6-7c39-4233-a06b-b00ff1dd7672/

    http://www.mssqltips.com/sqlservertip/1329/drill-down-techniques-in-ssrs-with-the-visibility-property/

    Thursday, May 3, 2012 8:52 AM
  • Hi Amit, this is absolutely possible.  I have uploaded a video on how to do this.  Try that...

    http://www.bitipsntricks.com/2011/11/ssrs-2008-r2-drilldown/

    Good luck


    regards Natraj www.BItipsntricks.com Mark as Answer, if it is answer for your Question. Vote as Helpful, if it is helpful to you.

    Thursday, May 3, 2012 10:06 AM
  • It sounds like this is a question of collapsing/expanding (+) in the FILTERS or PARAMETERS section of reporting services.  That is not possible.

    Thursday, May 3, 2012 1:35 PM