does anyone know if you can bring data from a "related record" into a report? we have a report built on Sales Orders but need to pull in the date from a transaction on the "related records" tab of the SO

Yes use the applied to transaction join to do this. The applied to transaction is the ones in the related records subtab