Post reply

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

  • January 12, 2009 at 6:42 am

    #199862

    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:)

  • January 13, 2009 at 5:09 am

    #925762

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

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

  • January 13, 2009 at 7:09 am

    #925850

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

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • April 19, 2013 at 8:00 am

    #1608234

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

    Respectfully,Kate SchwidSoftware Developer/Data AnalystOzaukee, WI

  • April 22, 2013 at 9:19 am

    #1608732

    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.

  • February 2, 2017 at 1:15 pm

    #1926454

    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

  • July 6, 2018 at 9:42 am

    #1996572

    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 --

  • July 11, 2018 at 12:41 pm

    #1997182

    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