Send Report to Employee That Have a Certain Role

Summary:

Our finance team is interested in scheduling a report to be sent to any employee who has a particular role. The report should have parameters set to filter for only the employees department.

Content (required):

Has anyone ever accomplished something like this? I'm seeking a way to create the list of recipients dynamically so that a manual report job doesn't have to be maintained. Any advice?