Scheduled report error

siddhantgaure
Tera Contributor

Hi everyone 

 

I have created one report and scheduled the report to the user email everyday morning, the type is xsls but in the production report is exported into the PDF as I have checked the same thing into the lower environment the file is exported into the excel with same config but in production am receiving it in the PDF please let me know is it know issue and where the changes is required.

 

Thank you in advance

3 REPLIES 3

Ankur Bawiskar
Tera Patron

@siddhantgaure 

in scheduled report you should have Run as -> System Administrator

what's configured there?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur I have directly used scheduled report by selecting report there is no option available to run as

 using sysauto_report  created schedule on this table

 

 

Tanushree Maiti
Tera Patron

Hi @siddhantgaure 

 

Refer KB: KB2697684 Scheduled email of Reports are sent in wrong file format 

Resolution

1. Change the run as user in the scheduled report to a higher privileged user (or an admin user) and check if the report exports correctly as Excel. 

2. Verify the report template and scheduled report configuration on the production instance to ensure the format is set to Excel.

3. Check the emails sent from the scheduled report to confirm the attachment format matches the configured format.

 

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti