Can a report show opportunity revenue in both corporate and transaction currencies?

Yes, Business Intelligence (BI and OTBI) reports can display opportunity revenue totals in both the transaction currency and the corporate currency.

For details, see the document you can download from the support article User Preferred Currency Usages in Business Intelligence (BI) (1633382.1).