Skip to main content
Planview Customer Success Center

Report Designer report with design filter returns several duplicated project information (2012)

The user has defined a report with several tables.
Some of these tables (minimum 2) are using the same data collection that contains project and tasks providers.
One of these tables only display project information.
A design filter is used to filter information on tasks on this data collection.

The report displays duplicate values on the table which only displays project information.

Reason:
When there is no design data filter, the code is optimizing the sql queries for the project-only tables and avoids using the data collection for returning project only information. As a consequence, only one row is returned in this table.

When a design data filter is added for task field values, the code has no other choice but to use the data collection and data sources and to join project and tasks data, returning one row per task matching the design filter, therefore returning multiple lines for the same project fields such as the project name. As a consequence, project-only tables based on the same data collection also return multiple lines.


Workaround:
Recommendation is to use one data collection for the project-only tables and one for the table having to return task information.