Reporting Services - export to excel

  • I am attempting to export a Reporting Services report which contains drill-down capability.  I would like to be able to preserve that functionality when the report is exported to Excel.  Any ideas on how to accomplish this?  Thanks

  • This was removed by the editor as SPAM

  • Well if you are trying to export a report to excel if the report a link to a different report URL it will directlty support the drilldown functionality, if you have a chart that has drilldown functionality then that cannot be supported as the chart is exported to excel as an image.

     

    Prasad Bhogadi
    www.inforaise.com

  • I am attempting maintain the grouping functionality that I designed in the report.  I am grouping by Division and Cost Center.  When you export to Excel, you lose the grouping.  Attempting do an auto outline fails in Excel.  Any thoughts?  Thanks.

  • I had similar problem, when using nested lists. 

    I found I had an extra List control that was doing nothing, when I removed it the export worked fine.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply