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.