How Do I Get a CiviCRM Report to be an attachment in a schedule job to email to a colleague?
One of the scheduled job parameters is "format". See https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_mail_report