I have many cases where I want to know if a row has a value in another table, of a series of values. I am finding it easier to use a subreport to read these tables. I would like to pass back not the value but a flag to indicate that.
Is there a way to do that?
So that I pass patient_Id, the subreport reads that against several tables to see if we have that patient with one of several diagnosis codes. I either want all the codes found or just a flag to tell me that yes this patient has one of the codes.