View Source

List is designed to integrate Datalist created using the Datalist Builder into the Report.

Marketplace Knowledge Base > List (Report Element) > list1.png

Figure 1 : List properties

Name	Description
List	Target Datalist to load. Mandatory field.
Header Background Color	Choose the color through the color picker.
Header Text Color	Choose the color through the color picker.

Marketplace Knowledge Base > List (Report Element) > list2.png

Figure 2 : Advanced properties

Name

Description

Datalist Filter Parameters

The Datalist Filter Parameters properties as below:

Sub-element

Description

Parameter Name

Datalist Filter Name's URL Request Parameter

Marketplace Knowledge Base > List (Report Element) > list3.png

Parameter Value

Datalist Filter set Value

Add Formula Column

The Formula Column properties as below:

Sub-element

Description

Label

Label of the new formula column

Formula

use javascript to perform row calculation in the Formula column Eg.{field1}+{field2}

Footer Row

Sum
Average
Count
Distinct Count
First
Highest
Lowest
Standard Deviation
Variance

Decimal Format

Format Decimal numbers

0.00 or 0.000 or .0

Header Alignment

Left
Center
Right

Alignment

Left
Center
Right

Width

10px or 10%

Footer Row

The Footer Row properties as below:

Sub-element

Description

Field ID

Datalist Column Name

Operator

Sum
Average
Count
Distinct Count
First
Highest
Lowest
Standard Deviation
Variance

DecimalFormat

Format Decimal numbers

0.00 or 0.000 or .0

Footer Row Label

Label of the Footer Row

100px