E-mail custom reports to different users

Does anyone know whats the best way to automate the e-mailing of
reports (say at the end of every month) to a list of people based on a
certian criteria for each report.
We have different sales people and we want to automate thier sales
comission report that needs to be generated and e-mailed to them (at
the end of every month) . We use thier "sales id" to query the
datbase and compile the report, so every sales person will have a
dfferent report.
Is there any suggestions to do this in one process instead of running
individual reports and e-mailing it to them seperately.
TIA
ChuckData driven subscriptions are what you are looking for. Information can be
found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chuck" <chuck@.yeshcom.com> wrote in message
news:a4000eeb.0409011253.4429edee@.posting.google.com...
> Does anyone know whats the best way to automate the e-mailing of
> reports (say at the end of every month) to a list of people based on a
> certian criteria for each report.
> We have different sales people and we want to automate thier sales
> comission report that needs to be generated and e-mailed to them (at
> the end of every month) . We use thier "sales id" to query the
> datbase and compile the report, so every sales person will have a
> dfferent report.
> Is there any suggestions to do this in one process instead of running
> individual reports and e-mailing it to them seperately.
> TIA
> Chuck