1) Generate the report in CMS Supervisor (if it's historical use relative dating, where -1 is 1 day ago, -2 is 2 days ago, etc)
2) Select report | script - use the browse feature to choose a path and filename, save it as an Automatic Script. If prompted, enter your CMS login ID / password
3) Go to your windows control panel and select "Scheduled Tasks". Use the wizard to add a new scheduled task. When prompted for your login/pw here it is your network login.
Good luck