In Advanced Reporting, the report "Project or Program Roadmap" returns with the message "No matching records found'

Document ID : KB000073578
Last Modified Date : 16/03/2018
Show Technical Document Details
Issue:
In Advanced Reporting, the report "Project or Program Roadmap" returns with the message "No matching records found". This occurs even though we have projects that have milestones and key tasks within them. 

We've run the Load Data Warehouse and the Load Data Warehouse Access Rights, but it continues to show this message instead of the projects we expect.
Resolution:
In order for a project to be displayed within the report, the project must have milestones that have both the milestone and key task fields checked on. Ensure that the project(s) in question have the above condition satisfied. If not, update the milestones to meet that requirement and then re-run the Load Data Warehouse Job.

Additionally, by default, one of the grouping parameters of the report (typically Group By 2) is set to "Program". If none of your projects are part of a program, then they will not be displayed and instead the "No matching records found" message will be displayed.

Set the value of the "Group By 2" parameter, or whichever has the "Program" as its grouping value to "No Grouping". This will display your projects, even if they do not belong to a program.
Additional Information:
More information on the prerequisites of the "Program or Project Roadmap" report can be found here Project or Program Roadmap.