Dynamic Text in Body of Scheduled Report if there is no data for the given week

[Kapil Chopra1]

I need to schedule a report so that the text changes to " There is no data for this Weekend" if the report output does not have any data and the mail should trigger with the above text.

If I select "Omit if no records" Option, the mail would not trigger at all and that is something we don't want.

Any thoughts on how to achieve this?

[AnirudhKumar]

It is possible. You will need to use SncTriggerSynchronizer.

The article below uses this to send a schedule report to dynamic recipients. In your case it is not dynamic recipients but dynamic message.

You will have to just update the Subject and Introductory Message fields instead of Users field

https://community.servicenow.com/community?id=community_article&sys_id=873319531b8b98508672ea89bd4bcb64

[Kapil Chopra1]

That seems to be too complex, I guess what I'm trying to achieve should have a simple solution, if there is one.

[AnirudhKumar]

There is no other easy way.

You can do it in another way, but that is crazy complex and not very user-friendly.

This is the most direct way. It's very simple actually

[Aswini4]

Hi Kapil,

I am working on the same requirement, can you kindly share the solution if you have implemented this ?

I want to send a different message from scheduled report when there are no records.

Appreciate your help.