SSRS 2005: I have a reportwith 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 .When this report is exported to Excel, it is perfect and works exactly as it would in VS2005. Any setting to make sure an expanded report is exported to pdf? Or do i manually expand all drilldown options and then export?Thanks in advance.

Hi, You are right. Drill down doesnt work in PDF file. So I am afraid you have to expand the drill down option before exporting to PDF file. Hope this helps. Raymond

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.Chicagoan ...

Hai, I developed Expand,collapse drill down report.the results are displaying in multipage.When i clickCollapse,all records are collapsing.its showing blank whitespace.How can i reduce that white space.Please help me no this.ThanksDeepan.J

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 . When this report is exported to Excel, it is perfect and works exactly as it would in VS2005. Any setting to make sure an expanded report is exported to pdf? Or do i manually expand all drilldown options and then export? Thanks in advance. I have an exactly opposite request. With Collapse All parameter on, when exported to Excel, it still shows the details, which is NOT what I wanted. Any help on how I can control before exporting? I am using VS 2005.