Crystal Reports XI Questions


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
asked by:
5 pts.

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
asked by:
40 pts.

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
asked by:
15 pts.

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
asked by:
5 pts.

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
asked by:
5 pts.

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
asked by:
35 pts.

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
asked by:
145 pts.

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
asked by:
35 pts.

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
asked by:
5 pts.

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
asked by:
5 pts.

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
asked by:
25 pts.

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
asked by:
35 pts.

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
asked by:
5 pts.

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
asked by:
50 pts.

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
asked by:
50 pts.

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
asked by:
10 pts.

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
asked by:
5 pts.

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
asked by:
5 pts.

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
asked by:
5 pts.

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
asked by:
5 pts.