If you are looking for the Reportance Desktop help, please click here.

Reporting - Fields

Within report templates, information is populated from the Reportance file by using special fields. These fields let you build a generic report that you can use for all entities. They can be used to perform simple tasks, such as returning a report title or entity name. 

Fields can be used anywhere in Reportance that you can create or edit content (see the knowledge article: Report Content Editor). They can also be used in Titles and Footers. Below is an example of how fields have been used in a 'Paragraph' in the Compilation Report Template to return names and dates:

Note: Each field must be wrapped within two sets of curly braces as shown by: {{text}}

Note: To return subsets of properties, use the '.' syntax between each property. For example to return which state an office is in you would use: {{Office.Address.State}}

Note: All fields are case sensitive.

Reporting Fields

Below is a complete list of fields which can be used within a report to populate information:

Report Title{{Title}}String
DateTime*{{DateTime d MMMM yyyy}}String - Example Format of Date:
1 January 2020 (see below)

Office Id{{Office.Id}}GUID - Unique Office identifier
Office Name{{Office.Name}}String
Office Trading Name{{Office.TradingName}}String
Office ABN{{Office.ABN}}String
Office Address{{Office.Address.AddressLine1}}
{{Office.Address.State }}
{{Office.Address.Suburb }}
{{Office.Address.PostCode }}
Entity Name
Entity Trading Name{{Entity.TradingName}}String
Entity ABN{{Entity.ABN}}
Entity Type{{Entity.EntityType}}
Stringeg 'Company', 'Trust', 'Partnership', 'Sole Trader'
Entity Responsible{{Entity.Responsible}}
Stringeg 'Director', 'Directors', 'Trustee, 'Trustees'
Entity Extended Responsible{{Entity.ExtendedResponsible}}
Stringeg 'Directors of ABC Company Pty Ltd', 'Trustees of ABC Trust', 'Proprietor'
Entity Responsible Plural{{Entity.ResponsiblePlural}}
True/False - Booleaneg 'Shareholders', 'Beneficiaries', 'Members', 'Proprietor', 'Partners'
Entity Owner{{Entity.Owner}}
Principal Activities{{Entity.PrincipalActivites}}
INot For Profit{{Entity.NotForProfit}}True/False - Boolean

Is Company{{Entity.IsCompany}}
True/False - Boolean
Is Trust{{Entity.IsTrust}}
True/False - Boolean

Is Association{{Entity.IsAssociation}}
True/False - Boolean

Entity Registered Office{{Entity.RegisteredOffice.AddressLine1}}
Entity Principal Place of Business{{Entity.PrincipalPlaceOfBusiness.AddressLine1}}
Start Date*{{StartDate:d MMMM yyyy}}String - Example Format of Date:
1 January 2020 (see below)

End Date*{{EndDate:d MMMM yyyy}}String - Example Format of Date:
1 January 2020 (see below)

IsWholeYear{{IsWholeYear}}True/False - Boolean
Partner Id{{Partner.Id}}GUID - Unique User Identifier

Partner Email{{Partner.Email}}String
Partner First Name{{Partner.FirstName}}
Partner Last Name{{Partner.LastName}}
Partner Display Name{{Partner.DisplayName}}
String => First Name & Last Name
Page Title{{Page.Title}}String
User Id{{User.Id}}
GUID - Unique User Identifier

User Email{{User.Email}}String

User First Name{{User.FirstName}}String

User Last Name{{User.LastName}}String

*The following shows how date patterns can be used in the above fields to display in the format you require:

PatternResult String
dd MMMM yyyy30 June 2020
dddd, dd MMMM yyyyTuesday, 30 June 2020
MMMM ddJune 30

Reporting Tags

If Statement

Within a report an If Statement can be used to return different text. 

The following example takes a True/False variable and returns the text "Are" if True and "Is" if False: 

{{#if Entity.ResponsiblePlural}}are{{#else}}is{{/if}} 

The following example checks to see if a property exists and returns an ABN {{Entity.ABN}} if it does exist and blank if it does not exist: 

{{#if Entity.ABN}}ABN {{Entity.ABN}}{{/if}}


You can use 'uppercase' and 'lowercase' in a tag to convert the contents of a string to that case, for example:

{{#lowercase Entity.EntityType}}

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.