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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date Range Selection Formula
You're the best. Thank you. Worked as expected after I remembered to create the summary at the patient group level.- aeljhmi
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Date Range Selection Formula
LB, Thank you. This works great displaying patients seen the prior month one year ago that have not had any scheduled appointments since then. The one caveat is that the business owner would like to see patients that were seen in this timeframe and do not have a scheduled appt for just the...- aeljhmi
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Date Range Selection Formula
I am having trouble putting together a date range using a table that contains information pertaining to patient appointments (past and scheduled in the future). I am trying to come up with a way to limit my results to show appointments that occurred more than twelve months ago and less than 13...- aeljhmi
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Show patients not seen by current pcp
What if you link your tables as follows: left outer join from PATIENT.PAT_ID to PAT_ENC.PAT_ID left outer join from PATIENT.CUR_PCP_PROV_ID to CLARITY_SER_vstpcp.PROV_ID left outer join from PAT_ENC.VISIT_PROV_ID to CLARITY_SER.PROV_ID Group your report by PATIENT.PAT_ID - you can then add...- aeljhmi
- Post #9
- Forum: Business Objects: Crystal Reports 1 Formulas
