Instead of creating 1 table on the report, create 2 tables. 1st table will have 65000 rows and other table will have rest of the rows. Put logic on rowId...
I agree with the posts that says "should not be generalized". In my case i have few sales tables with millions of records. We load data early morning and have...