Post reply

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

  • 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

  • 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

  • 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

  • July 4, 2016 at 5:01 am

    #1888266

    check this link

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply