Why do I see duplicate records within my Table Report?
When creating Table Reports, there are times when Records appear to be listed multiple times within the same Report. Table Reports will display all unique combinations of linked Records from selected Workflows, regardless of whether any Fields from some Workflows are displayed.
The first determinant of Record count in a Table Report is the Primary Workflow of the Report. Each Record included in the Primary Workflow of a Report will be included within the Report (pending filters). For example, in the screenshot below, each Risk Record (there's only one) is included automatically because the "Risks" Workflow is the Primary Workflow.
What then determines if Records are displayed multiple times are the linked Records from Secondary Workflows in the Report. In the example above, Risk "001 - Unauthorized Access" has two different, distinct Assessments, "Assessment-9" and "Assessment-10". Since those are two distinct combinations, each combination with have its own row in the Table Report. If the Risk was linked to two separate Assets, as well, then we would have four rows (1 Risk x 2 Assets x 2 Assessments = 4 Combinations).
If we are to remove the IT Risk Assessments Fields (in purple) from the Report, we still have two rows, but they appear to be the same because the distinguishing Records are not displayed.
If you see duplicate rows / Records in your Table Report, investigate the Workflow structure and whether all unique information is displayed on your report!
Hide Duplicate Rows (Flatten Table Reports)
To help manage duplicate rows in multi-workflow Table Reports, Risk Cloud includes a Hide Duplicate Rows toggle in Table Report settings.
How It Works
- When ON: The Table Report displays only the most recently created record combination for each primary record, effectively removing duplicate parent rows. This is useful when you only need to see the latest relationship.
- When OFF: The Table Report displays all relationships — every unique combination of linked records across workflows will have its own row. This is the default behavior.
Note: The Hide Duplicate Rows toggle is only available for multi-workflow Table Reports. It is hidden for single-workflow Table Reports, as duplicates only occur when multiple workflows are joined.
Example
Consider a Table Report with two workflows (Risks and Assessments): Risk-03 is linked to Assessment-9, Assessment-10, and Assessment-11
- Assessment-9 was created on March 6th, 2024
- Assessment-10 was created on March 4th, 2025
- Assessment-11 was created on March 3rd, 2026
| Hide Duplicate Rows | Rows Displayed |
| OFF | 3 rows — one for each Risk + Assessment combination |
| ON | 1 row — only the most recently created combination of the parent record and the most recently created child record (Risk “001” + Assessment-11) |
Behavior in Linked Workflow Sections
When a multi-workflow Table Report is used in a Linked Workflow Section on a record page, the Hide Duplicate Rows logic is automatically enforced, regardless of the Table Report’s setting. This is by design to prevent end-user confusion when selecting or viewing linked records.
For more information on configuring Linked Workflow Sections with Table Reports, refer to the Add a Linked Workflow Section to a Step Form article.
For articles related to Table Reports, please see below:
Work with Data in Table Reports
Structuring Table Reports