All the previous examples have used the default Pagination settings; Type: Scroll and Show Total Row Count: No. These next few examples will explore the pagination options. For illustrative purposes these examples use a sequence number in the row header. They also include icon and detail views to show how they work with the same pagination settings.
This page uses Pagination Type: Page and Show Total Row Count: No. It also has a fixed size region with the headers fixed to the region. When type is Page it results in pagination controls in the footer of the Interactive Grid. Show Total Row Count really determines if the database counts the total number of rows in the query result set. When the total number of rows is not known then only the range of rows (For example 1 - 50) and Next and Previous buttons can be shown. The Auto setting for Actions menu Rows Per Page lets the grid choose the number of rows based on the height of the grid. The general idea is that the user should either be paging or scrolling but not both.
You may notice that as you click Next page sometimes the progress spinner is shown indicating that data is being fetched from the server and sometimes it isn't. An important difference between Interactive Report and Interactive Grid is that the latter has distinct data (model) and view layers. This is known as model view separation. The view shows just a portion of the rows in the model and the model is responsible for getting more data from the server when needed. This is critical for editable grids and for scroll paging but always in effect even for traditional paging.