List

Introduction

The List Report Element integrates a list created using the List Builder into the report, allowing you to display list data directly in the report.

Get started

How to use it

To use the List Report Element:

1. In your report designer, find the List element in the palette.
2. Drag and drop it onto the report canvas where you need the space.

Configure list properties

Once the List element is added, you can configure its properties.

Fields to Configure:

• Selector Class: Define the class for the current element.
• List: Choose the target list to load. This is a mandatory field.
• Header Background: Set the color for the list header's background. Choose the color through the color picker.
• Header Text Color: Set the color for the list header's text. Choose the color through the color picker.

Advanced

Fields to Configure:

• Datalist Filter Parameters: Set parameters for filtering records.
  • Parameter Name: Expect a URL request parameter of a datalist filter.
    
  • Parameter Value: Value to set to the datalist filter to filter records.
• Formula Column: Add a custom formula column using JavaScript.
  • Label: Label of the new formula column.
  • Formula: Use JavaScript to perform row calculation from any field here.
    
    Example:
    {field1} + {field2}
  • Footer Row: Configure footer row operations.
    • Sum
    • Average
    • Count
    • Distinct Count
    • First
    • Highest
    • Lowest
    • Standard Deviation
    • Variance
  • Decimal Format: Format decimal numbers of the current numeric value.
    
    Example
    

    • 0.00
    • 0.000
    • .0
  • Header Alignment:
    • Left
    • Center
    • Right
  • Alignment: 
    • Left
    • Center
    • Right
  • Width: Column width.
    
    Example
    10px or 10% 
• Footer Row: 
  • Label: Label within the current cell to indicate the purpose of this value.
  • Field ID: List Column Name.
    Example
    
  • Operator: 
    • Sum
    • Average
    • Count
    • Distinct Count
    • First
    • Highest
    • Lowest
    • Standard Deviation
    • Variance
  • Decimal Format: Format decimal numbers of the current numeric value.
    
    Example
    

    • 0.00
    • 0.000
    • .0
• Footer Row Label: Label of the footer row. Available only when used with Footer Row property.