October 17, 2007 at 9:04 am
Hello,
We are managing the online event registration process for an organization. When someone signs up for an event with this organization, we produce a PDF-formatted ticket/receipt for the purchaser via a third-party tool. This receipt is set up to be emailed to the individual as soon as the order is approved.
I'd like to produce and send this same receipt to the purchaser via SQL Server 2005 Reporting Services as Reporting Services allows for a much better version of this ticket/receipt.
My question is, can one Data-Driven Subsciption be created such that each time a member successfully orders a ticket, the Subscription will run, and email the ticket/receipt in Reporting Services to only that person (identified through a primary email address in the registration process)? Or would I have to create individual subscriptions for each member in order to accomplish this?
We are using SQL Server 2005 Enterprise Edition.
Thanks,
Mark
October 17, 2007 at 9:12 am
I humbly :hehe: submit this article http://www.sqlservercentral.com/articles/Development/2824/.
I'm sure you can use this method by either creating a Trigger to fire it, or a scheduled job.
Hope this helps....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 17, 2007 at 9:20 am
Thank you much,
I'll definitely try this method out!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply