• State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 3 answers
  • Subscribers 94 subscribers
  • Views 2681 views
  • Users 0 members are here
Options
Related
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

Do Not send a report if empty

arlie ramirez
over 5 years ago

Greetings,

We have several reports that we would only want to email  if Data is present. These are daily/weekly reports would we would NOT want to send if the report is empty. I was not able to find any information relating to this in the manual but wanted to ask if the Report Editor or the Manager would allow us to enter this logic.

Example: If the daily report does not return any rows, then don't send the email with a blank report. Only send the report if it returns rows with data.

Thank you,

  • 0 over 5 years ago

    Hi,

    It sounds to me like the easiest way would be to put a generation condition on the “send mail” process step. Condition just needs to be a query on your data and if no data is returned then do not trigger.

    HTH

  • 0 over 5 years ago

    The process component ReportComponent has a process task ContainsData that can be used to achieve what you want. You need to build your own custom process to send the reports and include this task in it before you send/generate the report itself. You need to specify the name of the report, the parameters (or parameter set) and the report queries to use for the check in the parameter QueriesToCheck.

    If the query returns some data the process step will continue with success and if there is no data returned switch to the error branch of your process.

  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    Hi Markus - Thank you for the reply. This solution will definitely work for our team as will work with our team to build out this process.

    Best

  • 0 over 5 years ago in reply to steve knott

    Hi Steve,

    Thank you for the feedback. This solution does seem easy to implement and we will also look into Markus' recommendation as well. I will update the forum once we can define our requirements and test this out.

    Thanks!