Some text fields are preprocessed by the report generator to support additional functionality:
#Custom report builder full#
To add columns to the report, click on the selected field in the list on the left. You can also search for field entries to limit the number of displayed items.
Each entity can be expanded or collapsed for better usability. In the left-hand side panel of the report generator, you will see all available fields for the selected report source, which have been grouped into entities. You can reduce or rearrange the options in that list in Site administration > Plugins > Data formats > Manage data formats.
#Custom report builder download#
Viewers also have the option to download the table data in various formats, namely CSV, XLSX, HTML, JSON, ODS, and PDF. Underneath the preview table, there is a Current query option that shows the underlying SQL query that is generated based on the configuration of your report: The accordion sidebar can be shown/hidden via the settings sidebar toggle.
Access to reports is granted via audiences, for example, all members of a selected cohort.Applying conditions lets you decide which rows will be made available, for instance, all records from a selected department.Configuring data fields lets you decide which columns are being made available, for example, user name, certification name, and completion status.Based on the selected report source, a certain amount of data will be available, which can be reduced by the following mechanisms: A record source contains a predefined set of fields that are available when building a report. Workplace offers a range of report sources to simplify the usage of the report builder.