SSRS - Export to Excel missing drill downs

• Jason-1080732

  Mr or Mrs. 500

  Points: 546

  More actions

  June 11, 2009 at 8:25 am

  #206244

  I have a report with two tables. Both are hidden and only one is displayed based on a parameter. The table has multiple groups that are initially hidden and toggled. All works fine, except when I export to excel the drill downs are removed and the report is fully expanded.

  Is there a fix for this? Other than leaving both tables visible?

  thanks

• Source-NH

  SSCarpal Tunnel

  Points: 4165

  More actions

  June 15, 2009 at 10:28 am

  #1009759

  Not all rendering formats support drill-down. I believe that only HTML and PDF support it. I know that Excel does NOT.