Overview:
While running a report in Vault, everything looks as expected with each record having one line item. Once the user exports a report using PDF or Excel format, records are appearing with multiple line items. This is different than the results shown in the Vault report.
Root Cause:
This issue stems from a configuration of that particular report type, object relationships, and the related object being hidden in the report configurations. For example, a report type has a related object configured. The reason why multiple record lines do not appear in Vault's report viewer is that they are hidden in the report configuration.
Example:
Related Object: Proactive Initiative Quality Team Members to Primary Reporting Object: Quality Event on a Report Type:
The Proactive Initiative Quality Team Members object is hidden in the report configuration:
Solution:
Even though the related object records are hidden in the report configuration, when the report is exported into a PDF or Excel format, the report still provides the information for each entry based on the object relationship. To prevent multiple line entries for each record while exporting to a PDF or Excel format, users should remove the object relationship in the report type.
Related Documentation:
Vault Report Documentation: Configuring Report Types