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 Rhinorhino 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: *

  • Users: JMB7
  • Order by date
  1. JMB7

    Data Suppression for multiple rows

    Yes, the group headers are suppressed. I do not think this can be done or I am missing something. Thank you for all you help. JM
  2. JMB7

    Data Suppression for multiple rows

    My group fields are as follows: patient ID Account# Admit Date Dsch Date Length of stay The results of my formulas for the second instant (same patient) is any free text that the user typed in that is flagged by my formula. There is one line of data per formula per patient. Here is an example...
  3. JMB7

    Data Suppression for multiple rows

    Thanks for the suggestion- This is what I have done so far. 1 - I added the 'suppress if duplicate' to patientID and acct# fields 2 - I added 'suppress blank section' the format section of detail 3 - and added the MAX syntax to the detail section, X-2 I am working in the detail section. My...
  4. JMB7

    Data Suppression for multiple rows

    I result should be a string datatype. Thank you
  5. JMB7

    Data Suppression for multiple rows

    Crystal 8.5 SQL Database Hi, I have a report where I need to suppress data. In order to suppress lines that do not qualify for my formulas I placed a suppression in GF2 - which works. (I inserted summaries and used MAX to display my data in GF2).I also need to supress dupliate patient data (pt...
  6. JMB7

    convert date to month counter

    It works! Thank you both very much Madawc - thanks for the extra hints.
  7. JMB7

    convert date to month counter

    Crystal 8.5 SQL Database Good Morning, I am trying to calculate patient age by months. I have a patient date of birth field and am subtracting that date from a vst start date field to get current age. @Age=Month({vst.vst_start_date}) - Month({pt.birth_dtime}) When the report runs, I just get...
  8. JMB7

    While Printing Records Question

    Your are correct - I missed the group on actv_dtime. It works - thanks you so much for your help!
  9. JMB7

    While Printing Records Question

    Thank you so much for the help. I used your first formula (I renamed the formula) @Charge Validation if {actv_detail_v.actv_cd} in ["1671007", "1671008", "1671014", "1671016"] then 1 else if {actv_detail_v.actv_cd} in ["3610076", "3610079"] then 10000 else 0 ( I added the " " because I got an...
  10. JMB7

    While Printing Records Question

    Crystal 8.5 SQL Database I have to write a report where I need to group specific charge codes by date. For example: Svc CD Svc Date Service DTotal (trying to get this #) 3610079 4/1/2005 1 1671008 4/1/2005 3610079 4/2/2005 1 1671008 4/2/2005 3610079 4/3/2005 1 1671008 4/3/2005 3610079...
  11. JMB7

    Trim Formula

    Thank you again - it worked!
  12. JMB7

    Trim Formula

    I now have another problem. My formulas: //{@firstname} split({pract_mstr_orgz_v.pract_rpt_name},", ")[2] //{@lastname} split({pract_mstr_orgz_v.pract_rpt_name},", ")[1] //{@combinename} {@First Name}+' '+{@Last Name} I successully 'seperated' the names, placed first name first and last name...
  13. JMB7

    Trim Formula

    Again thank you very much.
  14. JMB7

    Trim Formula

    It worked - thank you very much for your help. Would like to gain more knowledge on formula syntax, any suggestions on reference books or web sites I can refer too? Again thank you for your help.
  15. JMB7

    Trim Formula

    Crystal 8.5 Hello all, I have written a report where my end user now wants fields not to be combined. I now need to trim out these fields. For example: physician name (pract_rpt_name) has last name, first name. I need to seperate these names. Also need address (addr_line1) which contains...
  16. JMB7

    Display time when not valued

    I am new to manual crosstabs. I looked for a sample and found thread149-548521 with which I believe to have a similiar issue. Using an Array was also mentioned. So I used... whilePrintingRecords; stringvar array nurseunit:=['2BR','3BR','4BR'}; stringvar array...
  17. JMB7

    Display time when not valued

    Crystal 8.5, SQL Database Hello, I wrote a cross tab report where I am trying to display the number of patient discharges by nurse station by hour. Nurse station is on left and time range across top. I have a formula that converts the actual time into the 'hour' of discharge. EX. if {@hour} =...
  18. JMB7

    Syntax Needed

    Thank you so much for your help. It worked beautifully!
  19. JMB7

    Syntax Needed

    I am trying your suggestion, just running into problems where some patients might have 4 SDS, then 1 SRC and 1GNC. I will let you know - thank you for your help.
  20. JMB7

    Syntax Needed

    The table has one record for each occurence, they are not combined.

Part and Inventory Search

Back
Top