We need to invoke every evening report for all our customers, and send
to him by email and fax according customer profile.
I read about scheduling and ability to send email but in our situation
it seem more complicated.
I not sure how deal with:
+Invoke report for each subscribe according his profile
+even if i send for all customer the same report, how I make schedule
that invoke the same report for each customer by his ID?
+how make schedule that send to each subcribe by his mail address?
+How I can make schedule to send by Fax (this is can be resolve by
Emailing to some Mail to Fax system, So for now we can ignore this Q)
I'm familiar with .NET and I have some experience to build Window
Services so if SQL Reporting not fit to our goal, I can write some
Service, but I not sure how I can Call to Reporting service to Invoke
for me Report and svae it to some format, withoute dealing with GUI.
In short, i need to invoke report and save it programmatically?I find somthing:
Tutorial: Creating a Data-Driven Subscription
at:
MSDN Library > Enterprise Servers and Development > SQL Server > SQL
Server 2005 Documentation > SQL Server 2005 Tutorials > Reporting
Services Tutorials > Creating a Data-Driven Subscription
from: SQL Server 2005 Books Online
hear the excec link:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment