NO, reporting services already does what you need. It is called a data driven
subscription... It takes a little setup, but you can pass a set of parameters
in for EACH manager, and have their deliver done to email, pdf, etc...
Look for data-driven subscriptions in Reporting services documentation.
You are really going to like this.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
[quoted text, click to view] "sam" wrote:
> I presume that subcribtion reports are run with default values to parameters
> and will be send to all the subscriibed users. User specific data cannot be
> obtained this way. Please correct me if I am wrong.
>
> Now my requirement is I have to generate a report for all the managers on
> status of their subordinates and send them the report through email. What is
> the best way to handle this? Do I have to write a .NET application that
> would pass the parameters to a report that takes the manager id or name as
> parameter and render the report as a pdf file and once that file is obtained
> attach it to email???
>
> or is there is a way to schedule a job that would run a report for each
> manager in a given list and send them to managers??? I mean can it be done
> through rport subscription???
>
> Any ideas would be appreciated.
>
> Thanks in advance,