Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
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.

*************************************************************************************************************
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
Tera Patron
Tera Patron

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]

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