Report send to many people

Hello i have a question,

I need to create a report that will take parameter Customer_ID and will be send to his email which is stored in my database. And i want it to happen to all of my customers so basically i need to pass this parameter automatically.

My queston is, where in a report designer or whereever it is set it that it sends this report via email and this email is taken from a field in a report?

And how exactly pass this parameter, will i have to do it programaticly by calling this report so many times or somehow the report services can manage that?

thank u for help

Marek

SSRS supports data-driven subscriptions where the Report Server will automatically send the report to the subscribed recipients. Another option is to create an application that does this programatically by calling down to the SSRS APIs.