Search results for query: *

I am trying to mimic state forms in Crystal and having problem line-up the text items to the original form. My text items are either a pixel or two (higher, lower, to the right, or to the left) than the text items on the original form. Is there a pixel control option available in Crystal? If...

I have documents in PDF format. I used Acrobat reader to view these documents. Where and how can I find what font size and style that were used for each section in the document? I am in the process of recreating these documents in Crystal report and have a difficult time to determine the font...

I trying to mimic states form Employer's First Report of Accidental Injury or Occupational Illness in Crystal. The requirement is to make it identical to the official form. I have fifty forms to create. Each state has its own design so the process is very tedious. Has anyone work on...

I'm using CR8.5 connect to a Visual FoxPro DB via Visual FoxPro Driver. The DSN is working fine up until yesterday. When I open Crystal Designer, then select the DSN that is pointed to the VFP db, I receive this error message: "ODBC error: [Microsoft] [ODBC Visual FoxPro Driver] Cannot...

Here is the problem: My record selection statement is as follow: Uppercase({Employer.Name}) like Uppercase({?Empl}) When I set {?Empl} parameter to accept multiple value, a record selection formula editor Window opens then display this message: This Array must be a Subscripted. For example...

Does anyone use or have information about a product called WebFocus? Any information is greatly appreciated.

I have Crystal Enterprise installed on the server. When I try to view any report, the Web Viewer(ActiveX viewer) flash(appear and then disappear really quick) then a File Download window appears and ask if I want to download the file or open the file from the location. I already checked the CE...

When my user try to map the report to his local database, he got an error message: Bad user specify key expression. He click ok than he got another error message: Error Detected by Database DLL. The database is Goldmine and Crystal report version 8. The report was created against an identical...

Hi, I’m working with a Goldmine database and Crystal Report version 8. There is a string field that the user enters the user name and the date the data is entered. Here is an example of the data in the table: JohnD 20010910 10:29am JannyDoe 20010830 8:55am UserNumber5 19970120 1:10pm...

Can you please help me answer this question: If I install a full Crystal Developer version 8.5 on the server machine will it functions the same as version 7. When my users access the report, will the server pushes all the neccessary DLLs and the viewer to the client's machine in order for them...

My report contains three tables: Claimant, Immunity and SurvTest. Each patient may have multiple immunity Surveillance shots (each shot represents a record). So in the SurvTest table, patient A might have the following record: Protocol Type Vaccine Actual_Date Next F/U Date Immune Vacc TB...

Hello All, Is it possible to use a parameter to include or exclude Null values from a report. For example, I have a date field called Termination. If an employee is terminated, then a termination date is entered in this field. Otherwise, the field is empty. I want to allow the user the...

I'm using CR8.5 and Oracle 8 backend Here are my select statements: If {?LastName} = * then If {?First} = * then If {ENCOUNTER_TYPE} = BV then {VISIT_DATE} in {?V_Start} to {?V_End} Else UpperCase(TrimRight({LASTNAME})) = UpperCase({?LastName}) and UpperCase(TrimRight({FIRSTNAME})) =...

We have a large number of crystal reports designed over a specific database. Now, we use the exactly same database structure for each of our customers. The database structures are exactly the same, only the data changes. Therefore we want to use the reports we have created as templates for all...

We are currently passing the UserName and Password in the URL. Is there a way to pass the DSN that contains the UserName and Password as a parameter to the report? Your help is greatly appreciated.

Hello, We have a large number of crystal reports designed over a specific database. Now, we use the exactly same database structure for each of our customers. The database tables are exactly the same, only the data changes. Therefore we want to use the reports we have created as templates for...

When I run my report without any record selection filter, the report returns 14 records. However, when I enter these statements in the Records Selection Formula Editor the report only returns 10 records. Here is my record selection statement: {Case.Type} = 'WC' and if {?Employer} =...

Hi, I’m creating an annual summary report. The summary is based on the case status and within a specific month. For example, in January I have 30 open cases, 25 pending cases, 5 closed cases, etc… My first approach is to create this formula: If {case_status} = ‘whatever status’ and...

Hello All, I would like to know if you have use or can share some information regarding to a product called Business Object. Is this a better report writing tool than Crystal? Any information you can provide is greatly appreciated. TIA

Hello All, I'm new to CR and need your help. I am using CR 8 reporting off Visual Fox Pro database. In the claim table I have a status column that contain various status (completed, pending, canceled, etc…). What I like to do is calculate the claim total base on the status and the claim date...