Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Drill down Report...Remove the Expand (+) and Collapse (-) button for some groups Expand / Collapse
Author
Message
Posted Monday, January 12, 2009 6:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 4, 2009 6:10 AM
Points: 25, Visits: 131
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??

Regards,
Shree:)
Post #634632
Posted Tuesday, January 13, 2009 5:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 4, 2009 6:10 AM
Points: 25, Visits: 131
Hi... i am still searching a solution for this problem

Incase ... anybody has come across this scenario .... Please help!!!:D
Post #635281
Posted Tuesday, January 13, 2009 7:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:09 AM
Points: 10,342, Visits: 13,352
I don't think that there is a way to do this natively in SSRS.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #635381
Posted Friday, April 19, 2013 8:00 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 28, 2014 10:45 AM
Points: 154, Visits: 251
Did you ever find an answer to this problem? I am trying to do something similar.

Respectfully,


K8
Software Developer/Data Analyst
Ozaukee, WI
Post #1444419
Posted Monday, April 22, 2013 9:19 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 86, Visits: 760
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.








  Post Attachments 
1.jpg (3 views, 121.53 KB)
2..jpg (0 views, 144.44 KB)
3.jpg (0 views, 72.54 KB)
Post #1445034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse