Description
Returns TRUE if an alert is triggered.
Arguments
alertName is the name of an alert (in quotation marks) that you've already created. Locate the available alerts in the Alert Names list.
Returns
Boolean value indicating whether or not the alert is "triggered"—that is, whether or not the report data meets the alert condition formula.
Examples
If IsAlertTriggered("myAlert") Then
AlertMessage("myAlert")
Else
"not triggered"
Use this formula to display messages that let report users know which records have triggered the report alert. For instance, open the sample report called Alerting.rpt. Create the formula, replacing "myAlert" with "Sales" (which is the name of the alert in the sample report). Then drag the formula field into the Details section. (You might have to resize the Details section in order to see the formula field properly.) The formula displays the alert message for records that meet the alert conditions; otherwise, the formula displays your "not triggered" message.
Comments
Any formula that references an alert becomes a print time formula.