Alerts In SAP Crystal Reports 2011

Follow the below 3 simple steps to create powerful alerts in SAP Crystal Reports 2011.

Alerts In Crystal Reports:

You must complete these steps when creating a Report Alert:

1) Name the alert.
2) Define the condition that triggers the alert.
3) Create the message you want to appear when the alert Is triggered.

On the Report menu, point to Alerts and then click Create or Modify Alerts.
The Create Alerts dialog box appears.
Then Click on New, again another small dialog box appears with the name “Create Alert”.

Name the Alert for eg: Important Customers
Click on the Formula symbol Icon at the Message box

Then Formula Workshop – Alert Message Formula Editor will be opened
Write your formula. 
Eg: {Customer.Country} + “Is The Star Performer”
output of this formula will be Eg: Germany Is the Star Performer.

This formula will show the Message when the condition Is satisfied which we will create In the next step. Check for any syntax errors and click on Save and close at the left corner of the formula Editor.

Now you will be returned to the Create Alert dialog box, so now click on Condition tab and again another formula editor will be opened with the name Formula Workshop – Alert Condition Formula Editor.

Here enter your condition In the formula workspace.
Eg: Sum ({Customer.Last Year’s Sale}, {Customer.Country}) > $200000.00

This condition will get catch all the records when the sales_revenue of any country crosses $200000.00

Again check for the syntax errors and Save and close.
Enable the Alert by checking the Enable option besides the Condition tab.

Click on OK.

Now Refresh your report.

An alert window will appear with the Country name and the message that you have entered In the message   Alert name will be Important Customers and Alert message will be “{Country Name} Is the Star Performer”

Though your condition Is satisfied with more countries, Alert will show only one country which Is has the highest sales among them.

That’s It, your alert Is activated and It Is working fine.

Hope this information help you to startup with creating basic alerts in Crystal Reports.