• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

Can SSRS export a report to Excel and show ALL hidden data?

How can I get SSRS to export ALL hidden rows of data, when exporting a report that has row data hidden as in a drilldown type of scenario? Is there an option I need to flag as "Y"?

Thanks
M
0
MIKE
Asked:
MIKE
2 Solutions
 
mckoderCommented:
No, you can't do this in SQL 2005. However in SQL 2008 when you export a report to Excel all rows are exported, including rows that are not visible, and in Excel you can click on the + to drilldown.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now