Jaspersoft Custom Reports within CA PPM are blank

Document ID : KB000111416
Last Modified Date : 21/01/2019
Show Technical Document Details
Created a custom Jaspersoft report which executes & downloads in excel, pdf & ppt format from Advanced reporting link.
A report definition has been created for the same report which can be run from 'Reports & Jobs' link from CA PPM application and this executes without any issues however, the output which is generated is blank for EXCEL, PPT & PDF. 
This is caused by an error on the Lookup query for the report
CA Support does not troubleshoot custom queries.

Customers are advised to manually analyse custom queries for errors.