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.