One useful feature of a reporting tool is to receive an email when a condition is met in your data (e.g. receiving an email if if a status has not been updated or if a count or a sum is not as expected).

This could be simply done by:

1. create a report that would return records only if the alert must be sent (use either the SealMasterTable to enter your SQL or a pre-defined Data Source).
   
2. create a model and a view to show these records
   
3. create an Email Output for your report (assuming you have already a EMail SMTP Device already defined with the Server Manager)
   
4. In the Output definition, set the option 'Cancel Generation if no Records' to True
   
5. Finally, define a schedule for this output, the check could be done every 5mn, day, month depending on your needs

The email will be sent only if the report execution returns records.

More complex conditions can be also specified by using the Pre-Generation script of the Output:
A Razor script can be used: if the result string of the script is 0, the generation is aborted.
e.g. The following script can be used in the Pre-Generation for the output:

Quote:

@using Seal.Model
@{
ReportOutput output = Model;
string result = "1";
if (output.Report.HasErrors)
{
result = "0";
}
}
@result

Edited by user Monday, January 20, 2014 8:06:05 AM(UTC)  | Reason: Not specified