Jaspersoft custom reports are blank in Excel, PPT, & PDF within Clarity

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Created a custom Jaspersoft report which executes & downloads in excel, pdf & ppt format from the Advanced reporting link.
A report definition has been created for the same report which can be run from 'Reports & Jobs' link from Clarity and this executes without any issues. However, the output which is generated is blank for EXCEL, PPT & PDF. 

How to troubleshoot this?

Environment

Release: All 

Resolution

• Make sure the datasource used is selected in Advanced Reporting for the report
• Make sure you select all possible records
• Test in Advanced Reporting - see if results are displayed
• Run with exactly the same filters in Clarity and compare
• Check the logs for any errors