I have a report set up that displays the results of a query in a table. The report is sent out via email on a schedule. The issue is that I only want to send this report out if the query returns some value, not if it’s null. Is there a way to do this?
I’m not aware of the reporting scheduler being able to conditionally restrict sending like that through simple GUI means, but you can always script it using the Run Script action rather than the Email action. Just use the dataMap dictionary to find your query data and do a simple if on it:
if query is not None: #send report
How would I trigger a report using scripting tho? I want to run my script only once (large output) and maintain the formatting of that the report tool provides.
Take a look at system.report.executeAndDistribute()