@AdityaC8 - This feature is provided OOTB. Go to your report in the report browser from case manager portal. In there you should get an option of scheduling the report. You can specify what time it should get executed and what will be the output type (pdf/excel). You can also configure the operator's to whom you want to send that email.