Expporting from SSRS to Excel with All Drill-Down Levels
-
I'm running into an issue with exporting to Excel.
I have a simple report that's grouped and drilled down by two levels.
When I export the report to Excel, it preserves the top level drill down but not the second level.
The second level displays all the detail rows, which can have many rows.
So instead of the detail row being collapsed and able to drill down, it's totally expanded.
Where the red box is at, that's where the +- should be, but there's none.
Hopefully someone here has a solution. Thanks all!
-
i think what you want is a data driven subscription.
generate a view that would build all the parameters for all reports, and create a subscription that populates the parameters from that view.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply