I have a report. It joins two tables. The output will only require 1 field from the second table which is a companyid. The SQL is:

select distinct xreq_RequisitionID, xreq_UserId, xreq_Name, item_vendor
from vRequisition
join vItems on xreq_RequisitionID = item_requisition
where xreq_Status in ('closed', 'awarded')

vrequisiton and vitems are just select * from the respective entities but filtering out deleted records. When I put this into a report, it is fine. If I use thisin a dashbord, the item_vendor field isn't available. Any ideas?