Skip to content
  • There are no suggestions because the search field is empty.

How to Repeat WBS Groupings on Every Page of a Report

DESTINI Cloud reports include built-in support for repeating the Level One Group in the page header on every page. With a few simple modifications, you can extend this functionality to other WBS groupings. This article explains how to configure the Level Two Group to repeat on every page and display [Continued] when the group spans multiple pages, as shown in the following example.
Repeating WBS property groups in the report header

Configure Level Two Group to Repeat

    1. Open an estimate in DESTINI Cloud Estimator.
    2. Navigate to Home > New Report. Report Designer opens.
    3. Click File > Open.
    4. Navigate to the folder with the report template file (.repx) you want to modify.
    5. Click the .repx file to open it.
    6. Using the Report Explorer on the right side of your screen, type GroupHeader13 into the Search field. Click GroupHeader13 in the results.
      Search for and select GroupHeader13 in Report Explorer
    7. Inside the Designer in the middle of your screen, scroll down and locate the selected band from the previous step.
      Select GroupHeader13 in Designer
    8. With the band selected, click the Gear button to the right. The Group Header Tasks dialog box displays.
      Click the gear icon for GroupHeader13
    9. Inside the Group Header Tasks dialog box, select Repeat Every Page.
      Select Repeat Every Page
    10. Within the same group band, locate and select the [WBSProperty2] cell and then click the Function button. The Expression Editor opens.
      Select the WBSProperty2 cell
    11. In the left pane, select Text and then paste the following expression into the editor.
      [WBSProperty2] + Iif(GroupIndex(0) + GroupIndex(1) + GroupIndex(2) = 0, '', ' [Continued]')

      Paste the expression into the editor
    12. Click Ok.
    13. Save and run your report.
    14. In the report viewer, in the Parameters pane on the left side of your screen, locate the WBS Groupings section.
    15. For Level One Group, choose a group from the list and select Yes for Repeat Every Page. Then choose a group for Level Two Group.
      Choose groupings for the report
    16. Click Submit.
    17. Scroll down in the report to locate repeating grouping levels similar to the following. If the report doesn't include enough line items, you might not see the repeated group headings.
      The WBS Level One and Level Two Groups display at the top of each page

    (Optional) To configure additional group header bands to repeat, work through the previous procedure again and specify the values in the following table to update the WBSProperty3 and WBSProperty4 group header bands.

    Grouping

    GroupHeader Band

    Table Cell Expression

    WBSProperty3

    GroupHeader12

    [WBSProperty3] + Iif(GroupIndex(0) + GroupIndex(1) = 0, '', ' [Continued]')

    WBSProperty4

    GroupHeader11

    [WBSProperty4] + Iif(GroupIndex(0) = 0, '', ' [Continued]')

    (Optional) Parameter Clean Up

    After you initially ran the report in the last procedure, you selected Yes for Repeat Every Page for the Level One Group.

    Choose groupings for the report 

    If you hadn't selected Yes for the Level One Group, the report would display as follows:
    Only the Level Group Two grouping is displayed

    The Level Two Group is now configured to always repeat on each page. For consistency, you can configure your reports so you don't have to select Yes for Repeat Every Page for the Level One Group. Like the Level Two Group, the Level One Group header will always repeat.

    1. At the bottom of Report Explorer on the right side of your screen, click the Field List tab.
    2. Scroll down, expand Parameters, and select WBSProperty1_Repeat.
      Select the WBSProperty1_Repeat parameter
    3. Inside the Properties panel on the bottom right of your screen, clear the Visible checkbox and click the Function button to the right. The Expression Editor opens.
      Clear the Visible checkbox and click the Function button
    4. Delete the expression in the Expression Editor and click OK.
      Delete the expression
    5. In the Properties panel, for Value, choose Yes.
      Choose Yes for the Value
    6. Save and run the report.

    Related Articles

    How to Append [Continued] to the WBS Property 1 Value Across Multiple Pages