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!
For articles related to Table Reports, please see below:
Work with Data in Table Reports
Structuring Table Reports
Please sign in to leave a comment.