Groups | Blog | Home
all groups > sql server reporting services > october 2005 >

sql server reporting services : Subscription or creating reports on demand


sam
10/20/2005 2:02:13 PM
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,
Wayne Snyder
10/24/2005 4:43:01 AM
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]
AddThis Social Bookmark Button