Using Crystal Reports 8.5 and Oracle Tables.....
One of the tables that becomes populated as tests are completed (ARRESULTS) contains fields that relate the tests to a "CASE" (CASE KEY), the test type, the test and the test result (in character form). If there were five test results entered for a particular "CASE" there would be five records in ARRESULTS with the same CASE KEY field and the five different tests information, including the result entered.
I am trying to figure out how to write a Crystal Report that tells me how many cases have a certain combination of test run.
For example, TEST1, TEST2 and TEST3 are possible test entries. If run and entered into the system, they will have a character numeric entry indicating how many of the samples were either tested or found to be positive. I want a report that will look at any CASE where TEST1 was run (numeric value of 1 or more) tell me the total of those CASES that were negative for both TEST2 and TEST3, the total where TEST2 was positive and TEST3 was negative and finally where TEST2 was negative and TEST3 was positive. Remember, if the test was negative (or not performed), there would be no record in ARRESULTS for that case and that test.
Any suggestions??
One of the tables that becomes populated as tests are completed (ARRESULTS) contains fields that relate the tests to a "CASE" (CASE KEY), the test type, the test and the test result (in character form). If there were five test results entered for a particular "CASE" there would be five records in ARRESULTS with the same CASE KEY field and the five different tests information, including the result entered.
I am trying to figure out how to write a Crystal Report that tells me how many cases have a certain combination of test run.
For example, TEST1, TEST2 and TEST3 are possible test entries. If run and entered into the system, they will have a character numeric entry indicating how many of the samples were either tested or found to be positive. I want a report that will look at any CASE where TEST1 was run (numeric value of 1 or more) tell me the total of those CASES that were negative for both TEST2 and TEST3, the total where TEST2 was positive and TEST3 was negative and finally where TEST2 was negative and TEST3 was positive. Remember, if the test was negative (or not performed), there would be no record in ARRESULTS for that case and that test.
Any suggestions??