This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Report subscription only send email when report has lines

I have some reports subscriptions set up but the users get an email every day, often with an empty report. Is there a way to set up a report subscription so that the email is only sent if the report has some content in it ie more than zero lines long?

Parents
  • Hi,

    We can prevent the standard process from sending reports based on a generating condition (see the Send Email step of the RPS_RPSSubscription_Send_Report process chain), but I don't believe there is a generic way to to define this 'no data' condition for all reports.  

    For specific reports maybe a simple test on the size of the report would suffice to decide whether it was worth sending? 

    Otherwise I think we would have to arrange for a field to be added to the report (eg Total Page Count or Total Data Count) and then extract and test that value in the process chain.

    hth,

    Rob.

Reply
  • Hi,

    We can prevent the standard process from sending reports based on a generating condition (see the Send Email step of the RPS_RPSSubscription_Send_Report process chain), but I don't believe there is a generic way to to define this 'no data' condition for all reports.  

    For specific reports maybe a simple test on the size of the report would suffice to decide whether it was worth sending? 

    Otherwise I think we would have to arrange for a field to be added to the report (eg Total Page Count or Total Data Count) and then extract and test that value in the process chain.

    hth,

    Rob.

Children
No Data