I am working on paging with data management (lcds), when i scroll the datagrid it gets the data (e.g., 40 RECORDS for each scroll on datagrid) and the paging works fine if i don't sort the columns on datagrid or don't apply filters on the column header of the datagrid. The issue is when i try to sort any of the columns on the datagrid or apply filters to the headers of the datagrid columns then the paging is done by itself and gets all the data all at a time.

Need help ASAP. Please suggest.