Use the Report Builder to create custom reports, from simple summaries to complex management reports.
You can create reports in two ways: from the Reports navigator to report on data that meets specified criteria, or from a form to create a report based on selected records. Both methods let you choose fields, apply filters, and save report settings for future use.
Create a report from the Reports navigator
Select the module you want to report on, then click Reports.
Click New, then select the entities you want to include in the report.
Entities are datasets associated with specific areas of the system. For example, the Contact entity contains data related to contacts, while the Payment entity contains approved payments. You can include multiple entities together when they share a link. For example, Contact and Payment entities can be linked using the contact serial number.
Select the fields you want to include from the chosen entities.
Aggregate fields, such as Max of payment date, can return summary values. For example, selecting contact details, payment type, and the maximum payment date returns the most recent payment date for each contact and each payment type they have used. Configure the uniqueness property where required.
Apply filters to narrow down the data.
Filter options are available to the right of the checkbox used to include each field. You can filter by a field without including it in the report output.
Click Save, then enter a name and description for the report.
From the Folder drop-down menu, select the folder where you want to save the report.
From the Run Permissions drop-down menu, select which users can run the report.
To allow all users to run and edit the report, select General.
From the Edit Permissions drop-down menu, select which users can edit the report.
Click Save.
Create a report from a form
Open the form you want to report on, then search for the records you want to include.
From the toolbar, click Report, then select the details you want to include in the report.
The relevant entities are selected automatically. Add any additional entities you need.
Select the fields you want to include from the chosen entities
Apply filters to narrow down the data.
Click Save, then enter a name and description for the report.
From the Folder drop-down menu, select the folder where you want to save the report.
From the Run Permissions drop-down menu, select which users can run the report.
From the Edit Permissions drop-down menu, select which users can edit the report.
Check that the Layout and Criteria fields are set as the Save Type, then click Save.
Find entities and manage report results
Find an entity: In the appropriate field in the Report Builder, start typing the entity name, then select the relevant entity.
Report on a saved search: If you load a saved search into a form and create a report from the ribbon, the report includes only the records from that saved search.
Remove duplicate records: If the report returns duplicate records, click Properties, then select the Unique Rows checkbox.
