Right way to create a report that consist 100k records

I answered a similar question: