Isolating records for a report
Current Syntax: IsNull ({DISPOSITION.DISPOSITION}) AND {HEARING.OFFICERID}=987 AND {HEARING.HEARING_DATE}<CurrentDate I am trying to isolate appeals that need to be rescheduled. They can be rescheduled multiple times, and I end up with a lot of appeals in my results that have already been rescheduled. Any ideas would be greatly appreciated. This will allow us to go paperless [...]

Answer Question   |  March 4, 2013  4:26 PM
Crystal Reports 11, Crystal Reports Record

Include only most recent entry in report
What selection criteria would limit the display to only the most recent entry per account?

Answer Question   |  October 15, 2012  5:44 PM
Crystal Reports 11, Selection Criteria

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

Error Message when trying to change Parameters – Crystal Reports 11
Failed to Retrieve data from the database. Details: ADO Error Code: 0x80040e14 Source: Microsoft OLE DB Provider for Oracle Description: ORA-06550: Line 1, Column 7: PLS-00201: identifier ‘WHSP_USER.SP_RPT_DAILY_LANE_EXCEPTION’ must be declared ORA-06550: Line 1, Column 7: PL/SQL: Statement ignored Native Error: 6550 [Database Vendor Code: 6550]

Answer Question   |  January 25, 2011  1:43 PM
Crystal Reports 11, Crystal Reports error messages, Crystal Reports Errors, Parameters

How to manual configure tomcat with crystal reports 11
How to manual configure tomcat with crystal reports 11

Answer Question   |  August 19, 2010  9:51 PM
Crystal Report XI, Crystal Reports, Crystal Reports 11, Tomcat

Crystal Reports 11 problem with excel spreadsheet
I AM USING AN EXCEL SPREADSHEET AS MY DATABASE. ON THE SPREADSHEET I HAVE A COLUMN THAT HAS NUMERIC AND ALPHA VALUES. WHEN A ADD THIS TO THE CRYSTAL REPORT ONLY THE NUMERIC VALUES DISPLAY AND THE FIELD CANOT BE FORMATTED AS ANYTHING OTHER THEN A NUMBER FIELD. ON THE EXCEL SPREADSHEET THE COLUMN IS [...]

Answer Question   |  July 9, 2010  4:14 PM
Crystal Reports 11, Excel 2000, Excel Compatibility, Excel Database, Excel Formatting

Crystal reports and Oracle
I need to have a user design and run reports without having them being a local admin on the machine. I have tried various options, but the user cannot connect.  We are using SYSTEM DSN ODBC  Does a reports user have to be a local admin???

Answer Question   |  December 15, 2009  11:19 PM
Crystal Reports, Crystal Reports 11, Oracle, Oracle 10g, Windows XP

Last 2 weeks Trends via Crystal Reports
I’m trying to pull data, from MySql Database through ODBC, for last two weeks & then trend them together

Answer Question   |  October 19, 2009  4:53 AM
Crystal Reports, Crystal Reports 11, Crystal Reports 11.5

Differences between Crystal 11 and 2008
What are the differences between Crystal Rpts 11 and 2008. If upgrading to 2008 are there other patches to upgrade or will all existing reports upgrade to 2008 without problems?

Answer Question   |  October 14, 2009  6:23 PM
Crystal Reports, Crystal Reports 11, Crystal Reports 2008

Date Conversion In Crystal Reports 11
I have a datafield {artrans.invdte} thats is a string lenght of 8 formated “MM/DD/YY” trying to check this date against ToText(currentdate, “MM/DD/YY”) to select records not working . Tried a pramater field @date StringVar DT := {artrans.invdte}; NumberVar YR := Val (Split (DT , ‘/’)[3]); if YR < 50 then YR := YR + 2000 [...]

Answer Question   |  June 10, 2009  7:29 PM
Crystal Reports, Crystal Reports 11, Crystal Reports Data Conversion, Crystal Reports XI

crystal report 11 and subtotal
If you have 1 file and in that file you have multiple records by date. so if this was the file year 2008 $100.00 Year 2009 $150.00 and you want a subtotal or difference in year 2008 and year 2009, can this be done without defining the file twice?

Answer Question   |  June 9, 2009  6:18 PM
Crystal Reports 11, Crystal Reports XI

How to set fixed number of records in details section in Crystal Reports XI
how to set fixed number of records in details section in crystal report XI

Answer Question   |  January 5, 2010  6:34 AM
Crystal Reports, Crystal Reports 11, Crystal Reports XI

Font problems when exporting the crystal reports into pdf
I usedArial Fonts in Crystal Report.When i export the report into PDF format, some of the Characters in the report contents are displayed like chinese. Please help.

Answer Question   |  June 11, 2009  6:00 PM
Crystal Reports, Crystal Reports 11, Crystal Reports to PDF, Crystal Reports XI

Domino and crystal report 11
How can I get the domino connection to show up in crystal report 11? yes lotus is installed.

Answer Question   |  May 12, 2009  7:37 PM
Crystal Reports 11, Crystal Reports XI, Domino 6.5

Crystal Reports 11 to create Body Mass Index chart (BMI)
need to create Body Mass Index chart (BMI) for different ages for school children. I also need to have the short details of the BMI info at the left top area. I need to do this for a web site in ASP/VBScript 3.0. I am using Crystal Reports 11 and not sure whether I can [...]

Answer Question   |  April 29, 2009  12:15 PM
ASP.NET, Crystal Reports, Crystal Reports 11, Crystal Reports XI, VBScript

Conditional X and Y position of a Crystal Reports field
In CR XI it is possible to adjust the x position conditionally. But is it also possible to adjust the y position conditionally? For my report i need to adjust the position of a field based on it’s value. There are some 30 possible positions for this field. So i need to conditionally adjust the [...]

Answer Question   |  April 21, 2009  9:39 AM
Crystal Reports 11, Crystal Reports XI

CRViewer Logon Failed error within Visual Basic 6
I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few [...]

Answer Question   |  March 27, 2009  11:40 AM
CRViewer, Crystal Reports 11, Crystal Reports XI, Database connectivity, SQL, SQL Server 2000, SQL Server connectivity, VB 6, Visual Basic, Visual Basic 6

Changing Default Settings for Crystal 11
When you click the Refresh report option, can you change the default to “Prompt for new parameter values” rather than “User current parameter values”?

Answer Question   |  February 6, 2009  2:31 PM
Crystal Reports, Crystal Reports 11, Refresh Report parameters

Duplicate Record formula in Crystal 11
I have a formula written as such: If onfirstrecord then {CHART_IMPORT_ERROR.ERROR_MESSAGE} else If {CHART_IMPORT_ERROR.ERROR_MESSAGE} = previous({CHART_IMPORT_ERROR.ERROR_MESSAGE}) then “”"” else {CHART_IMPORT_ERROR.ERROR_MESSAGE} Currently ” is showing up if the record above is a duplicate. However, I would like it to display nothing instead of “. I’d prefer it to actually count the number of duplicates but I [...]

Answer Question   |  January 6, 2009  5:00 PM
Crystal Reports 11, Crystal Reports Duplicate Records

Linking in Crystal Reports 8.5 and 11 question.
I currently have a report written in Crystal Reports 8.5 and I need to left join some tables. When I change the tables to left outer join I get these error messages stating: General SQL Server: Check Message from SQL Server and Error Detected by Database DLL. When I revert them back, the report works. [...]

Answer Question   |  November 24, 2008  9:11 PM
Crystal Reports 11, Crystal Reports 8, Crystal Reports 8.5, Crystal Reports Errors