Thank you Riva, 

I fixed the same issue by fixing my Stored procedure script, i had to do some adjustment to my queries.

Again Thank you so much for helping me out.

Regards,
Azhar 

Thanks Riva, 
As i can see you are using Type – Local, and i am using Remote, i don't know wheter i would do any impact or not.

In my case, i have written a javascript function which hits a controller to get the filtered data from database.

In my javascript i have kept the default pageIndex as 0 which only return first page.

could it be the reason in my case remaining records are not added to new page and

also on filtered result page if i change page size in dropdown menu, it refreshes the page which updates the total record count to overall count , changing the filtered result count.
How can i stop it?

Thank you so much,

Actually my query is that suppose after filtering i have 12 employees of same name, but if i have selected page size as 10 i only get one page of 10 employees remaining 2 i don't have any information about, if i keep page size 20 and then i filter i can see all 12 employees on single page.

in my case second new page is not getting added.