toggle all

I appreciate your responses. I understand the concept , but it is not working for me in practice. Assume the following structure of animals with the names;

Dogs

Rex, Sam, Max

Cats

Ed, Ann, Bill

Dogs and Cats group can be toggled to display the names. The Names are the details row. Do I use the parameter expression on the "hidden" property of the details row?

Woyler at 2007-8-30 >

You can change the initial toggle image state by right-clicking on the textbox, opening the textbox properties dialog and selecting the "Visibility" tab. The bottom of that dialog tab has a section titled "Initial appearance for the toggle image of this report item". You can set the initial toggle image either statically or based on an expression value.

-- Robert

RobertBrucknerMSFT at 2007-8-30 >

My initial toggle visibility and images are working just fine with the parameter solution. I did the following:

1. Add a new report parameter:

   • Name: ExpandCollapseAll

   • Data type: Boolean

   • Prompt: Expand / Collapse All

   • Available values:

     • Non-queried

       1. Label: Collapse All. Value: False.

       2. Label: Expand All. Value: True.

   • Default values:

     • Non-queried

       • Value: =False.

2. For each Toggle Control Item (item that controls the visibility of another item)

   1. Right-click item and select Properties

   2. Select Visibility tab

   3. Initial appearance of the toggle image for this report item:

      • Expression:

        • Value: =Parameters!ExpandCollapseAll.Value.

3. For each Toggling Item (item that shows and hides)

   1. Right-click item and select Properties

   2. Select Visibility tab

   3. Initial visibility:

      • Expression:

        • Value: =Not Parameters!ExpandCollapseAll.Value.

   4. Check Visibility can be toggled by another report item

   5. Select the corresponding Toggle Control Item

Note that "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

In this example, you must change the parameter value and click on "View Report" button to refresh it.

Aaron-SoftEng at 2007-8-30 >