Search results for query: *

HI all: Ignore this question...it was a miscommunication with the new user over the phone. Insert Summary Distinct count is still there...in Crystal 9. So much for walking through something over the phone. Always fraught with hazard. --Timbe

Hi all: We use Crytal 8.5 developer and also Enterprise. I was just trying to help someone in our organization that bought Cyrstal 9, and Disticnt count appears to be gone from the selection list. Does anyone know if it has been moved (and where), or it it really is dropped as a choice. (I'm...

HI all: I have a report that uses an Excel Spreadsheet for the list of id numbers to look up. I link it (Excel DSN) to an Oracle table (DSN) in our warehouse, and it all works pretty well. Here's the problem: some of the datatypes being returned from Oracle are screwey. I convert some of the...

Dear Mchsieh: Try the "character separated format", rather than comma separated. Leave a , as the separator, but then delete " from the the delimiter box. --Timbe ******************************************* Here is what I did: 1. Click export button...

HI MCGIM1: At some point, Crystal Enterprise required you to purchase a module called "smart Reporting" to have the other export features. I do not know if this is still the case with 8.5.

We have Crystal for Developer 8.0 and on occasion a report will get silently kicked out of the database (Oracle 8) for a technical/ hardware reason. The only symptom in the report is something like: the alphabetical list only shows records to "M" but the report footer shows the...

Hi Slim2: Supposedly there was an earlier version (we're in 8.5) of Cyrstal that had a major bug- not saving your changes consistently. There is a patch for that put out by Crystal...look around in the knowledge base. Can't help you with how to recover once it happened...but the patch could...

IN Oracle 8.3 we dropped an index (in error) and some of the reports that run off the particular table (written in Crystal 8.5) appear to be missing records. When the index was restored, things seem to be fine in our data warehouse. Depending how the index is used, is it possible for Oracle to...

Hi all: Has anyone had a Crystal Report finish prematurely and give you the wrong numbers? I have a report that groups medical services alphabetically. It gained huge numbers of records (60,000) in three days. When I look at the paper report from the original run last Friday, it appears that...

Hi Pip0 IF you follow the instructions (prior response from one of the instructor types) about connection to the Foxpro dbf, then you may be able to use the table link. In the Database (Visual linking expert), set the link option to != (a selection called not equal to) and drag the link...

Hi all: We are using Crystal Reports to help with development, ie to look at things in our data warehouse that have been loaded. Today a new field was added to a big table we are already using in some reports. When I tried to add the field to the existing reports, I realized it is not visible...

We have several Oracle Tables that we are attempting to link and report on with Crystal 8.5 Developer. Unfortunately the key fields in some of the tables are different data types, one a string, the other a number. Is there any way to link them via a formula or by using the Crystal...

Hi: A long shot, but check the browser version number on the PC where you are trying to run the WEB based version. Good luck

I like your answer, but this is a humongous database with 50 or 60 entries for many individual patients. A self join might kill me, or the data warehouse group. Is there a way to use running totals in the Cross tab? I've changed the logic so that the last record shows if condition a or b were...

I've developed a report grouped on a distinct patient MRN. I go through all records (at the detail level) for each patient and report whether or not they have ever had a certain diagnosis and/or a certain procedure. This logic all works fine. The problem I'm having is creating a cross tab (2...

I have a similar question, I am grouping a series of diagnoses by medical record number (patient). I then have a formula that reports whether the person ever had asthma and another procedure. At the group level, each patient has a numeric for "has asthma" (at any time) and a separate...