Hello! We need a bit more information to help you with this. How do you fetch the report and from where? If it is from a webpage or a directory on your companies network? If so you can use either download.file() or file.copy() (look at the documentation of the functions to see how to use them).
If you want to run the script automatically (say, every day at midnight) you cannot do that directly in R, but if you are on linux you can use (for example) cron.