I want to look at a set of records and if any of the records meet my criteria, I want to return a "True" string ("EHR" in this case). I am running into 2 problems.

IF ISNULL ({PHY_ADVISOR_AH.CONTACT_ID}) THEN "" ELSE
    IF {PHY_ADVISOR_AH.ADVISOR} in ["EHR"] THEN "EHR" ELSE ""

 

So, my solution is to put this in a subreport which works fine...sort of.

 

The subreport is causing the overall report to run very slowly. Also, when it returns the value, it brings all values where the condition is met. I want it to only return one True (i.e. "EHR") if ANY of the records contain that string. I have already tried "=" instead of the "in" statements with no change in outcomes.

 

So, my two questions are:

1. How do I return only 1 True statement regardless of how many records contain the target string?

2. How do I move this out of a subreport and into the main report without limiting the overall record sets to just those records with a Physician Advisor record?

 

Thanks.

1.  Get rid of the subreport.

2.  Add the PH_ADVISOR_AH table back in to the main report. 

3.  Link FROM the other table in the report TO this table.

4.  Right-click on the link and select "Link Options...".

5.  Change the link to a "Left Outer Join".

 

The resulting query will give you all of the records in the original table, regardless of whether there is a matching table in the PHY_ADVISOR_AH table.

 

-Dell