scheduled reports email sending blank excel

[nitin51]

Hi All,

I have configured reports and scheduled reports but when I am executing, recieving mail but content in excel is empty even when records are present.

users are active and has admin roles. run as is under user name also. can you please help me.

Created a sample record(it is there in default domain), but excel is empty 

[Mohit Kaushik]

Hi Nitin,

Check the below article, it might help you to troubleshoot.

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

Please mark this as correct and helpful if it resolved the query or lead you in right direction.

Thanks,
Mohit Kaushik
Community Rising Star 2022

[Community Alums]

Hi Nitin,

You need to check the "RUN AS" field in your scheduled report. I mean check the roles of the user "RUN AS" in the scheduled report. If the RUN AS doesn't have a proper roles i.e ITIL/other role then the report will be sent with blank columns . I too faced the same issue and have reset the RUN AS then the report was sent properly.

Did you check the file present in the email log record has data in it?

You can mark the checkbox ignore if no record to prevent sending empty excel, if no data exists for the day.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[nitin51]

Hi Sandeep,

User in "RUN AS" has Admin roles.

Checked the file in mail log, it is empty

If I mark the checkbox, then mail will not trigger.

But the report has records as shown above

[Aurelijus]

hi,

have issue been reolved? if yes how?

having same issue after the upgrade to the Sandiego.

scheduled emails execute blank sheets.

i think issue related to the Report_view access control KB0958442but cant figure out how to fix it.

please advise.