Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am developing an office automation project that needs a report be generated every 1 st
and 16th of every month automatically and be saved in a folder in the server so that they
may have the printouts later on.

I am aware of SQL scheduler and have already developed the report but do not know how to
actually generate it automatically and save in three different formats i.e pdf, doc, txt
excel and save in the folder.

Kindly help me out to generate the report automatically and save.
Posted
Updated 21-Jan-11 19:25pm
v2
Comments
Indivara 22-Jan-11 1:26am    
Updated title, added tag

You can try Quartz.net for scheduling the report generation. It is a very powerful library which gives immense support for the scheduling activities.

You can find the information on quartz.net at http://quartznet.sourceforge.net/index.html

Simply write down a code to generate the report and export it in the desired format. Quartz.net can schedule this code whenever you want it to execute.
 
Share this answer
 
Comments
Rahul Ramteke, Cognizant 1-Feb-11 1:13am    
Quartz.net is a good open source framework, but i am not sure whether it serves the purpose op has asked.
 
Share this answer
 
You can try with Windows Service.

In it, you can create the report with data and export into necessary formats and then save on a disk. Activate service on 1st & 16th of month to do the same.

To start on with windows service, look here: Simple Windows Service Sample[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900