We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Getting blank excel sheet from the scheduled report

Sanjay Kumar Ko
Tera Contributor

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.

 

SanjayKumarKo_0-1755622339026.png

SanjayKumarKo_1-1755622451548.png

 

 

2 REPLIES 2

Dr Atul G- LNG
Tera Patron

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.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Dr Atul G- LNG
Tera Patron

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

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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