This feature enables the setting of a pagination for reporting within the Excel Extension. This will allow reported data to presented over many worksheets by setting a limit of records per page, instead of having all the data displayed just on the one sheet. This applies to grouped and non-grouped data.
The first thing to do is to set an appropriate page limit.
Assuming that a table has been added with the necessary records to be reported has already been established, press the Pagination button from the Excel Extension Ribbon.
A Table Pagination Options dialog will be displayed.
To enable pagination for the report, click on the paginate checkbox for the table records to be paginated.
Set Limit: Sets the limit of records per page.
Reset: Resets the pagination page limit (only when it has previously been enabled)
Click the Set Limit button this will display an information message box to confirm that setting the page limit is done via selecting a cell row, this will act as the limit of records per page.
Press Ok and select the row where the page limit is to be set. Upon selecting the row with the mouse cursor another information box will be displayed confirming the row number used as the page limit.
Press Ok to return to the main Table Pagination dialog. To reset the page limit row and start again, press the Reset button.
A warning message will be displayed informing that by pressing yes, the page limit will be reset.
Press Yes to confirm the reset, or No to cancel.
It is also possible to locate the page limit applied in a similar way to locating the first table column header cell for the selected table.
To do this select the Pagination drop down and select Locate Limit.
The entire cell row column will be highlighted to show where the page limit is set which is a useful reminder.
Generating the report now with no grouping or filtering of data will display all records over as many worksheets needed based on page limit set.
The below example illustrates this:
The worksheets are labelled as report with a number in brackets representing the page number.
This may not be the most efficient way of displaying paged data, so there is added functionality to add page number and group number counts to display on the report as a footer.