Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alexfromuno

    Can't Link a Sub-report that uses a command object

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

    Can't Link a Sub-report that uses a command object

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

    Can't Link a Sub-report that uses a command object

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

    Crystal 11 Command Object and Query Running Slow

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

    Can't Link a Sub-report that uses a command object

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

    Calculate Age in years and days only!!

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

    Calculate Age in years and days only!!

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

    Calculate Age in years and days only!!

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

    Sub-Reports Issue II

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

    Sub-Reports Issue II

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

    Sub-Reports Issue II

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

    Complete Group suppression when data within group matches

    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}...
  13. alexfromuno

    Complete Group suppression when data within group matches

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

    Sub-Query Help needed

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

    Sub-Query Help needed

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

    Nulls in Formula don't seem to work - - -Help!!!

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

    Nulls in Formula don't seem to work - - -Help!!!

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

    Can and use multiple formulas when trying to suppress data in section?

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

    Blank data in Report...

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

    Blank data in Report...

    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

Part and Inventory Search

Back
Top