Directory: First, About Report Alerts, use report alerts 1. Create a report alert 2. Edit report alert 3. Delete report alerts 4. View report alert 5, reference a alert in the formula
-------------------------------------------------- -------------- One, regarding the report alert report is created in Crystal Reports, when the report data encounters a custom message that occurs when specific conditions. Report Alerts can indicate the operations that the user will take or information about reported data.
The report alert is created with the formula for calculating the specified condition. If the condition is true, the alarm is triggered and the alarm message is displayed. The message can be a text string or a formula for text and report fields.
Once the report alert is triggered, the alert will be calculated again until you refresh the report data.
The report alert is for each report, so you need to decide when to use them, when you don't use them. Report alarms are useful for poor important information (such as sales above or less than a certain limit). And since the alarm message is created by you, you can also target your data. -------------------------------------------------- -------------- Second, the use of report alerts focus on the tasks required to use report alerts:
1. Create a report alert 2, edit the report alert 3, delete report alerts 4. View report alert 5, reference report alerts in the formula ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------ 1, create a report alert to create a report alarm, must complete the following three steps:
Name alert. Define the conditions for trigger alerts. Creating a message that is desired to trigger alert (this step is optional). Create a report alert on the Report menu, point to Alert, and then click Create or Modify Alert. The Create Alert dialog box appears.
Click New. The Create Alert dialog box appears.
Enter the name of the new alert in the Name box. Enter a alert message in the Message box. Message box allows you to enter messages used as default values. If you want each trigger alert, enter the message in the Message box.
However, if you want to use the formula to customize the message with a data element, see the next step.
If you want to create alert messages using the formula, click the Formula button on the right side of the message box. Formula studio appears. For information on how to use the editor, see Using the formula editor.
Enter the alert message formula. For example, if you want to see the message "country is a star perform", you can create the following formula:
Groupname ({Customer.Country} "Is A Star Performer"
note:
The result of the alert message formula must be a string. The DEFAULTATTRIBUTE function can be used to reference messages added to the Message box. For example, if the message in the Message box is "is a star performance", the alert message formula can be: groupname ({Customer. Country or Region) DefaultAttribute
This formula depends on the text you entered in the Message box, those texts become defaultattribute.
Message Conditions formulas can be created using a Crystal syntax or Basic syntax. Click Condition. The formula studio appears.
Enter a warning condition formula. The alarm formula can be based on repetitive records or based on the summary field, but cannot be based on the print time field (such as the total running or printing time formula). The alarm formula does not have a shared variable.
If the alarm formula is based on a summary field, then any repetitive fields used must remain unchanged in the summary field. For example, if you group in accordance with the "Country", "Region" and "City" groups, you can create the following alert: SUM ({Customer. Last year sales}, {customer. Area})
In this example, your formula can reference the "Country" or "Region", but cannot reference the "city" or "customer name" because they are changing.
Note: Alert condition formula can be created using a Crystal syntax or Basic syntax.
If you do not want to calculate alert, clear the Enable check box. Otherwise, keep its selected state.
Click "OK" to save alert. Then return to the Create Alert dialog and list your new alert. You can see its name and status (Enable "or" Disable ").
Only the enabled and disabled alerts are displayed in the Create Alert dialog. If a warning is triggered, you can see it in the Report Alert dialog. -------------------------------------------- 2, edit report On the Report menu, point to Alert, and then click Create or Modify Alert. In the Create Alert dialog box, select the alert you want to edit, and then click Edit. Tip: Double-click the alert can also edit it.
Make the required changes in the Edit Alert dialog. Click "OK" to save your changes. Note: If the alarm has been triggered, it will be removed from the Report Alert dialog box when editing it. ---------------------------------------------- 3, delete reports On the Report menu, point to Alert, and then click Create or Modify Alert. In the Create Alert dialog box, select the alert you want to delete and click Delete. The selected alert is then removed from the Create Alert dialog.
Note: If the alarm has been triggered, remove it from the Report Alert dialog box when deleting it. -------------------------------------------- 4, check the report Alerts can view the triggered report alerts in the following ways:
Refresh report data. Select "Trigated Alert" from the "Alert" submenu of the Report menu. Note: If you want to view an alert when the report data is refreshed, you must select "Display Alert" on the "Configure" tab of the Options dialog (this option is also available in the Report Options dialog).
View Report Alerts on the Report menu, point to Alert, and then click "Triggered Alert". The Report Alert dialog box appears.
Select the alert to see its record. Click View Record. A new report tab opens, showing report records that trigger alarm. If the record is hidden, the record group is displayed, but not deepening.
Note: If you click the Triggered Alert selected before clicking the "View Record" button, the result is generated by performing the AND Boolean operation by performing the selected alert.
To return to the Report Alert dialog, click the Preview tab. Click Close to close the Report Alert dialog. -------------------------------------------- 5, in the formula The reference report alerts can be quoted in the formula. Any formula of the reference alarm will become a print time formula.
There are the following functions available:
Isalertenabled () islerttriggered () AlertMessage () The behavior of these functions is the same as the alert created in the Create Alert dialog:
