Custom Report Builder
You can view and/or build custom reports for large groups of data or filter the data for a specific need. Reports can be in HTML, Excel, or CSV format.
For example, you can get all the information from the Personnel tabs in the DDQs by selecting Case Assigned to a third party profile related to a questionnaire sent for response, due diligence investigation, or other action. Detail and all fields then generate the report.
When you select Analytics and view the Tracking section, these two report builders are available:
- Custom Report Builder: Report on Case Detail, Third Party, or User Account data.
- Intake Form
A form is a questionnaire to gather information. Report Builder: Report on Due Diligence forms, Online Training forms, or Internal forms.
Select an existing custom report
You can view existing reports that have been saved and marked as public or reports that you created and saved. To select an existing report:
- Select Analytics then, in the Tracking section, select Custom Report Builder or Intake Form Report Builder.
- On the CUSTOM REPORT BUILDER page under My Saved Reports, select the report. Public reports are identified with an asterisk (*).
- Scroll down and, under Create Report, select the Report Output.
- Select Run. The number of records is displays.
- Select Run Report.
Caution
Changing any fields on this page changes the report criteria. A best practice is to save a report with a different name (Name Report) before changing criteria.Steps to create, run, and save a custom report
The steps and user interface are similar for the Custom Report Builder and Intake Form Report Builder. The steps below focus on the Custom Report Builder but the steps for the Intake Form Report Builder are similar.
Steps to create, run, and save a custom report follow.
- Select Analytics. In the Tracking section, select Custom Report Builder.
- In Define the Report select:
- Type
The type of third party, for example, Channel Partner, Vendor, Supplier, or DO NOT ENGAGE.:
- Case Detail: If selected, Available Fields includes information like the case number, assign date, approve DDQ
Due Diligence Questionnaire which can be sent to third parties for response. Questions can be added to a risk model to use in determining the overall risk rating for a third party., owner and percent owned, red flags, "whether to engage" decision and reason, third-party, and so on.
- Third Party: If selected and engagements is enabled, identify the Scope as Profiles, Engagements, or Both. The Available Fields includes information like the profile or engagement number, cases, category, GDC
Global Database Check screens over 1,500 lists for sanctions, embargoes, watchlists, court lists, and politically exposed persons. When a third party is entered, it is immediately screened. Re-screening frequency can be scheduled. needs review, last GDC screening, risk model
Created for different third-party types and categories within the type to apply separate evaluation criteria to diverse types of third parties. Four factors make up a risk model: country, type and category, DDQ questions, and third-party custom field questions., type, and so on.
- User Account: If selected, Available Fields includes fields like the date created, phone, name, login ID, status
Third-party Status used for searching, for example, Active or Inactive. Approval Status is a subset of the Status. See Approval Status. Case Status used for searching, for example, Only Open Cases or Only Closed Cases., type, and so on.
- Case Detail: If selected, Available Fields includes information like the case number, assign date, approve DDQ
- Detail (optional): Make a selection to further narrow down the Available Fields for the report for easier selection.
- Type
- Chose Fields to Include:
- Select - All Sources - to have all fields available. Or make a selection to narrow the Available Fields for easier selection.
- In Available Fields, select each field
A field is a way to input information, often a question. for the report and select the right arrow button.
To remove a selected field, in Fields Included in Report, select the field then select the right arrow button. - In Sort Field(s), select the order which can be Ascending (small to large, A to Z) or Descending (large to small, Z to A).
- Content Filters:
- Select a Date Range for the on value you select. Enter a Start and End date.
- In Other Filters, complete the following steps.
- Select a value to filter by.
- Select the Configure link to limit the data in the report by selecting or deselecting items to include.
- Select the Apply button.
- Create Report:
- Name Report: Enter a name for the report.
- Private or Public: Select Private to prevent others from viewing the report once it is saved. Select Public if others in your organization with access to the reports can view the report once it is saved.
- Select the Output:
- HTML which will display in a new window. You can right click the HTML page to print as a PDF or other format, generate a QR code which requires log on, and other functions.
- Excel UTF-16LE with tabs which will be downloaded.
- Standard CSV UTF-8 with comma delimiters which will be downloaded.
- Select the Run button to run the report. A good practice is to run the report and verify the output before saving the report.
- On the Ready to Run Report window, you can see the number of records that will be reported on. If the number looks viable, select Run Report.
- The report is run, and you are taken to the CUSTOM REPORT BUILDER page with the REPORT SUMMARY. From this page, you can select the link for another format to view the report on a new tab. (Select the link. Do not right click and select Open link in new tab.)
- When you are done, select the Clear Results link. You are returned to the CUSTOM REPORT BUILDER page with the settings for the report.
- When the report is complete, select the Save button to save the report. If you want to save several versions of a similar report, change the name of the report before saving.
- To select a saved report, on the CUSTOM REPORT BUILDER page under My Saved Reports, select the report. Public reports are identified with an asterisk (*). In the following example, there are two private versions of the report which were used in perfecting the public Final Report.
Note
If you recently created a report, the CUSTOM REPORT BUILDER page will display with the REPORT SUMMARY. Select Clear Results to return to the previous screen. The filters are maintained.