I need to be able to run the same report multiple times for each employee based on how many clients they have assigned to them. Is it possible for a Data Driven Report to return 10 of the same report (for each client) and attach them to one email for each specified employee? I am using SQL Reporting Service 2008.

Hi Tanya, It is possible to achieve this by using a Data-Driven subscription. Please refer to the general steps below: 1. Add a parameter for filter client in the report. 2. Create a subscription delivery table in database which contains E-mail addresses of employees and their clients. For example: Employee Client Emp1@server.com aaa Emp1@server.com bbb Emp1@server.com ccc … … Emp2@server.com ddd Emp2@server.com eee … … 3. Create a data-driven subscription on the report. Specify the Employee field in the subscription to the destination address of the deliver extension settings. Specify the Client field as values of the category parameter. After that, an employee will receive multiple reports for every relevant clients. For more information about Data-Driven Subscriptions, please refer to: http://msdn.microsoft.com/en-us/library/ms159150(v=SQL.100).aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.