I am trying to write a Crystal Report(s) that will help to know when all of the lab results are back from a set of orders and/or when something is missing. The purpose is (a) to use as a catalyst or indicator that a "Results" letter should be created; (b) to determine how/why labs have not come back.
So, I can read through the ORDERS file and see status for S (signed) and C (complete). But I am having difficulty in mapping to the labs through the RESULTSDIDLIST field. Although, as I write this, maybe that doesn't matter and all I really need to know is if all are "C" yet.
So, to summarize, I want to be able to read through the ORDERS file and create a list of patients that now have all ORDERS marked "C" so that a letter can be generated. (My logic will note if a letter has already been done.)
Am I thinking this through correctly, over-complicating it, or 'just plain crazy"?
Thanks.
After looking further into the report, it looks like many other things also needs to be considered. It seems a bit more complicated as Joe has mentioned. So I deleted my previous post.
BAJ