Search results for query: *

After a compact/repair has been preformed on Access 2000 database residing on a XP machine, all clients lose connection. We get displayed ""The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.&quot...

Does anyone know what the maximum number of detail sections are for CR 8.5? I have used over 50 before and did not have any problems. I am now writing a report that requires more than 50 detail sections. PS I am using an ODBC connection to an Access DB. Thank-You in advance for any...

We are running a Win 2000 server SQL 2000. I have just installed SP3 and I am getting the following error and warning: Event Type: Error Event Source: MSSQLServer Event Category: (8) Event ID: 19011 Date: 1/30/2003 Time: 11:14:17 AM User: N/A Computer: Description: SuperSocket info...

I am using Crystal 8.5 with an Access 2000 database. We have medical software that calculates BMI values and saves them into an Access Database. This field is stored as a String value ( that is updated with each patient). I need to take that string value, place into a variable and covert that...

I am using CR 8.5 with the Database and Export patch that was released in December of 2001. I have one field that is defined as Text with 241-character max (using a Microsoft Access 2000 database). However, I cannot browse this field in the formula editor. It seems like this field is being...

I am trying to write some reports off from an Access 2000 database with Crystal 8.5. One of the fields is a text with 250 character max limit. However, it seems like Crystal is viewing this field as a memo and not allowing me to do anything with it. It is not available using the formula...

I am trying to upgrade my reports from 7.0 to 8.5. When I try to open my reports that I saved in 8.5, I get the two error messages below: C:\reports\cp513.rpt????????????????????? End of File Reached I am connecting to Dbase and I have downloaded the patch to see all of my data. What are...

I have recently upgraded my version of crystal reports to 8.5. However, with the upgrade I could not longer see my data (dbase). So, I have downloaded the patch dated 12/13/01. The patch has the normal wording of "WARNING: do not deploy this patch in production environment without...

I am trying to "convert" my reports from version 7.0 to version 8.5. However I am not able to see all data in the database (I was able to see all of it using version 7.0). So, I wrote a basic report to display these fields that have all string data types. Out of 1091 records, I can...

I have recently upgraded from version 7 to version 8 of Crystal Reports. However, I have something going on that I have not seen before with any install. When I start Crystal, I have no problems opening any reports that I have written in any other versions. But, when I want to create a...

Is there any "easy" way to convert GMT time out of a database to a date that will be used for linking and parameters?? I currently do this through a formula, however the reports are starting to be used overseas where I am having to do some last minute adjusting to the formula. This...

I have the following formula on a subreport that I am passing the count back to the main report (or at least trying to do): WhilePrintingRecords; global numberVar x := 0; numbervar y := 0; if (Count ({Cpfind.INTID},{Cpfind.INTID}) > 1) then (y = y + 1); STORENUMBervar("x", y); The...

I have 2 dates that are being written into 2 memo fields. I need to verify if the current date is within those two dates in the memo fields. I know I can't use memo fields in any formulas. Does anybody have any idea for a work around on this?? Basically I need to do a date comparison in memo...

I have the following formula in a report of mine: Right (Trim ({Cpftxt.FTXT}), Length (Trim ({Cpftxt.FTXT})) - 39) The cpftxt.ftxt field is a string field that can hold 60 Characters. When I do an error check in the Formula Editor, I have no errors. However when I preview the report I get...

IF anyone could help me try to trouble my formula below, I would greatly appreciate it: If trim({cpfind.RECNO}) = "2" then "Pregant Woman" else if trim({cpfind.RECNO}) = "3" then "Breastfeeding Woman" else if trim({cpfind.RECNO}) =...