Crystal reports formula – equal or less than 60 days
Hi I am using crystal report XI I am trying to set -up a formula to retrieve all records where the Expiration EndDate <= 60 Days to Current date. Thanks.

Answer Question   |  July 17, 2009  8:19 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI

When subreports, details and formulas are executed?
I have a formula in the Detail B section called @Status. This formula gets the job status code for each job being displayed in the detail B line, using shared variables. These shared variables get their data from various subreports which are in the Detail A section. It is grouping on Due dates with sub [...]

Answer Question   |  May 28, 2009  3:15 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports Subreport

Most current effective date
I am using a table that has multiple effective dates for employees. How do I write a formula in crystal to obtain the most current effective for each person?

Answer Question   |  May 11, 2009  2:55 PM
Crystal Reports, Crystal Reports formulas

Crystal Report Formula in-line
I have a Crystal Report (10) and I want the data under a group to print horizontally and not vertically. The sort is by group 1 (name) the data is in Group 4 and prints one line for each line of data. I want it to print all data on 1 line.

Answer Question   |  March 9, 2009  5:40 PM
Crystal Reports, Crystal Reports 10, Crystal Reports formulas

Crystal Reports Formulas
How do I set a datetime field to blank if I create a formula that has boolean response. Example: If Name.AACER = true then Name.ACCER_Date else “”

Answer Question   |  March 6, 2009  3:40 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports 8.x, Crystal Reports formulas

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

Recurring Crystal Report Filter Formula
Filter Parameter Question to make report recurring: I want it to recur every Thursday morning for the previous Monday through Sunday. I keep trying to make the date formulas but they keep failing. I have used DateAdd(“d”,-10,today) and DateAdd(“d”,-4,today) as the formulas but that didn’t work for me, this is the original below before I [...]

Answer Question   |  December 1, 2008  2:07 PM
Crystal Reports, Crystal Reports Filter Formula, Crystal Reports formulas

Crystal Reports XI printing formulas
Is there a way to print ALL the formulas that are within a rather large complex Crystal Report that I have been handed, that I didnt create and isnt working

Answer Question   |  October 31, 2008  10:29 PM
Crystal Reports 11, Crystal Reports formulas, Crystal Reports printing, Crystal Reports XI

How to compute number of hours in Crystal Reports
please help me given admtime as starttime with format (YYYY-MM-DD HH:MM:SS.MS) and currentdate as variable how can I compute the number of hours between the two parameters. please give me a sample formula.thanks

Answer Question   |  October 30, 2008  3:55 AM
Crystal Reports, Crystal Reports formulas