Hi,
The best way to achieve this is to create a new entity with the required fields and instead of using the default export to excel use this Excel export module. Few configurations and a microflow to get the fields from two databases then create objects for the entity you have created for the XLS report.
Also, this documentation will give you a better understanding of this.
Hope this helps!
Hi Juan Wang,
You can create a flat table entity containing all necessary fileds you want. Do you retrieval based on id from another table and pussh all the data to the newly created no persistabel entity and show that as a grid.