Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 2 days ago @ 10:48 AM
Points: 10,784, Visits: 14,674
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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: Friday, March 4, 2016 6:47 AM
Points: 154, Visits: 262
Did you ever find an answer to this problem? I am trying to do something similar.

Respectfully,


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


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, June 23, 2016 3:58 AM
Points: 248, Visits: 1,823
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 (4 views, 121.53 KB)
2..jpg (1 view, 144.44 KB)
3.jpg (1 view, 72.54 KB)
Post #1445034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse