i am getting only 1000 rows in csv and excel when i am applying group by query in my collection and also get wrong number of records in grid pager. $ collections->getSelect()->group(‘main_table.name’); if i am comment this line all works fine. let me know if you need more info.Read more