I couldn't find a solution to the report for filtering the data, so I removed "TableB" and created this as a view that only returns the most recent record. It fixes the issue for the present, but have a feeling in the future they will want a report listing all possible records from TableB, but will worry about that then 😀