I have a pre-built report from our vendor.  Any vendor modifications will cost.

It is a listing of member accounts.  The sub report shows if they have any loans with us.

I have filtered the main report to only show members with only 1 account.  The sub report still shows any loan data.  I want to suppress the main report if they have any loans.

My goal is to only show members with 1 account and no loans.

I am not sure where/how to proceed.

I've done a shared value, which gives me the subreport data on the main report (loan number).  I'm struggling on how to filter by this formula filed.  

The way I would go about this is to do a Group By member account, and then create a Formula to do a count of the number of loan instances per member grouping.

Although I'm not sure how this would work with a subreport since I usually do Formula calculations.

Formula 1 (Counter): if not(isnull({table.loan_instance})) then 1 else 0.

Then go into Section Expert > Details > Common tab > Suppress (do not check the box) > [x-2]:

if sum({@CounterFormula1}, {@member_rouping}) > 0 then TRUE else FALSE