How would you handle a practical scenario involving Database per Service in Microservices Architecture?

A reporting feature needs data from orders and payments; explain alternatives to direct cross-database joins.