Search results for query: *

Dell, Thanks for the clarification. I started clicking around and I found it! You have to right click the folder that contains the 'missing' file. You will be presented with 5 options: - First Batch - Next Batch - Previous Batch - Last Batch - Find Clicking on 'Next Batch' brought up the...

Thanks Dell, but that's not the issue. I'm trying to open the .rpt file using Crystal Reports, not through CMC or InfoView. In Crystal Reports I do a File - Open, then select Enterprise from the 'Open' dialogue box. I'm presented with the folder structure on the Enterprise server. There are...

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.

Above issue fixed with Service Pack 4.

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...

Thank you maswien! I'm testing it now and will let you know how it turns out. Steve

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...

synapsevampire- Thank you for taking the time to answer my question. To answer your question: Why are you returning all of these columns and only displaying 4? I am using all of the colums, just didn't have enough room to post them all and should have explaind that. I just wanted to show what...

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"...

Thanks Turkbear and Synapsevampire for your suggestions. example data: 38123 38123.1 In this example, 38123.1 is the most recent data for this patient No, not a legacy system. There is a date field attached to each record in the table. This not a normalized database, and the records are...

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.)...

ncchish- Is there a contract end date field? If so, you could use the section expert and create a formula under "Supress (No Drill-Down)" to supress when currentdate > {contract_end_date}.

Turkbear- My problem is I don't know how to return all of the multiple values that are selected in the parameter. Yes, my data will be restricted to the selection critera, but I want to list my entire selection critera (even if there are no records for a particular item).

Thanks Uncle Bob! That should do the trick.

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...

That's a great idea, except some of the Doc's like to add additional data. For example "4/1987-3/1991-6/1993-10/1998" could one day have 6/2006 appended to the end of the field.....grumble, grumble, grumble.... I am able to convert 90-95% of the dates correctly. Fortunately I'm pulling a...