Add Expand/Collapse in the report_addexpandsql-优快云博客

本文链接：https://blog.youkuaiyun.com/riverlau/article/details/7214622

本文介绍如何在 SSRS (SQL Server Reporting Services) 中实现报表的钻取功能，并解决 PDF 导出时的问题。具体步骤包括隐藏详情并允许通过报告项切换显示状态。此外，还提供了一个参数解决方案来实现所有项目的展开或折叠。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.