Using the format editor, it is easy to click on suppress if duplicated. However in this report, I only want to see duplicated values. A dialy query runs giving me all the data I need from the previous days lab results from a hospital. In this particular case, I'm searching for this:
{Query.Result} in ["ABNL", "AUTOA", "NORMAL", "NSA"] and
{Query.TestCode} in ["DIFIS", "MRCM"]
I get a separate record for each Test Code. So all I simply want to do is get those instances where a patient has both these tests with any of the chosen results. I get hundreds of instances of one or the other test code appearing on the report (each patient gets a unique accession number):
AccNumber Test Code Result
M12345 DIFIS AUTOA
M64789 DIFIS NORMAL
M33333 DIFIS AUTOA
M33333 MRCM NORMAL
I would only want to capture the M33333 patient.
Thnaks for any help.
{Query.Result} in ["ABNL", "AUTOA", "NORMAL", "NSA"] and
{Query.TestCode} in ["DIFIS", "MRCM"]
I get a separate record for each Test Code. So all I simply want to do is get those instances where a patient has both these tests with any of the chosen results. I get hundreds of instances of one or the other test code appearing on the report (each patient gets a unique accession number):
AccNumber Test Code Result
M12345 DIFIS AUTOA
M64789 DIFIS NORMAL
M33333 DIFIS AUTOA
M33333 MRCM NORMAL
I would only want to capture the M33333 patient.
Thnaks for any help.