Skip to Content
Former Member
Aug 05, 2008 at 11:05 PM

formula problem


I am using Crystal XI and an Oracle database. I have a treatment plan report that shows whenever staff electronically sign it, including the date and their title, etc. We collect information in the database (start and end dates for staff assigned to a patient) to show dates they were assigned to a patient for care. Right now the report shows every staff person who ever signed it. I need to narrow it down to show only current staff assigned to that patient and/or be able to input a date with a parameter and show staff who were assigned as of that date. I have tried many variations of formulas to display the correct signatures, but haven't been successfull. However, I did build a subreport that is successfully telling me current staff assigned.