Generate multiple SSRS reports by grouped field
Posted on 2011-11-21
I have a report that is sent out as a pdf by email every night.
It contains a list of records with errors and goes to every department in the company, with the records grouped by department.
The report is quite large, and the company is expanding, so the report will soon become a pain for the managers, who will have to scroll through pages and pages of irrelevtant data to find their department's section.
I would like to have a separate report go out to a separate email address for each department, however I don't want to have to create a separate report and subscription for every department manually, nor do I want to have to keep this system manually updated in the future as the business changes.
I have a table in the database with department email addresses which can be added to the report data as a field or accessed separately. Is there any way to have the report run in such a way that instead of grouping by department it creates separate reports by department, and then emails them to the department email addresses?