Didier, to run some kind report on timely fashion you need to use an external scheduler.
Scripting languages like ASP do not provide this capability. You can create a page that creates and emails a report and put it somewhere on your webserver.
After that you can setup a scheduled task in Windows to open this page once a day. I recommend you to download WGET for this purpose.