This article shows you how to create an Excel report from a Tabular data source. Each column is one value, which makes the output easy to save as CSV or load into other tools.
Applies to: System administrators (
adminrole) ยท Module: Set up > Reports
Opening Reports #
- Click the Set up spanner at the bottom left of the screen.

- Under System, click Reports.

- Click the + at the top right to start a new report.

Report Details #
- In Resource, choose the module the report pulls data from, for example Register-Risks. Type to search the list.

- In Name, enter the report’s name as users will see it, for example
Risk Register (Acme).
- In Type, choose Excel (.xlsx). The full list is Word (.docx), Excel (.xlsx), PowerPoint (.pptx), XML and JSON.

- Under Assignments, tick who can generate the report: users, roles and/or divisions. In this example, the admin and risk_admin roles. See Reporting Permissions.

Once a type is chosen, the Preferences panel on the right is where you set up the data and the template.
Adding a Tabular Data Source #
- Under Data sources, click Add New, then Tabular.

- Click Columns… next to the new data source. The โ turns into a โ once columns are set.

- Click the + at the top right of the window to add a column.

- In the column’s lower box, search for the field and pick it, for example
risk/reference.
- In the upper box, enter the column’s tag name, for example
Reference. This becomes the marker name. Click the โ at the top right of a column to remove it.
- Repeat for each column, then click OK.
Tip: The Show translated attribute names icon next to the + shows friendly field names.
Getting the Markers #
Click Show available markers…. Tabular markers use the data source name and the tag name. For a data source called rl with a column tagged Reference, the marker is {{rl:Reference}}.
Building the Template #
In Excel, put your headings in one row and the markers underneath, one per column, the same way as in Creating an Excel Report.
Uploading the Template #
- Under Document template, click Choose File (or drag the file onto Drop file here) and pick your template.

- Click Save at the top right.

Generating the Report #
- Click the Set up button at the bottom left to leave Set up.

- Click Reports at the bottom of the menu on the left.

- Find the report (type part of its name in the Name filter) and click Generate. The file downloads to your computer.

Tip: Click Filter next to Generate to limit which records go into the report. See Advanced Filtering on Reports.
