SSRS report export into multiple files

• scottichrosaviakosmos

  SSCommitted

  Points: 1889

  More actions

  May 8, 2017 at 12:51 am

  #336858

  I have an SSRS reports with a master report using sub-report frames. The master report has drop-down parameter. On selection of each drop-down value the master reports calls 4 sub-reports.
  I select the drop-down value(which is 1 at a time to view reports) to view reports and  then to export the report in an Excel.
  Once we export the reports into excel we can see 4 sheets in a single excel (represents all 4 child reports).

  The problem is that I have to select 1 drop-down @ a time to export the report. Is their any way that I select all drop-down value(or a check box which makes all select) and when export then every drop-down value will be exported as an excel file and each with 4 sheets?

  I can do this in C# with report builder or SSRS Subscription(10 subscription 2 different time with different default parameters) but I want to know if this is possible in SSRS.

  Any suggestion would be great help towards Automation.