Share via

Exporting to multiple workbook from ssrs

Maheen Peermohamed 0 Reputation points
2023-08-12T22:15:53.18+00:00

Hi,

We have a sales report showing sales details grouped by individual team and their team members. When we export to excel using report builder/SSRS, we like to show sales data for each team as an individual workbook showing all their sales team members data. In that each teams workbook further we like them to split by each team member in separate tabs. Please advise how we can achieve this using row grouping in SSRS.

Regards,

Maheen,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-08-14T01:40:27.46+00:00

    Hi @Maheen Peermohamed

    This link details how to export SSRS report to multiple sheets in Excel: https://www.sqlshack.com/exporting-ssrs-reports-to-multiple-worksheets-in-excel/, hope this helps you.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.