You should be able to select both querys as the data source and use the link manager to link them by transaction number. Are you using the wizard to create the report?