Getting blank excel sheet from the scheduled report

[Vijay Anusuri]

Getting blank excel sheet from the scheduled report

I have configured reports and scheduled reports but when I am executing, receiving mail but content in excel is empty even when records are present. "Run as" user has both itil and report_group roles (tried with report_admin role as well). This is for Incident table.

Thanks in advance.

[Dr Atul G- LNG]

Hi @Vijay Anusuri 

https://www.servicenow.com/community/developer-forum/scheduled-email-of-report-sends-empty-excel-she...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0789782

Resolution

Modify the "Run as" field on the scheduled report using a user with enough privileges to access all the tables needed.

Note: If this field is not observed:
1. Right click on the top gray banner.
2. Configure > Form Layout
3. Select "run as" and move it from the left column to the right.
4. Then modify the field.

[Ankur Bawiskar]

@Vijay Anusuri 

Did you try running as System user?

Was this working fine earlier?

Empty data means system was unable to fetch data.

check these links

Scheduled report email is sending blank Excel spreadsheets despite of the report not being empty 

Scheduled e-mailed reports attaching empty PDF files 

If my response helped please mark it correct and close the thread so that it benefits future readers.