Drill down Report...Remove the Expand (+) and Collapse (-) button for some groups

  • Hi....

    I have implemented a Drill down upto 3 levels. First level is Continents... when a Continent is expanded.... Countries in that Continent are displayed... and when a Country is expanded .... Cities in that Country are displayed.

    Now, As per requirements ... Drill down option should be given only to some specific countries and not to all.

    So, is it possible to Remove the Expand (+) and Collapse (-) button only for some Countries??:hehe:

    Regards,

    Shree:)

  • Hi... i am still searching a solution for this problem:hehe:

    Incase ... anybody has come across this scenario .... Please help!!!:D

  • I don't think that there is a way to do this natively in SSRS.

  • Did you ever find an answer to this problem? I am trying to do something similar.

    Respectfully,Kate SchwidSoftware Developer/Data AnalystOzaukee, WI

  • You can't hide the expander on the actual item you are using to toggle if it needs to be displayed i.e. the country name.

    What I have done before to get round this is add a thin column to the right of the item and I set this as the toggle item for the group below. You can then set the hidden property of this item to be based on an expression which would control whether it shows or not.

  • Spiff - Monday, April 22, 2013 9:19 AM

    What I have done before to get round this is add a thin column to the right of the item and I set this as the toggle item for the group below. You can then set the hidden property of this item to be based on an expression which would control whether it shows or not.

    This may be reawakening a 4-year old post, but Spiff's solution just saved me a **LOAD** of time trying to find a way around this issue.
    Thanks so much!!! 😀

    Kindest Regards,

    Mike M

  • Spiff - Monday, April 22, 2013 9:19 AM

    What I have done before to get round this is add a thin column to the right of the item and I set this as the toggle item for the group below. You can then set the hidden property of this item to be based on an expression which would control whether it shows or not.

    I like this idea, but am having trouble hooking it up in VS2015; probably have missed or misunderstood a step.
    I  need to  hide the  +/- minus button if there  is nothing in the group to be displayed..
    - Create the column, name the textBox "itemToggle" and give it an expression for its visibility,
    - In the Item group properties, set the "Display can be toggled by this report item:" to "itemToggle".
    On building, I get this error:
    "The grouping ‘item’ has ‘itemToggle’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent."
    What am I  missing?

    Thanks --

  • cshroedinger - Friday, July 6, 2018 9:42 AM

    Spiff - Monday, April 22, 2013 9:19 AM

    What I have done before to get round this is add a thin column to the right of the item and I set this as the toggle item for the group below. You can then set the hidden property of this item to be based on an expression which would control whether it shows or not.

    I like this idea, but am having trouble hooking it up in VS2015; probably have missed or misunderstood a step.
    I  need to  hide the  +/- minus button if there  is nothing in the group to be displayed..
    - Create the column, name the textBox "itemToggle" and give it an expression for its visibility,
    - In the Item group properties, set the "Display can be toggled by this report item:" to "itemToggle".
    On building, I get this error:
    "The grouping ‘item’ has ‘itemToggle’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent."
    What am I  missing?

    Thanks --

    You have to have a group in place, and the toggle must expand something within that group, and must be located within the group.   There's no getting around that requirement.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply