Getting blank excel sheet from the scheduled report

Sanjay Kumar Ko · 3 weeks ago

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.

Dr Atul G- LNG · 3 weeks ago

Hi @Sanjay Kumar Ko

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.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Dr Atul G- LNG · 3 weeks ago

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************