Usage and example

The paging panel web extension requires you to specify these parameters:

  • Actual Page: A cell reference. The cell contains a variable that holds the number of the current page. 1 represents the first page.
  • Page Size: A cell reference. The cell contains a variable that determines the number of records displayed on each full page.
  • Page Count: References the pagecount property of a hyperblock.
  • Page Size Options: A list of numbers, which represent the page sizes that can be selected. The numbers are separated by | or ;.

To insert and configure the paging panel web extension:

  1. Create an Application Studio report.
  2. Insert a hyperblock that displays multiple rows of data.
    For example, insert a hyperblock that displays all base elements of a period dimension.
  3. Create a report variable named rv_CurrentPage and specify 1 as its value.
  4. Create a report variable named rv_PageSize. As its value, specify the number of records to display on each page. Specify 10, for example.
  5. Drag rv_CurrentPage to cell H9, for example.
    The cell displays 1. The formula editor displays =ReportVariables.rv_CurrentPage.Text
  6. On cell H9, which contains the rv_CurrentPage variable, create an action with these characteristics:
    Actions: Type
    Select Set Parameters as the action type.
    Actions:Condition
    Select =TRUE.
    Actions: Mode
    Select Web Extension as the mode.
    Parameters: Name
    Click Add parameter and select the rv_CurrentPage variable.
    Parameters: Property
    Select Value(.Text).
    Parameters: Value
    Specify =Actions.Input.Text
  7. On cell H10, specify an action with these characteristics:
    Actions: Type
    Select Set parameters as the action type.
    Actions:Condition
    Select =TRUE.
    Actions: Mode
    Select Web Extension as the mode.
    Parameters: Name
    Click Add parameter and select the rv_PageSize variable.
    Parameters: Property
    Select Value(.Text).
    Parameters: Value
    Specify =Actions.Input.Text
    Parameters: Name
    Click Add parameter and select the rv_CurrentPage variable.
    Parameters: Property
    Select Value(.Text).
    Parameters: Value
    Specify =1
  8. In cell H10, specify this VALUE function =VALUE(ReportVariables.rv_PageSize.Text)
  9. Select the hyperblock and open its Format Hyperblock dialog box. Specify this information:
    Name
    Specify Period.
    Paging
    Select the check box and select the rv_PageSize variable in the Page size field.
    Select the rv_CurrentPage variable in the Current Page field.
  10. Click OK.
  11. Click Web Extension on the Objects toolbar and double-click the Paging Panel web extension.
    The cursor changes to a cross hair.
  12. Drag the cursor to insert, size, and position the web extension in cells B11:F11, for example.
    The Format Web Extension dialog is displayed.
  13. Specify these parameters:
    Actual Page
    Specify =H9.
    H9 holds the rv_CurrentPageSet variable.
    Page Count
    Specify =ReportObjects.Period.Pagecount
    Page Size
    Specify =H10
    H10 specifies the number of records displayed on each full page.
    Page Size Options
    Specify ="10;20;50"
    Specifies the page size options that users can select. Each value represents the number of records to display on each full page.
  14. Click OK and view the report in a web browser.