• Crystal Reports – Rounding Nearest 1/8 Mile

    I'm trying to create a report that will estimate our cost to a taxi vendor. I have the exact mileage, however I need to round to the nearest 1/8 of a mile. Does anyone have any idea how to do that either is Crystal Reports formula or SQL?

    Sarahtaj5 pointsBadges:
  • Formula to return specific results if fields match in crystal reports

    I have two seperate fields, if they return the same value I want to display that value, if they do not then I want to display another field.  I tried to use the formula below: If  {CnBio_Org_Name} =  {CnPrBs_Org_Name} Then {CnBio_Org_Name} Else {CnBio_Name}   Here is a sample of the data with...

    Umbrella5 pointsBadges:
  • Crystal reports formula

    I have a need to display a running total total on the detail lines that make up the running total. is there a way to do this 10 lines and each has 1 box. running total is 10 boxes I need each line to say a total of 10 boxes on each line    

    Dbell20 pointsBadges:
  • Crystal Reports X

    Hello, Writing a report that is to locate and publish any record that is duplicated in only one field.  Searched through to many manuals and now can not run this.  Is there a set formula to locate duplicate records?

    Magerman15 pointsBadges:
  • 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?

    56cheby5 pointsBadges:
  • 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....

    JennyMack4,280 pointsBadges:
  • 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?

    2682235 pointsBadges:
  • 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.

    Monk200830 pointsBadges:
  • 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...

    Valhalla15 pointsBadges:
  • 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?

    Meg095 pointsBadges:
  • 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.

    Nife5625 pointsBadges:
  • 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 ""

    DonnaLeeBailey5 pointsBadges:
  • 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...

    Burny0810 pointsBadges:
  • 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...

    Talkie985 pointsBadges:
  • 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 :(

    Rcsully6515 pointsBadges:
  • 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

    Lexine5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following