Thursday, March 22, 2012

Data Driven Subscription or Notification Services or both

I have read all the latest data driven subscription info and seen posts
referring people to use Notification Services in some instances. Here is my
question:
I want to automatically send an email with an attached SQL Reporting
SErvices Report to a client if they submit a new order request. The client
submitts an order request that generates a new record in an SQL database that
has a Reporting Services Report that can pull up that order/invoice. I want
to automatically send that user an email with the attached report or the
report right in the email.
Can I do this with a data driven ubscription or with Notification Services?
Can I set up Notification services to send out the SQL Reporting Serives
Report based on the new record?
If I need to be in another group please elt me know.
I can do this in either SQL 2000 or 2005 depending on your answers.
thanks in advance for your assistance.
--
Jeanne Conde, MCPHi Jeanne,
My suggestion is to use trigger that calls RS to produce and send
report to the user when new record is inserted.
I am not sure wether it is really related to data driven subscription
at all. it would be more like single report for each new record event.
It will work for any SQL versions.
Hope this helped.
cheers,
ian , MCSE NT4.0sql

No comments:

Post a Comment