How to Show/Hide Details in Banded Reports

How to Optionally Include Detail Pages in a Report

This article explains how to add a parameter to a banded report template that allows detail pages to be optionally included when the report is run.

Open the Report Designer

1. In DESTINI Cloud, open an Estimate (any estimate; it does not matter which).

2. Navigate to the Home View.

3. In the main Ribbon, click New Report…

   1. The Report Designer will be launched.

Open the Report Template File

1. In the Report Designer, click the Open button.

2. Navigate to the location of the report template file (.repx) that you want to modify.

Open the Field List

1. On the right side of the screen, locate the Report Explorer.

2. Using the tabs, switch to Field List.

Add a Report Parameter

1. At the bottom of the Field List, right-click Parameters.

2. Select Add Parameter…

Configure the Parameter

In the Add New Parameter window, configure the following values:

1. Name:  IncludeDetailPages

2. Description: Include Detail Pages

3. Type: Boolean

4. Default value: Yes

5. Click OK.

Open the Report Explorer

1. On the right side of the screen, locate the Field List.

2. Using the tabs, switch to Report Explorer.

Select the Detail Page

1. In the Report Explorer, search for and select Details_ScopeOfWork.

Update the Visibility Property

1. On the right side of the screen, locate the Properties panel.

2. Open the Expression Editor for the Visibility property:

   1. In the Properties panel, click the Gears (Behavior) tab.

   2. Locate the Visible property.

   3. On the right side of the Visible field, click the Function button.

Modify the Visibility Expression

1. In the Expression Editor window, append the following to the existing formula:

   1. AND ?IncludeDetailPages

2. Click OK.

Suggest an Improvement to this Article