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 [...]
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.
My formula produces a string. I want to convert it to a number. Can’t use tonumber(@formula).
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.
I am working in Crystal Reports 9 and need to pull null values into a report. What formula do I use?
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 [...]
Can you write a crystal report when the tables are empty?
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.
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 [...]
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?
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. [...]
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 box. the next box would have [...]
To many arguments have been given to this function
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?
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 the results I [...]
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
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?
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. What I [...]
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?
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?





