Search results for query: *

satinsilhouette, Thanks for your input. I tried all the above in CR9 and STILL nothing. I even went so far as to create a formula called passed_parm that just has the input_parm_id in it as the only entry and removed the input_parm_id entry in the parm area. Still doesn't work!!! at wit's...

Thanks for the input. Unfortunately, that didn't work either. I'm at my wits end of how to make this work. I guess I could try and import the whole report into XI and see what I get. alex

satinsilhouette, I tried that early in the process. When I fire off the main report I still get under 'Enter Parameter Values' 2 parms to input. Parm # 1 for the main report and parm # 2 for the sub-report. What am I still doing wrong? alex

Ditto the remark about doing the Grouping on the server. Have you tried NOT doing the (2) in clauses against alpha characters? An In clause sometimes can slow down the process, since the statement: cf.comments in ('COUPON', 'INTEREST') is probably doing a full table space scan. Is there a...

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

Madawc Williams, One final question. How would I make it print/display without the decimal? ie...as 15 years & 230 days as oppossed to 15.00 years & 230.00 days. thanks again, alex

Madawc, You ROCK!!!!! That solved the problem completely. Thanks for alll. alex

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

Mufntuf: What is a Command object that ahs a subquery in the sql?? I'm not familar with that. alex

Gary, I thought of that already. The problem is that in the 2 reports, there is a possibility of numerous patients being on those reports. Each sub-sub-report showing associated insurance company’s needs to only reflect those insurance companies attached to that patient. Does that make sense...

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

Jason, Thansk for the info. But, the primary care doctor IS a 1, attending = 2, admitting = 3, etc. But, I kind of figured it out myself by the following route. In the section expert I created a formula called @test-refering-type, withthe following code: if {PAT_REF_CARE.REFERRING_TYPE}...

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

pgtek, OK,sounds kool!!! How do I create a Storedprocedure for the sub-query, Please? alex

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

But, isn't that when using Crystal Syntax versus Basic Syntax? I'm using Basic. alex

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

Along those lines: I’ve come across something that doesn’t seem to work for me….I’m trying to suppress some output using the following code: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ if ({PATIENT_LABS.DATE_OF_LAB} in dateadd("h",-24,currentdatetime) to currentdatetime)...

to pgtek, What I'd like to do is be able to, in the sub-reports, if there is no data for the given sub-report, do a line of text, in a box, that states...'No data available...' thanks, alex

pgtek, I understand (kinda) what you mean, but, how do you... 'conditionnaly supress if is null'?? I've only been doing Crystal progamming for 6 months ( but mainframe programming forever) help, alex