Conditional visibility of report elements

You can use expressions to conditionally control how certain elements of your report are displayed.

Report components you can make conditional

  • Dimension (row or column)

    1. Edit a report section.
    2. Select the Data tab.
    3. Select or add a dimension.
    4. In the Selected dimensions section, in the Show as column, select Row conditional or Column conditional.
    5. In the pop-up edit window, enter the expression for the conditional.

    See Data tab for related help.

  • Calculated column

    1. Edit a report section.
    2. Select the Result display tab.
    3. Click Add new calculated column.
    4. In the pop-up edit window, describe the column (name, etc.) and enter the expression for the column.

    See Adding calculated results to your reports for related help.

  • Drilldown link

    1. Edit a report section.
    2. Select the Drilldown links tab.
    3. In the Select clickable element list, select the report element that will be clickable, and then click Add new link.
    4. Define the Target (report that will open upon drilldown) and Name (selectable label in the menu).
    5. Set Visible to Conditional.
    6. In the pop-up edit window, enter the condition under which this drilldown will be available.

    See Drilldown links tab for related help.

  • Section list and buttons

    1. Edit a report section.
    2. Select the Section list and buttons tab.
    3. Describe the menu entry or button you want to add.
    4. Set Visible to Conditional.
    5. In the pop-up edit window, enter the condition under which this menu or button will be visible in this section.
      See Section list tab for related help.
  • Report tab
    You can conditionally display tabs, disable tabs, and select tabs.

    1. Edit a report.
    2. Select the Report tabs and links tab.
    3. Under List of tabs, click Add tab.
    4. Describe the tab you want to add.
      • Set Visible to Conditional if you want this tab to be displayed only when a certain expression is true.
      • Set Selected to Conditional if you want this tab to be selected (when the report is opened) when a certain expression is true.
      • Set Disabled to Conditional if you want this tab to be disabled when a certain expression is true.

    Each of these selections opens a pop-up edit window in which you need to enter an expression to define the relevant conditions.
    See Report tabs and links tab for related help.

  • Breadcrumbs
    You can conditionally display breadcrumbs.

    1. Edit a report.
    2. Select the Breadcrumbs tab.
    3. Add or edit a breadcrumb.
    4. Set Visible to Conditional if you want this breadcrumb to be displayed only when a certain expression is true.

    See Editing breadcrumbs on a report for related help.

Rules for writing expressions

A logical expression is used to determine whether and how the associated report element is displayed. In general:

  • If the expression evaluates to TRUE, the element is displayed on the report
  • If the expression evaluates to FALSE, the element is not displayed on the report

Expressions must follow these rules.

  • Expressions are case sensitive.
  • Use the original dimension and metric names.
    You can not use aliases in expressions.
  • Enclose dimension and metric names in angle brackets.
    Example: <Tier>
  • Dimension and metric names can be preceded by a section name.
    Example: <Section 1|Tier>
  • Report columns can be compared to each other with a numerical value (you can use either a period or comma as the decimal point) or with a string enclosed with quotation marks or apostrophes. Use the following operators for comparison:
    • <
    • >
    • <=
    • >=
    • ==
    • !=
  • The ==~ operator must be used to define a regular expression.
    Example: <Analyzer> ==~ '(.*)?HTTP(\\s*?[|].*)?'
  • Numerical values and strings must be preceded by a space and followed by a space, a round bracket ), or a newline.
  • A column can be one of the values listed within square brackets, preceded by an in operator.
  • Sections comparing columns can be divided by the following operators: && or ||
  • Brackets can be nested.
  • An exclamation mark (!) negates the expression.
  • You cannot use aliases in expressions.

Example expressions

  • True if the Tier column equals Website.
    <Tier> == 'Website'
  • True if the Analyzer column contains the string HTTP.
    <Section 1|Analyzer> ==~ '.*HTTP.*'
  • True if the Tier column in the Data Center Tiers section equals Website.
    <Data Center Tiers|Tier> == 'Website'
  • True if both conditions are met: is greater than 10 and is greater than 0.
    <Client RTT> > 10 && <HTTP errors> > 0
  • True if either or both of these conditions are met:
    • it is false that ( is greater than 10 and is greater than 0)
    • it is true that the Tier column in the Transactions section equals Website.
      !(<Client RTT> > 10 && <HTTP errors> > 0) || <Transactions|Tier> == 'Website'
      Note that the exclamation mark before the first expression is a negation.
  • This complex example shows the usage of values listed in a table (['Website', 'Oracle Forms']) and nested brackets:
    (<Performance> == 100 || (<Section 1|Tier> in ['Website', 'Oracle Forms'] && <Section 3|Application> != '*')) && (<Client RTT> > 10 && <HTTP errors> > 0)