you could try adding the column "amount (foreign currency)" or something like that to get the currency from the transaction to show in the report.