I have a report that has a paramter (drop down) which has about 1000 possible values. I need to create a subscription that generates an excel sheet for each value in that paramter and send it as an email attachment to a selected set of people based on the paramter chosen. assume that the paramter is called bank name and has the following possible values, pnc, wachovia, boa.. when the subscription runs it should run the report with the parameter value for bankname as "pnc" generating an excel and emailing it to user@pnc.com then it should run the report with the parameter value for bankname as "wachovia" generating an excel and emailing it to user@wachovia.com then it should run the report with the parameter value for bankname as "boa" generating an excel and emailing it to user@boa.com and so on What is the best way to accomplish this Thanks for any help in advance smathew

Hi, You can use the SSRS data driven subscription to achive this. You can specify the bank values in a columns and the recipient email address in another field. Once setup and run, the report is filtered based on the value setup in bank and delivered to recipient referring the email address. Please refer the below links for more details on using data driven subscriptions. http://msdn.microsoft.com/en-us/library/ms159150.aspx http://msdn.microsoft.com/en-us/library/ms169673.aspx Note : This feature is available only in enterprise edition and report should not include any reference to user "User!UserID" Hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH