Leak rate trigger
If I have a cell that has >=50 AND another that has >=15 then I want the cell with this formula to read YES, if either of the two cells are not >= those numbers then the cell should read NO.

Answer Question   |  June 3, 2009  9:49 PM
Conditional expressions, Crystal Reports, Formula Workshop

Crystal Report Query – Birthday Formula
I currently run a report that returns customer birthdays within given date perameters. I use the following formula to calculate birthdays: Date(year(CurrentDate),month({driver_details.drd_dob}), day({driver_details.drd_dob}) ) I then set parameter values to return birthdays within a certain range (e.g. start 22/12/2008 end 28/12/2008). This has been working perfectly until I try to go into 2009, (e.g. the [...]

Answer Question   |  December 23, 2008  8:56 AM
Birthdays, Crystal Reports, Crystal Reports formulas, Formula Workshop

Formula workshop – using AND/OR
Using the formula workshop, I am trying to display all records from 10am to 11am that have EITHER data in “field A” OR data in “field B”. What is returned are records in the correct time frame (10am-11am), that have data in the “field A”, however the records that have no data in “field A” [...]

Answer Question   |  April 24, 2008  7:09 PM
Crystal Reports, Formula Workshop