Report template: custom fixed data

The Custom Fixed Data column type allows you to build your own content. You can mix:

  • Fixed text — content that displays the same in every row.
  • Lookup fields — dynamic content pulled from employee, employer, role, or pay run fields.

When a report is run, the same content structure is applied to each employee in the report output.

Fixed text only

If you just want to return the same text in every row, type it directly:

"Hello"

Output example (for every employee):

Hello

Combine fixed text with a single field

You can add lookup fields to your fixed text. Wrap fields in curly braces {}.

"Hello" +{employee.firstname}

If the employee’s first name is Sarah, the following is displayed:

Hello Sarah

Combine multiple fields

You can use more than one lookup field, separated with spaces or punctuation.

"Employee: "+{employee.firstname}+" "+{employee.lastname}

If the employee is Sarah Smith, the following is displayed:

Employee: Sarah Smith

Add separators or punctuation

You can also add commas, brackets, or any other characters to your custom text.

"Name: "+{employee.firstname}+" "+{employee.lastname}+" (Dept: "+{employee.department}+ ")"

If the employee is Sarah Smith in the Finance department, the following is displayed:

Name: Sarah Smith (Dept: Finance)

Good to know

  • Fixed text must be wrapped in quotation marks ("").
  • Fields must be wrapped in curly braces {}.
  • You can combine as much text and as many fields as you need.
  • The same pattern repeats for every employee row in the report.

Other useful topics: 

For all available dynamic fields that can be used in Custom Fixed Data columns that you create, go to Report template: fields.