Expporting from SSRS to Excel with All Drill-Down Levels

• Tek

  SSCommitted

  Points: 1697

  More actions

  February 15, 2019 at 3:35 pm

  #377021

  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!

  

• Lowell

  SSC Guru

  Points: 323518

  More actions

  February 21, 2019 at 6:45 pm

  #2022614

  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!