Search results for query: *

Using Crystal Reports 2008 SP8 connecting to Business Objects CMC (version 3.?) From crystal reports I can connect and access the .rpt files published on the Enterprise server. My problem is that I cannot see/access all of the .rpt files in some folders. It's not a random .rpt file, the...

Using Crystal XI and MS SQL Server 2005 Here is the record selection criteria ( ( {SURGICAL_HX.COMMENTS} like "*mastec*" and {CLARITY_EAP.PROC_CODE} like "990500" and not({SURGICAL_HX.COMMENTS} like "*partial mastectomy*") ) or ( {CLARITY_EAP.PROC_CODE} like...

Crystal XI R1 Version 11.0.0.2812 (I believe that this is SP 3) MS SQL Server 2005, SP 2 When creating a report, or updating previous report, we are no longer able to insert and append field values from linked tables. In the recent past, we were able to append all values, or pick and choosed...

Using Crystal XI and a stock chart. Where is the menu/command to "draw out of scale values"? My chart currently makes a mark on the X axis when there is no value for the period. I want to supress out of scale values. I knew how to find this in Crystal 10, but am having a devil of a time in...

We are upgrading from Crystal 10 to Crystal XI (release 1). I've found four service packs for XI. Do we need to install each of the four service packs, or is service pack 4 cumulative? Thanks.

I am using Crystal XI, MS SQL Server 2005 and MS Acess 2000. I have data that I load monthly into a SQL Server 2005 database table. Before loading the monthly data I need to check for duplicates. To check for duplicates I created a Crystal Report that compares the primary key from the SQL...

I would like to create a command in Crystal 10 using SQL 2000. I am new to Crystal reports (< 1 year) and have very little experience with SQL code. Any and all help is appreciated. When a charge is entered it creates a new record with a unique TX_ID for the charge. This new charge is also...

Crystal 10 Microsoft SQL 2000 database Here is my SQL Query SELECT "PATIENT"."PAT_ID" as "PATIENT_PAT_ID", "AH_ASTHMA_PTS"."PAT_ID" as "AH_ASTHMA_PAT_ID", "PATIENT"."EPI_ID_TYPE_0", "PATIENT"."PAT_NAME", "PAT_ENC_CURR_MEDS"."LINE", "PAT_ENC_CURR_MEDS"."PAT_ENC_CSN_ID"...

Crystal Reports 10 MS SQL 2000 I have a field which is a numeric representation of a date PAT_ENC_DATE_REAL which is in the table PAT_ENC_CURR_MEDS. (The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.)...

Crystal 10 & SQL 2000 database I have a number field {MEDICATION_ID} and a string field {MEDICATION_NAME}. Both fields are in the same table RX_MED_TWO. I would like to use a parameter in my record selection using the medication number(s). I would then like to have the report return the list...

CR 10 and SQL 2000 We have a free text field to input a date that a surgical procedure was performed. No entry is permissible, as well as non-numeric text and symbols. I know that some of the values will never lend themselves to a conversion, but I would hope that a large percentage would...

Crystal Reports v 10 SQL 2000 I need to create a sub report with some comparative data that is not in any table in our database. We may create a custom table in the future, but that decision will be based on the "merits" of this report. I plan on using simple formulas for all of the related...