Report Builder Examples

// === Namespaces ===
Datasources.<name>.<field>     // array of field values (aggregate target)
Datasources.<name>             // the raw array of row objects (pass to Sum/Count/Avg/Min/Max)
Parameters.<name>              // parameter value; property path supported (Parameters.dateRange.fromDate)
Field.<name>                   // field of the current row (in table cell / row-visible context)
Field('a.b.c')                 // safe nested-field access (rejects __proto__ / constructor / prototype)
RowGroup('name').key           // key of current row-group frame
RowGroup('name').keys          // array of keys when using multi-key grouping
RowGroup('name').values        // array of row objects in the group
RowGroup('name').Fields.<f>    // field of the group's first row
RowGroup('name').Variables.<v> // group-scoped variable value
ColGroup('name').…             // same shape for column groups
Variables.<name>               // row-group-local variables (shortcut)

// === Aggregates ===
Sum(Datasources.orders.revenue)              // numeric array form
Sum(Datasources.orders, 'revenue')           // (rows, fieldName) form — preferred when you have raw rows
Count(Datasources.orders)                    // row count
Count(Datasources.orders, 'status')          // non-null count for a field
Avg(rows, 'unitPrice')
Min(rows, 'orderDate')
Max(rows, 'revenue')

// === Conditionals ===
IIf(cond, trueValue, falseValue)             // two-way
Switch(value, case1, result1, case2, result2, defaultResult)
!expr / expr && expr / expr || expr
expr == expr / != / < / > / <= / >=

// === Text ===
Concat(a, b, c, …)
Upper / Lower / Trim / Len / Length
Mid(str, 1, 3)                               // 1-based start
Replace(s, find, replaceWith)
StartsWith / EndsWith / Contains
PadLeft(v, 5, '0')  /  PadRight(v, 10, ' ')

// === Numeric / formatting ===
Round(v, decimals)  Floor(v)  Ceil(v)  Abs(v)
FormatNumber(12345.6, 2, ',')                // "12,345.60"
FormatCurrency(12345, '$', 0)                // "$12,345"
FormatPercent(0.128, 1)                      // "12.8%"

// === Dates ===
Today() / Now()
Year(d) / Month(d) / Day(d) / WeekDay(d)
DateAdd('day' | 'month' | 'year' | 'hour', amount, date)
DateDiff('day' | 'hour', date1, date2)
FormatDate(d, 'YYYY-MM-DD')

// === Null / empty handling ===
IsNull(v) / IsEmpty(v) / Coalesce(a, b, c, …)
IfNull(v, fallback)
InList(value, [a, b, c])                     // true if value is in the list
Between(value, min, max)                     // inclusive
Any(arr) / All(arr)