Add Expand/Collapse in the report

Refer to :http://www.sqlchick.com/entries/2010/9/19/expand-or-collapse-all-grouped-items-on-ssrs-report.html

1.  In the Row Groups pane, right-click the Details group and choose Group Properties.  On the Visibility settings, choose the radio button to Hide the details.  Check the box so that ‘Display can be toggled by this report item’ and select the "country11" textbox we just renamed in the previous step.

2. Result

3. Discussion

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f410d6ae-b909-46c5-9cf3-d2403b139d5f/

SSRS 2005:  I have a report with drilldown options.   When I export drilldown report to pdf, with groups collapsed, pdf shows no data and no +/- on the left of the group name.  Basically, it shows no data and no option to drilldown(only headers .

Comments:

You are right. Drill down doesn’t work in PDF file. So I am afraid you have to expand the drill down option before exporting to PDF file.

In addition to Raymond's post, a suggestion would be to add a parameter, say, @expandAll, with boolean True or False. In the row visibility of the toggle item, set something like =iif(Parameters!expandAll.Value,False,True) being if expandAll is true, then show all else collapse/hide. Let us know if you need further explanation. Good luck.