• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Scheduled reports - sending via .Net 4.5, sql or Windows scheduled task?

My Web app has the ability to generate reports

Now I want to schedule some reports,  I. E send at a certain time (configured by user)  every day

The usual way I know of is to write a console app and run it as a scheduled task

However I was doing that 10 years ago
Is there anything in. Net 4.5 or. Sql server that can automatically hit a Web service to generate the reports?
0
websss
Asked:
websss
  • 2
1 Solution
 
devlab2012Commented:
There is in-built functionality in reporting services. You can use report subscriptions. Here is a link for details:

http://technet.microsoft.com/en-us/library/cc872783.aspx
0
 
websssAuthor Commented:
Thanks
but i'm using telerik reporting which has .net code that is needed to run in order to send the reports
0
 
devlab2012Commented:
Instead of creating a console application, you can achieve the same thing by creating a simple web page and a small vbs file. Here are step by step instructions:

1. Create a normal web page that will generate and send the reports. Write all the code in Page_Load as this page will not be used by a user, instead it will be called through code.

2. Create a vbs file to call this page. Use the complete url of the page in the vbs file.

3. Run the vbs file at a scheduled time using Windows Task Scheduler.

Here is a complete tutorial of creating vbs files to run a web page:

http://www.orcsweb.com/blog/using-task-scheduler-and-a-vbs-file-to-request-a-web-page-on-a-scheduled-basis/
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now