One grid report with filtering options.

Does the grid update correctly if you click the search button after paging? It appears that your search results are only re-evaluated when the button is pushed, meaning that Appian does not know to query the database after you switch pages.

Are you familiar with the with() function? You can use that to re-populate local!searchResults every time the user moves to a new page. This SAIL recipe uses with() to re-evaluate a set of data after a user interacts with the form:
forum.appian.com/.../SAIL_Recipes.html

To preserve your current behavior of requiring that the filters be selected, you could use an if statement alongside the with. I've attached some code of what I have in mind.

With Example 8.28.txt

Does the grid update correctly if you click the search button after paging? It appears that your search results are only re-evaluated when the button is pushed, meaning that Appian does not know to query the database after you switch pages.

Are you familiar with the with() function? You can use that to re-populate local!searchResults every time the user moves to a new page. This SAIL recipe uses with() to re-evaluate a set of data after a user interacts with the form:
forum.appian.com/.../SAIL_Recipes.html

To preserve your current behavior of requiring that the filters be selected, you could use an if statement alongside the with. I've attached some code of what I have in mind.

With Example 8.28.txt