> is there a best practice to query multiple records for a report?
Definitely make a view as harrisont606 already mentioned. In most use cases you should be able to create a view to join your different tables and then query it easily in a tempo report…