Can Anyone Please help me with an “Alert”, in Crystal Report…
how to create that and how it’s works…
i created one alert name - Low Balance to show the balance lower then some limits.
But it seems like doesn’t work, 
Can please any helps…
thanks…
AhirBO (BOB member since 2012-01-25)
Hi
Objectives Of Alerts:
You must complete three steps when creating a Report Alert:
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.
–
Best Regards
Raj Mahesh
Business Objects Enterprise Solution Provider
IntelliCompute Systems Pvt. Ltd.
India
9052323420 (BOB member since 2012-01-19)
Thank you Rajesh…
But i have getting Error: “The Other Formula is Using a Filed which is not Constant for the Group level of this Field”… this error is appear.
basically i m trying to alert on sale of categories…of first three month of 1998.
so, this error message appear when i try to write somethings on Condition button.
On message button i write… {Categories.CategoryName}+“Low Balacne”…
…i don’t know man… y this is happens…
please if you can help me…?
thank you so, much for your response.
i really appreciated.
AhirBO (BOB member since 2012-01-25)
Hey Raj…
Thanks for Your Help…
i try and every thing is going well…even no error found this time…
But i didn’t see any Alert Message while i m refreshing the Report…
thanks again…
Please help me from this…
thanks…man…
AhirBO (BOB member since 2012-01-25)
Hi,
After creation of the Alert Message & Alert Condition, please enable the Alert by choosing the “tick mart” on Enable which will be appeared on Edit Alert dialog box.
Then Click on Ok.
Then It should work. See the attachment below.
Best Regards
Raj Mahesh
9052323420 (BOB member since 2012-01-19)
Hey, Raj…Thanks for your help man…
but i did the same as you – ‘Enabled the Alert’…
i enable it, but when i refresh it, it doesn’t shown up any alert…
i think i need to use ‘Height light’…concept…
thanks again…
really appreciate your help…
AhirBO (BOB member since 2012-01-25)
Great.
Sure, It will work out, may be your report don’t have any records that met with the condition you specified. If the Alert Is created properly no need to use any thing else, It will work out. Just give a try, am sure you will get It.
Best Regards
Raj Mahesh
9052323420 (BOB member since 2012-01-19)
Thanks Raj.
now it’s perfect…
i just save it and close it, after i open it again and then refresh it, the Alert Popup shown up…
thank a lot man…
AhirBO (BOB member since 2012-01-25)