Report subscription only send email when report has lines

Question

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?

Robert Byrne · Accepted Answer

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.

dan · Answer

Instead of using the OOTB report subscriptions I did some Process Orchestration that uses the Contains Data reporting component to check if the report contains any data and doesn't send the email if it contains no data. The only con is that it's not configurable by a standard user but it provides the functionality required.