When you Export to Excel (XLS) the 'Resource Allocations and Assignments Report', the 'Assignments' row is not exported for some or all investments.
It appears that the root cause of the issue is the size of the investment name. The report displays properly within the report generated through Advanced Reporting and displays properly if you export the report to PDF. It seems that this behavior is only occurring when you try to export the report into Excel and the name of the investment is too long and the 'Assignments' row disappears.
Steps to Reproduce:
Expected Result: The Export to Excel output should match the Report output
Actual Result: The Export to Excel output is missing the 'Assignments' row for some of the investments
Caused by CLRT-80008
The Investment name exceeds the 260 pixels defined for this field in the report layout. The field has the Stretch Within Overflow option flagged, which is a common practice in stock reports. The field should wrap and when it happens, all other fields on the same band should be accommodated according to the tallest field and Excel is not honoring the fields correctly.
This defect has been resolved in CA PPM 14.3 Patch 7 and CA PPM 14.4 Patch 1.
Use another export option or if possible shorten the name of the investment to approximately 40 characters.
Reference TEC1696455: PPM 14.3 Generic Patch available to resolve reported issues