• Formula totals wrong when drilldown

    The format of my report is: GH1, GH2, GH3, D, GF3, GF2, GF1 I have a formula fields calculating manual running totals for groups 1 and 1. Groups2 and 3 are hidden from report but allow drilldown. When I run report, GF1 running totals are fine. If I then doubleclick on GF1, the GF2 details including...

    dmneil10 pointsBadges:
  • Formula to take three date fields and create on date field with the most recent date.

    I have three date fields; approved, countered and denied. I need to have one date field called Decision date. The formula needs to account for the null values and also needs to return the most recent date out of all three of the fields. I know how to do this with two dates but haven't been able to...

    CUFBL338015 pointsBadges:
  • Crystal Reports: Sum by certain date

    I need to sum gift amounts based on the specific date a solicitor was assigned to the account.IE: One account has given gifts since 2/25/1999 however the solicitor for this account was not assigned until 5/15/2002. I want to sum all gifts this account has given since 5/15/2002.

    TracyReid10 pointsBadges:
  • Convert formula result string to number

    My formula produces a string. I want to convert it to a number. Can't use tonumber(@formula).

    TonyMass5 pointsBadges:
  • Crystal Reports

    I am trying to filter sales by the date of sale and having a whale of a time. I have a few years worth of sales data, but just want to see what was sold on a specific data Saturday for instance. Looking for any formula help for Crystal Reports.

    BoatsTours0 pointsBadges:
  • Pulling null values into reports

    I am working in Crystal Reports 9 and need to pull null values into a report. What formula do I use?

    decalvert5 pointsBadges:
  • Extract part of a field in crystal reports

    I need to be able to extract part of a field to use in a crystal report. For example: my account # is any number of digits with a - followed by another number. I just want the numbers in front of the -. If the account = 1234-1 i want it to return 1234. if the accoutn = 123-23 i want 123. How can i...

    Gisles5 pointsBadges:
  • Summing shared data from a subreport

    I have a report where I want to sum the value of a group. To get the correct number I first need to sum the multiple receipts and subtract the total receipts from the quantity required. This gives me the correct value which I multiple to the unit price. I have the correct unit price for each line,...

    Starrbound10 pointsBadges:
  • Crystal Reports grouping by multiple date fields

    Hi, I'm trying to sort two sub-reports chronologically. It doesn't work to create a group for each date, therefore I'm thinking I need to create a formula field in which to sort. what would the formula be?

    CrystalNewbie5 pointsBadges:
  • Crystal report when database is empty

    Can you write a crystal report when the tables are empty?

    Gsusnme15 pointsBadges:
  • Crystal report 9 formula issue

    I have a crystal report using two Lawson OLEDB queries, with employee.employee and supervisor.employee. Please let me know how can I write a formula which shows the employee which is listed in the report is a supervisor or not. The report does not shows the supervisor.employee field.

    BasicCrystalreports15 pointsBadges:
  • Crystal Reports 9 Formulas

    I am using Crystal 9 reports. The formula is an IF formula but one of the columns returns as a blank as there is no data, crystal doesn't read this as a value < 0 as it is blank, how can I get crystal to read a blank in the data field whilst writing a formula? the formula is below but it won't...

    Meagwatts15 pointsBadges:
  • Creating Crystal Reports delivery labels with different references

    Hi, We have a delivery label which is creating a reference number for each label. if isnull({BoxLabel.JobNo}) then "*WWPML0" + {BoxLabel.OrderNo} else "*WWPML0" + {BoxLabel.JobNo} + "*" This works fine. However we need to now amend this so that the reference number changes if there is more than one...

    Kwirky5 pointsBadges:
  • What does this Crystal Reports XI Formulas Error mean?

    To many arguments have been given to this function

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

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