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

Expand All & Collapse All options in a drill down report Expand / Collapse
Author
Message
Posted Thursday, October 23, 2008 5:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 04, 2009 6:10 AM
Points: 25, Visits: 131
Hi,

I have a report with drill down implemented to 3 levels.

I want to provide options to Expand all items and Collapse All items in this report.

Thanks!:)
Post #590381
Posted Tuesday, October 28, 2008 9:12 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:43 AM
Points: 946, Visits: 399
Basically, the answer is to add a report parameter for expand/collapse.
Then, for each grouping add an IIF statement to make the group visable/hidden based on the report parameter.

I googled this: reporting services collapse all

and got a bunch of results that will probably give you more step by step instructions.

Good luck.
-M



Post #592981
Posted Wednesday, October 29, 2008 7:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 04, 2009 6:10 AM
Points: 25, Visits: 131
i have implemented "Expand All and Collapse All options in a drill down" in this manner

included a boolean parameter named "ExpandAllGroups"

and then modified the sub groups as shown below:

For each sub group (except the topmost)
Edit Group --> Grouping and Sorting Properties --> Visibility Tab --> Initial Visibilty --> Expression: =IIf(Parameters!ExpandAllGroups.Value, False, True)

This is working! But the problem is even when a group is expanded the symbol showed is "+" and similarly even if a group is collapsed the symbol "-" is showed.
Post #593570
Posted Wednesday, October 29, 2008 3:39 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:43 AM
Points: 946, Visits: 399
sorry, i don't know an easy way to fix that. i think it's an ssrs 'feature'...
if you figure it out, please post.
thanks, m



Post #593974
Posted Wednesday, October 29, 2008 4:46 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 11:21 PM
Points: 138, Visits: 370
My usual way of doing that is
1. Make a boolean report parameter named "HideDetail". Depending on the user requirements, for some reports I make this a hidden parameter; otherwise I give it a parameter prompt like "Collapse Groups" or "Show Summary".
2. For each table group except the top level, set the Initial Visibility property to =Parameters!HideDetail.Value
3. For the toggle cell of each group, set its InitialToggleState property to =Not Parameters!HideDetail.Value . That sets the plus and minus toggle icons properly when the report is generated.

ezytime
Post #594009
Posted Wednesday, October 29, 2008 5:00 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:43 AM
Points: 946, Visits: 399
Great idea! Thanks for sharing.


Post #594015
Posted Wednesday, October 29, 2008 9:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 04, 2009 6:10 AM
Points: 25, Visits: 131
this solution works!:D

thank you!
Post #594071
Posted Tuesday, January 06, 2009 8:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 07, 2013 4:37 AM
Points: 256, Visits: 224
Hi,
Another simple way to do this :)

1)- write click on level 2 text box (if you want have 2 levels)
2)- Click Edit Group
3- Go to the Visibility tab
4)- Select Initial visibility Hidden
5)- Check "Visibility can be toggled by another report item"
6)- select level 1 item
7)- Click oK
and enjoy
Post #630627
Posted Friday, January 16, 2009 4:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 27, 2009 5:35 AM
Points: 12, Visits: 36
My usual way of doing that is
1. Make a boolean report parameter named "HideDetail". Depending on the user requirements, for some reports I make this a hidden parameter; otherwise I give it a parameter prompt like "Collapse Groups" or "Show Summary".
2. For each table group except the top level, set the Initial Visibility property to =Parameters!HideDetail.Value
3. For the toggle cell of each group, set its InitialToggleState property to =Not Parameters!HideDetail.Value . That sets the plus and minus toggle icons properly when the report is generated.

ezytime


Thanks a ton for this solution. It's just perfect!!:)
Post #637874
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse