Hi,

The only information I can find on "Server Pagination" is:

Data Tables: Server Pagination
By default and for performances reason, tables are displayed using server pagination, this means that the cell values of a page are sent to the browser when the user click on a page number. (Refer to Data Tables Server Side processing for more information).
For a report, the server pagination can be enabled or disabled using the root view parameter Options: Server Pagination Enabled.

Obviously we can implement some restrictions, however we were hoping to avoid this.

To prevent timeouts, we would like to implement TSQL paging (Fetch/Offset) on our queries. It is unclear from the documentation but I suspect that "Server Pagination" in the above context must refer to the seal reports server, rather than SQL, as we are not seeing paging queries hit the database.

Can someone please offer some advice on how best to implement such paging.