Crystal Reports Formulas

Need help with Crystal Report formula for most current data

Moderator note: Buggie recently posted this question and it was, well, buggy! I'm reposting it here for him with a clean format. Thanks Buggie! I'm relatively new with Crystal Reports and I would woudl appreciate any help with a formula. I am using CR 10 and my data is stored in several tables....

Formula setup on the crystal report

I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?

Crystal reports XI formula window not appearing on screen and main CR page losing focus

While running CR, when I try to use the formula editor either in the formula fields or selection areas, the window does not appear and the main CR page looses focus. It seems to me that the editor screen is someplace, but it is not visable. Any ideas?

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.

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...

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?

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.

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 ""

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...

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...

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 :(

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