• 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