After setting the max records in Report definition to 20 , I configured sorting in repeating grid. At this time , even though it is showing 20 records, but after I sort it is sorting all the records and showing only 20 records.
For example I have 500 records, .pxCreateDate date range of : 2014 to 2018. After setting the max records to 20 in report definition. It is showing 20 records of 2018 . but when I sort it is showing 20 records of 2014 - which is not expected.
I have referred SA -1886 and applied display top 20 of overall records condition - at that time - sorting is not working on grid.