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

    Data Point Flags for consecutive days with If Statements

    Hello, The end goal is to flag a patient record If measure value is consecutive for 2 days AND value increase >= 3 on 3rd day AND value is sustained for 2 subsequent days THEN FLAG Example: Measure Date Measure Value 20-AUG-13 5 21-AUG-13 5 [highlight #FCE94F]22-AUG-13 5 23-AUG-13...
  2. records333

    Interpret code that used a field that was a string and now the field is a number

    I inherited a report and I'm learning about variable. I would like assistance of interpreting and recommendations on how to refine: Extending code that uses a string fieldglobal stringvar a1cvalue := {table.LAST_VALUE}; if mid ({table.LAST_VALUE},4,1) = "-" then a1cvalue :=...
  3. records333

    Max Date and Correlating Value to be placed in ID Group

    Hi Charily, Placing a max formula in the group is working. However, the report is showing null values in each formula group; 3-6M, 9-15M, etc. How should the report be coded to remove the null values? I tried the following; Standalone Formula IF {lab.RESULT_DATE} in [DateAdd("m", 3...
  4. records333

    Max Date and Correlating Value to be placed in ID Group

    Hi Charliy, I tried that as well and it works if I have 1 field. But I created fields using formulas for;3-6M,9-15M and 21-24M. If I group then sort, it doesn't work across the field. What is the best way to upload an example. Copy and paste not working.
  5. records333

    Max Date and Correlating Value to be placed in ID Group

    Hi Pete, Your last recommendation was my first attempt and records during the specific time frame did return. Additionally, I added IF statements to group timeframes in columns; 3-6M, 9-15M, and 21-24. However, I am stumped on how to capture the last date and last value (2 different fields)...
  6. records333

    Max Date and Correlating Value to be placed in ID Group

    Thanks Pete, adding the code in the Group selection worked! ] In addition I would like to capture the following; {DATE.LAST_DATE}in [DateAdd("m", 9, {RESOURCE.LAST CLASS}) to DateAdd("m", 15, {RESOURCE.LAST CLASS})] {DATE.LAST_DATE}in [DateAdd("m", 21, {RESOURCE.LAST CLASS}) to DateAdd("m"...
  7. records333

    Max Date and Correlating Value to be placed in ID Group

    I developed a report that displays the correct date ranges and values with consideration of the code in the Selection Criteria. And I created fields using If statements to capture pre and post dates. I am stumped when I attempt to select only the max date and correlating value in ID group.
  8. records333

    Evaluation lab value 6M before a class and lab values 3-6M after class

    Selection Criteria: ( //PRE A1C {ORDER_RESULTS.RESULT_DATE} in [DateAdd("m", -6, {ICIC.1ST CLASS}) to {ICIC.1ST CLASS}] ) or ( //POST A1C {ORDER_RESULTS.RESULT_DATE} in [DateAdd("m", 3, {ICIC.LAST CLASS}) to DateAdd("m", 6, {ICIC.LAST CLASS})] ) What is the best way to proceed with creating...
  9. records333

    Evaluation lab value 6M before a class and lab values 3-6M after class

    Scenario: 1)capture lab values and dates 6M before class 2)lab values and dates 3-6M after class. My selection criteria is coded to capture date 6M before or after class. Additionally I would like to create columns pre a1c values and post alc values. (report is grouped by patient) I used a if...
  10. records333

    IF statements not evaluating

    I modified report to the following: IF ( ({Command_DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) AND {Command_ORDER.DESCRIPTION} like "XXX*" ) OR ({Command_CLASSES.DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) and...
  11. records333

    IF statements not evaluating

    During validation, I've notice that the formula is only evaluating the first statement not the OR STATEMENTS. Please see example: IF ( ({Command_DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) AND {Command_ORDER.DESCRIPTION} like "XXX*" ) OR...
  12. records333

    Help with counting formulas

    During validation, I've notice that the formula is only evaluating the first statement not the OR STATEMENTS. Please see example: IF ( ({Command_DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) AND {Command_ORDER.DESCRIPTION} like "XXX*" ) OR...
  13. records333

    Help with counting formulas

    Hi there, Group 1 - by Location Running Totals: Patients Newly Diagnosed CLASS RESOURCE VIDEO RESOURCE CC RESOURCE The last piece is TO create a formula to count patient if they had at least 1 of the resources to reflect patient was a program particpant
  14. records333

    Help with counting formulas

    I have three formulas that count if a patient attended resources A, B, and C. My goal is to count the patient once IF they attended at least 1 of the resources. I would like feedback on the best way to count the patient once.
  15. records333

    Records between Monday and Friday

    Sorry for delay in response. It worked! Thanks a mill!
  16. records333

    Records between Monday and Friday

    Goal: Identify patients that have upcoming appointments Monday through Friday from rundate (on Thursday). I used a dateadd formula {PAT_ENC.APPT_TIME} in dateadd('d',8,CurrentDate)to CurrentDate to capture appointments within the week of runtime. But user would like a list of appointments...
  17. records333

    Dateadd formula for crystal reports

    Hello All, I thought I nailed the code but records that I know should return aren't. My goal is to capture appointments scheduled 8 days from currentdate; {table.contact_date} in dateadd('d',8,CurrentDate)to currentdate
  18. records333

    I give...and need assistance with MINIMUM DATE AND CONDITIONS

    The objective is to capture patients diagnosed during a specific time frame and assigned to a specific location: Conditionsif ({CLARITY_LOC.LOC_ID} in [99999] and ({DIAGNOSIS.DATE} >=date (2012, 11, 30)) ) then {DIAGNOSIS.DATE} else if ({CLARITY_LOC.LOC_ID} in [88888] and...
  19. records333

    Display text if a certain parameter is met

    I have a smiliar goal: I have a group by location that captures patients' newly diagnosed date with 250.**. I would like to capture the minimum date for each patient as mulitiple dates are referenced due to multiple dx. Any tips.
  20. records333

    Capture 6M of data after 2M of start date?

    It worked, thanks a mill!

Part and Inventory Search

Back
Top