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 ...
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...