• 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:
  • Formula question

    Hi I have a question about a short formula: IF {ado.UOM}="LB" THEN crNoColor ELSE IF {ado.UOM}="KG" THEN "{ado.Pieces}x{ado.Size1}" When I check this formula,there is an error. it always shows that there is some number required. Thank you for help

    shanhuang10 pointsBadges:
  • How do I put a bottom border on null fields?

    In Format Formula Editor : Bottom_Line_Style, how do I put a bottom border on when the field is null.

    donnjuann5 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 CSV with quotes inside string

    I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: "Andy", 4685, "requires 5" by 2" silver plate", 1132 According to CSV standard it should be: "Andy", 4685, "requires 5"" by 2"" silver...

    Moltar5 pointsBadges:
  • Crystal crosstab formulas

    When I create a crosstab report using general ledger debits and credits, I can't get the formula to subtract the credits from the debits. Can you tell me what formula I can use to fix this issue?

    JC0710 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:
  • Filtering Dates in Crystal Reports

    Is there a way to get Crystal to filter dates showing the next 5 or 7 days?  I know about filtering using "in the period" but none of those options are for future dates, except like next 30 or 60 days, but I don't want to see all of that.

    Mturney5 pointsBadges:
  • Crystal report when database is empty

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

    Gsusnme15 pointsBadges:
  • Crystal Reports 2008 filter an array

    How can I return records in a data set that have a specific variable, but not another? Ex: Return records when field A includes X but not Y?

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

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