Finally got it working by "thinning" the code.  Thanks for replying though!

The original code was this:
SELECT DISTINCT
  v_R_System.Name0
FROM
  v_R_System
  JOIN v_FullCollectionMembership FCM
   ON FCM.ResourceID = v_R_System.ResourceID
WHERE
  v_R_System.Name0 NOT IN
 ...

Ok, finally got it working.  Thank you for all your help and guidance.

I whittled the query down to the essentials.  A couple of days ago, I had it working, but the report always displayed the exact the same data regardless of the...

ok, Thank you for responding!

What else do you require?  screenshots?  the Parameter settings?  My apologies, I'm a SQL coding newbie