- Add a new report parameter:
Name: ExpandCollapseAll
Data type: Boolean
Prompt: Expand / Collapse All
Available values:
Non-queried
Label: Collapse All. Value: False.
Label: Expand All. Value: True.
Default values:
Non-queried
Value: =False. - For each Toggle Control Item (item that controls the visibility of another item)
Right-click item and select Properties
Select Visibility tab
Initial appearance of the toggle image for this report item:
Expression:
Value: =Parameters!ExpandCollapseAll.Value. - For each Toggling Item (item that shows and hides)
Right-click item and select Properties
Select Visibility tab
Initial visibility:
Expression:
Value: =Not Parameters!ExpandCollapseAll.Value.
Check Visibility can be toggled by another report item
Select the corresponding Toggle Control Item
Note: "Not" is used in the Toggling Item. Here is a helpful key:
Toggle Control Item:
True = Expanded (-)
False = Collapsed (+)
Toggling Item:
True = Hidden
False = Visible
Thursday, October 2, 2008
Runtime Expand / Collapse All option for your SSRS Report
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment