2 case table to show in single report

Kri
Tera Guru

I have two custom tables one table contains cases related to the UK users and another table will be a remote table(the values will be received from the other instance) which is related to the Europe users cases. I don't have any common field in the remote table but I want to create a report which should show the cases related to the UK users and the Europe users in a single list. How can I achieve this?

1 REPLY 1

jcmings
Mega Sage

You'll need to create a database view if you want to report on both tables at once. See documentation here.