Crystal Reports Creating Alerts

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Creating Alerts

Author	Message
jgarner Senior Member Joined: 23 Jan 2009 Location: United States Online Status: Offline Posts: 159	Topic: Creating Alerts Posted: 11 Mar 2011 at 6:14am
	What formula would I use to create an alert if a record is over 30 days? I tried: {PurchasOrder.OrderDate} + 30 As well as some other variations but have been unsuccessful. Thanks.
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 11 Mar 2011 at 7:32am
	DateAdd('d', 30, {PurchasOrder.OrderDate}) Would be 30 days from the given date. If you want to display an alert if someone hasn't been making payments on time, you may consider just checking the difference between OrderDate and Today. Edited by Keikoku - 11 Mar 2011 at 7:35am
	IP Logged

jgarner Senior Member Joined: 23 Jan 2009 Location: United States Online Status: Offline Posts: 159	Posted: 11 Mar 2011 at 7:47am
	I copied and pasted the formula: DateAdd('d', 30, {tblPurchaseOrders.OrderDate}) ....altered to reflect my actual table name. ....in the 'Condition' part of the 'Alerting Formulas' section and come up with the following error: The Formula result must be a boolean
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 14 Mar 2011 at 3:04am
	The formula I provided returns a date 30 days ahead of the order date. I don't know what you want to do with it, but you can return a boolean by simple using inequalities. a > b etc.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.014 seconds.