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 [...]
Answer Question
| April 22, 2013 10:10 PM
Crystal Reports formulas, Crystal Reports XI
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 [...]
Answer Question
| April 22, 2013 10:10 PM
Crystal Reports formulas, Crystal Reports XI
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.
Answer Question
| March 18, 2013 2:16 PM
Crystal Reports, Crystal Reports formulas
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.
Answer Question
| March 18, 2013 2:16 PM
Crystal Reports, Crystal Reports formulas
Convert formula result string to number
My formula produces a string. I want to convert it to a number. Can’t use tonumber(@formula).
Answer Question
| February 15, 2013 7:38 PM
Crystal Reports 2008, Crystal Reports formulas
My formula produces a string. I want to convert it to a number. Can’t use tonumber(@formula).
Answer Question
| February 15, 2013 7:38 PM
Crystal Reports 2008, Crystal Reports formulas
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.
Answer Question
| February 6, 2013 12:03 PM
Crystal Reports, Crystal Reports formulas
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.
Answer Question
| February 6, 2013 12:03 PM
Crystal Reports, Crystal Reports formulas
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?
Answer Question
| October 2, 2012 11:15 PM
Crystal Reports 9, Crystal Reports formulas
I am working in Crystal Reports 9 and need to pull null values into a report. What formula do I use?
Answer Question
| October 2, 2012 11:15 PM
Crystal Reports 9, Crystal Reports formulas
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 [...]
Answer Question
| June 19, 2012 3:37 PM
Crystal Reports 10, Crystal Reports formulas
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 [...]
Answer Question
| June 19, 2012 3:37 PM
Crystal Reports 10, Crystal Reports formulas
Crystal report when database is empty
Can you write a crystal report when the tables are empty?
Answer Question
| February 28, 2011 3:28 PM
Crystal Reports, Crystal Reports Database, Crystal Reports formulas
Can you write a crystal report when the tables are empty?
Answer Question
| February 28, 2011 3:28 PM
Crystal Reports, Crystal Reports Database, Crystal Reports formulas
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.
Answer Question
| November 17, 2010 2:21 PM
Crystal formula, Crystal Reports, Crystal Reports 9, Crystal Reports formulas, OraOLEDB
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.
Answer Question
| November 17, 2010 2:21 PM
Crystal formula, Crystal Reports, Crystal Reports 9, Crystal Reports formulas, OraOLEDB
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 [...]
Answer Question
| October 6, 2010 2:32 AM
Crystal Reports, Crystal Reports 9, Crystal Reports Database, Crystal Reports 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 [...]
Answer Question
| October 6, 2010 2:32 AM
Crystal Reports, Crystal Reports 9, Crystal Reports Database, Crystal Reports formulas
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?
Answer Question
| October 11, 2011 11:16 AM
Crystal Report XI, Crystal Reports, Crystal Reports formulas, Crystal Reports Group Sorting, Crystal Reports Subreports, Crystal Reports XI Subreport
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?
Answer Question
| October 11, 2011 11:16 AM
Crystal Report XI, Crystal Reports, Crystal Reports formulas, Crystal Reports Group Sorting, Crystal Reports Subreports, Crystal Reports XI Subreport
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. [...]
Answer Question
| June 26, 2012 4:41 PM
Crystal Reports, Crystal Reports Field Explorer, Crystal Reports Formatting, Crystal Reports formulas
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. [...]
Answer Question
| June 26, 2012 4:41 PM
Crystal Reports, Crystal Reports Field Explorer, Crystal Reports Formatting, Crystal Reports formulas
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 box. the next box would have [...]
Answer Question
| August 20, 2010 1:50 AM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
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 [...]
Answer Question
| August 20, 2010 1:50 AM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
What does this Crystal Reports XI Formulas Error mean?
To many arguments have been given to this function
Answer Question
| August 13, 2010 5:08 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
To many arguments have been given to this function
Answer Question
| August 13, 2010 5:08 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
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?
Answer Question
| August 12, 2010 1:59 AM
Crystal Reports, Crystal Reports 8.5, Crystal Reports formulas, SQL Server, SQL Server 2005
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?
Answer Question
| August 12, 2010 1:59 AM
Crystal Reports, Crystal Reports 8.5, Crystal Reports formulas, SQL Server, SQL Server 2005
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 the results I [...]
Answer Question
| February 16, 2010 11:19 PM
Crystal Report, Crystal Reports 2008, Crystal Reports formulas
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 [...]
Answer Question
| February 16, 2010 11:19 PM
Crystal Report, Crystal Reports 2008, Crystal Reports formulas
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
Answer Question
| November 19, 2009 3:42 PM
Crystal Reports, Crystal Reports formulas
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
Answer Question
| November 19, 2009 3:42 PM
Crystal Reports, Crystal Reports formulas
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?
Answer Question
| November 13, 2009 4:58 PM
Crystal Reports formulas, 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?
Answer Question
| November 13, 2009 4:58 PM
Crystal Reports formulas, Crystal Reports X
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. What I [...]
Answer Question
| August 17, 2009 8:49 PM
Crystal Reports, Crystal Reports 10, Crystal Reports formulas
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 [...]
Answer Question
| August 17, 2009 8:49 PM
Crystal Reports, Crystal Reports 10, Crystal Reports formulas
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?
Answer Question
| July 30, 2009 12:21 PM
Crystal Reports, Crystal Reports formulas
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?
Answer Question
| July 30, 2009 12:21 PM
Crystal Reports, Crystal Reports formulas
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?
Answer Question
| August 20, 2009 4:42 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
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?
Answer Question
| August 20, 2009 4:42 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
