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 XI – Finding records that need to have appointments rescheduled
Hi, I have the following fields to work with: ID #, issue #, meeting #, prior meeting dates, and status. I keep isolating the old records that have already been rescheduled along with the ones that need to be rescheduled. Any ideas would be appreciated. Thanks! Babeas
Answer Question
| March 11, 2013 12:31 PM
Crystal Reports Record, Crystal Reports XI
Hi, I have the following fields to work with: ID #, issue #, meeting #, prior meeting dates, and status. I keep isolating the old records that have already been rescheduled along with the ones that need to be rescheduled. Any ideas would be appreciated. Thanks! Babeas
Answer Question
| March 11, 2013 12:31 PM
Crystal Reports Record, Crystal Reports XI
Crystal Reports- displaying calculations for date range prior to date search parameter
I’m working on a formula to calculate the number of criminal offenses that occurred in the same amount of days as my date search parameter but prior to the start date. The date search parameter is always changing. The idea is to compare the number of offenses from the last time period. I want to [...]
Answer Question
| June 6, 2012 2:57 PM
Crystal Reports XI
I’m working on a formula to calculate the number of criminal offenses that occurred in the same amount of days as my date search parameter but prior to the start date. The date search parameter is always changing. The idea is to compare the number of offenses from the last time period. I want to [...]
Answer Question
| June 6, 2012 2:57 PM
Crystal Reports XI
Crystal Report 2008
We recently moved our report portal from Crystal Xi to Crystal 2008. Now the embedded images on the reports only display a text of “Image”. When I send the report to the printer the Image will then display. Does anyone have any idea how to get the image to display on the screen?
Answer Question
| April 12, 2012 4:35 PM
Crystal Reports 2008, Crystal Reports XI
We recently moved our report portal from Crystal Xi to Crystal 2008. Now the embedded images on the reports only display a text of “Image”. When I send the report to the printer the Image will then display. Does anyone have any idea how to get the image to display on the screen?
Answer Question
| April 12, 2012 4:35 PM
Crystal Reports 2008, Crystal Reports XI
Crystal Reports Paradox Tables – data problems
I am creating a report in Crystal XI using multiple paradox tables. If I use an idapi connection I lose data when I access the second table. If I switch to a DAO connection it runs very slow locally and will not event connect at all if I try to access the data from a [...]
Answer Question
| March 31, 2012 2:54 AM
Crystal Reports, Crystal Reports Database, Crystal Reports XI, Paradox
I am creating a report in Crystal XI using multiple paradox tables. If I use an idapi connection I lose data when I access the second table. If I switch to a DAO connection it runs very slow locally and will not event connect at all if I try to access the data from a [...]
Answer Question
| March 31, 2012 2:54 AM
Crystal Reports, Crystal Reports Database, Crystal Reports XI, Paradox
Exception Join in Crystal Reports
How do I create an expection join in Crystal Reports 11. That is, I want ONLY the rows in FILEA that do not have a row in FILEB when joining them on FIELDX
Answer Question
| March 31, 2012 1:47 PM
Crystal Reports, Crystal Reports 11, Crystal Reports XI, DB2 on AS400
How do I create an expection join in Crystal Reports 11. That is, I want ONLY the rows in FILEA that do not have a row in FILEB when joining them on FIELDX
Answer Question
| March 31, 2012 1:47 PM
Crystal Reports, Crystal Reports 11, Crystal Reports XI, DB2 on AS400
Crystal Reports 2008 Version 12 Viewer, whats the class name field and what to put there?
In Crystal Reports 2008 version 12. Im using the viewer to try and pull up the reports I created and designed to view outside of SAP Business 1, but im not sure what to put in the “class name” field. Can anyone help to what I should put there and the function of this field?
Answer Question
| June 23, 2011 7:01 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Crystal Reports Projects, Crystal Reports Viewer, Crystal Reports XI, SAP Business One, SAP Reports
In Crystal Reports 2008 version 12. Im using the viewer to try and pull up the reports I created and designed to view outside of SAP Business 1, but im not sure what to put in the “class name” field. Can anyone help to what I should put there and the function of this field?
Answer Question
| June 23, 2011 7:01 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Crystal Reports Projects, Crystal Reports Viewer, Crystal Reports XI, SAP Business One, SAP Reports
Crystal Reports XI period in database name
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
Sort Crystal Reports detail data once to process then again to display
I have a report in which I have to sort the details in a specific way in order to calculate summaries but for display purposes I want to sort in a different order. Is this possible in Crystal XI
Answer Question
| December 6, 2010 2:59 PM
Crystal Reports, Crystal Reports Conditional Formatting, Crystal Reports XI
I have a report in which I have to sort the details in a specific way in order to calculate summaries but for display purposes I want to sort in a different order. Is this possible in Crystal XI
Answer Question
| December 6, 2010 2:59 PM
Crystal Reports, Crystal Reports Conditional Formatting, Crystal Reports XI
Crystal Reports XI – Duplicate input parameters
I am creating a Report with the input parameter for all the sales representatives across multiple states. On the report input parameter the values listed are as follows: N/A User1 – CA User2 – CA User3 – CA N/A User1 – CO User2 – CO User3 – CO and so on. I am hard coding [...]
Answer Question
| September 28, 2010 4:02 AM
Crystal Reports, Crystal Reports Conditional Parameters, Crystal Reports XI, duplicate parameters, input parameters, Parameters
I am creating a Report with the input parameter for all the sales representatives across multiple states. On the report input parameter the values listed are as follows: N/A User1 – CA User2 – CA User3 – CA N/A User1 – CO User2 – CO User3 – CO and so on. I am hard coding [...]
Answer Question
| September 28, 2010 4:02 AM
Crystal Reports, Crystal Reports Conditional Parameters, Crystal Reports XI, duplicate parameters, input parameters, Parameters
Crystal Reports View
I have a crystal report that shows appointments. I would like to be able to view only the AM schedule sometimes or only the PM schedule sometimes. How would I do this?
Answer Question
| September 16, 2010 7:16 PM
Crystal Reports, Crystal Reports Viewer, Crystal Reports XI
I have a crystal report that shows appointments. I would like to be able to view only the AM schedule sometimes or only the PM schedule sometimes. How would I do this?
Answer Question
| September 16, 2010 7:16 PM
Crystal Reports, Crystal Reports Viewer, Crystal Reports XI
Crystal Reports XI – SQL table fields that fail all compare tests
I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as… if {mytable.mystring} = “test value” then 1 else 2 This is what happens during execution… when the the preceding test is true, Crystal returns a value of 1 [...]
Answer Question
| August 26, 2010 3:15 PM
Crystal Reports XI, Crystal XI, SQL, SQL Server, SQL tables, Windows Server
I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as… if {mytable.mystring} = “test value” then 1 else 2 This is what happens during execution… when the the preceding test is true, Crystal returns a value of 1 [...]
Answer Question
| August 26, 2010 3:15 PM
Crystal Reports XI, Crystal XI, SQL, SQL Server, SQL tables, Windows Server
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 are the most common errors that occur when creating report on crystal report xi by using oracle (SQL) query?
what r the most common errors occurs when creating report on crystal report xi by using oracle (SQl) query.also plz suggest the solutions for thoes errors.
Answer Question
| August 17, 2010 3:56 AM
Crystal Reports Errors, Crystal Reports XI, Oracle 10g, SQL Query, Troubleshooting
what r the most common errors occurs when creating report on crystal report xi by using oracle (SQl) query.also plz suggest the solutions for thoes errors.
Answer Question
| August 17, 2010 3:56 AM
Crystal Reports Errors, Crystal Reports XI, Oracle 10g, SQL Query, Troubleshooting
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 X1 report do not print subtotals on multiple pages
In a purchase order form done in Crystal X1 the report has sub totals on each page when the order has many lines and goes over multiple pages only want the sub totals to appear on the last page not each page. How do I do this?
Answer Question
| July 13, 2010 12:50 AM
Crystal Reports printing, Crystal Reports Subreports, Crystal Reports XI
In a purchase order form done in Crystal X1 the report has sub totals on each page when the order has many lines and goes over multiple pages only want the sub totals to appear on the last page not each page. How do I do this?
Answer Question
| July 13, 2010 12:50 AM
Crystal Reports printing, Crystal Reports Subreports, Crystal Reports XI
Clearing a variable from a sub report Crystal reports
I am using a sub report to update a report using a different file. I am using shared variables. If there is no hit in the second file, the sub report does not print, but my shared variables do not clear and appear as the one before instead of zero. I keep reading that I [...]
Answer Question
| June 11, 2010 7:01 PM
Crystal Reports Subreport, Crystal Reports XI, Crystal Reports XI Subreport
I am using a sub report to update a report using a different file. I am using shared variables. If there is no hit in the second file, the sub report does not print, but my shared variables do not clear and appear as the one before instead of zero. I keep reading that I [...]
Answer Question
| June 11, 2010 7:01 PM
Crystal Reports Subreport, Crystal Reports XI, Crystal Reports XI Subreport
How to create a parameter based on previous parameter.
How to create a parameter based on previous parameter. Good Day, I am fairly new to CR and I was wondering if there was any way to accomplish the following? I am looking to create a parameter based on a previous parameter. I am using CR v.XI. Simple Example: Parameter #1: Run Report BY: (a) [...]
Answer Question
| May 25, 2010 1:10 PM
Crystal Reports User Settings, Crystal Reports XI, Parameters
How to create a parameter based on previous parameter. Good Day, I am fairly new to CR and I was wondering if there was any way to accomplish the following? I am looking to create a parameter based on a previous parameter. I am using CR v.XI. Simple Example: Parameter #1: Run Report BY: (a) [...]
Answer Question
| May 25, 2010 1:10 PM
Crystal Reports User Settings, Crystal Reports XI, Parameters
String results are printing on multiple pages in Crystal Reports XI
I am a new, non-programmer user of Crystal Reports XI. I set up a custom invoice in Crystal Reports which works well when there is only one line item on the invoice. However if I have a multi-line item invoice, each line item description (string) prints on a separate page. Does anyone know how I can manipulate this string [...]
Answer Question
| August 18, 2010 5:11 PM
Crystal Reports XI
I am a new, non-programmer user of Crystal Reports XI. I set up a custom invoice in Crystal Reports which works well when there is only one line item on the invoice. However if I have a multi-line item invoice, each line item description (string) prints on a separate page. Does anyone know how I can manipulate this string [...]
Answer Question
| August 18, 2010 5:11 PM
Crystal Reports XI
New user of Crystal Reports XI
I am new to Crystal Reports and its killing me. I set up my report and it was working fine, reporting all data fields as they existed in the database. I made one change to my report format, I added one data field below an existing one. Now all it will show is the first [...]
Answer Question
| April 1, 2010 10:27 PM
Crystal Reports XI
I am new to Crystal Reports and its killing me. I set up my report and it was working fine, reporting all data fields as they existed in the database. I made one change to my report format, I added one data field below an existing one. Now all it will show is the first [...]
Answer Question
| April 1, 2010 10:27 PM
Crystal Reports XI
