Export SQL Server Reporting Services Report Data into Multiple Excel Worksheets with subreport each worksheet

• annamsiva.dba

  SSC Enthusiast

  Points: 170

  More actions

  June 26, 2016 at 8:54 pm

  #314670

  Hi,

  I need a help in deciding how to get this task finish.

  I have created SSRS report. I am passing one parameter end date

  Enddate(main report)

  I am able to export SQL Server Reporting Services Report Data into Multiple Excel Worksheets with sub report. But sub report displayed in the end of excel worksheet, which means I am able to export five companies data into multiple excel worksheets but sub report displayed in fifth excel worksheet.

  But I need to export five companies Data into Multiple Excel Worksheets(main report) and sub report need to display each excel worksheet.

  How can I do this, Please let me know. Thanks

  Regards,

  Babu

• Thom A

  SSC Guru

  Points: 99137

  More actions

  June 27, 2016 at 3:28 am

  #1886987

  If you are exporting different companies, how are you telling the report to export for the different companies?

  The best way to do this would be to have 5 different subscriptions. each of these subscriptions can export to a different location (or email different people). SSRS will export any subreports as well, so having this in the report will add it to your export.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• annamsiva.dba

  SSC Enthusiast

  Points: 170

  More actions

  July 4, 2016 at 4:53 am

  #1888261

  Hi,

  Thanks for the quick reply.

  In the excel could you help me for altering...........I need the excel with report and sub-report information. Screenshot attached is for your reference.

  Thanks,

  Babu

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  July 4, 2016 at 5:01 am

  #1888266

  check this link