Hi, As the subject says, I got a Company dashboard that needs to be emailed out to different set of people based on the Sales Region. The Sales Region as of now is hardcoded in the dataset queries which I can pass as a parameter but not quite sure how to handle the generation and distribution of individual Regional level dashboards once its all automated through subscriptions. Thanks in advance !

This is possible with datadriven subscriptions: http://beyondrelational.com/modules/2/blogs/101/posts/13460/ssrs-60-steps-to-implement-a-data-driven-subscription.aspx http://jesborland.wordpress.com/2010/08/26/the-power-of-reporting-services-subscriptions-%E2%80%93-data-driven-subscriptions-%E2%80%93-e-mail/ http://www.databasejournal.com/features/mssql/data-driven-subscription-in-ssrs-2008-r2.html http://bhushan.extreme-advice.com/data-driven-subscriptions-in-ssrs/ Regards,Eshwar. Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

Thanks Eswararao C, I will go through the articles later during the day and mark the thread as answered if it helps me with the problem I got on hand...