Search results for query: *

My problem is kind of like the problem displayed in thread766-836891. Using CR 9.2 ……………Oracle 9i I have a very complex SQL statement imbedded in a Command Object in a sub-report. It took me many hours to write this SQL, since it uses some very ‘hairy’ logic. Anyway, the parameter for this...

Hi All, I have two date fields to work with: Date of Transplant system date (Yes, this is a Hospital Transplant office) What can I do to calcuate a persons time since transplant in years and days only? i.e. the result will appear like: 21 y 264 d I followed the thread marked in archive...

Dear All, I too have the same problem with crystal (no sub-reports with a sub-report.) I'm using CR 11.0 attached to Oracle 9i and here's my problem. I wrote 2 reports that show the status of a patient awaiting authorization for an evaluation. Lots of data elements on each report...

I'm running Crystal 8.5, Oracle 8.1.7 and can't seem to get the Selection Formula for a Group working correctly. Here are the details: Working at a hospital, trying to produce a list of all patients in a programs (Kidney, liver, heart, etc), that have no Primary Care Physician attached to...

I'm running Crystal 8.5, Oracle 8.1.7 and can't quite get a sub-query to work in Crystal ( I guess I don't know what I'm doing wrong) Here's the SQL statement: select aa.PAT_ID,pd.LAST_NAME,pd.FIRST_NAME, pt.DATE_OF_TRANS, aa.ACTION_SCHEDULED_DATE from actions aa, patient_demo pd...

CR8.5 Pro Oracle 8.1.5 CR ODBC drivers (I think) Here’s my problem/misunderstanding. I’m creating a report to show a Physical Exam for the doc’s I work for. Part of one of the sections is for General Notes. (There’s a Notes area for every section of the exam, but I’ll just talk about this...