190101 - no subject - How to efficiently display data from mul

How to efficiently display data from multiple tables in a report?

I have to create a report that will be retrieving all rows from 4-5 different tables. The client wants to have the ability to extract that report into excel.

Is it best to create a view on the database that would consolidate all tables and then create a data type/data store to get that information to display in my grid?

I want to limit the number of queries to the database. If I fetch the data from each tables in SAIL and store it to a local variable, and then query against those local variable.

Which options would be less effort? And what would be the best practice in this scenario?

OriginalPostID-190101