Using Crystal Reports 8.5 and Oracle 9i tables:
In our system a CASE can have several section assignments. They can be assignments to different sections and/or multiple assignments to the same section. Each assignment starts with an assignment date and eventually gathers a date completed. I need to measure the CASE Assignment turn-around-time for a particular section, no matter how many assignments were created for that case in the same section.
So, if a CASE has multiple assignments to the same section, I need to find and store the first assignment date as the Start Date and then need to find the last (latest) completed assignment date for that section as the End Date and subtract the two (these would be in different records in the case of multiple sections assignments).
So, the way my tables are set up, for a particular CASE (Case Key), I would need to parse the REPORT (completed assignment) table for any assignments for a particular section with that Case Key, find and store the earliest Assignment Date found, find and store the latest Completed Date found and do a date subtract.
How do I get Crystal to store the two date extremes while parsing all the appropriate records in my REPORT table?
In our system a CASE can have several section assignments. They can be assignments to different sections and/or multiple assignments to the same section. Each assignment starts with an assignment date and eventually gathers a date completed. I need to measure the CASE Assignment turn-around-time for a particular section, no matter how many assignments were created for that case in the same section.
So, if a CASE has multiple assignments to the same section, I need to find and store the first assignment date as the Start Date and then need to find the last (latest) completed assignment date for that section as the End Date and subtract the two (these would be in different records in the case of multiple sections assignments).
So, the way my tables are set up, for a particular CASE (Case Key), I would need to parse the REPORT (completed assignment) table for any assignments for a particular section with that Case Key, find and store the earliest Assignment Date found, find and store the latest Completed Date found and do a date subtract.
How do I get Crystal to store the two date extremes while parsing all the appropriate records in my REPORT table?