How do the date input controls work in PPM JasperSoft based reports?

book

Article ID: 36210

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Question:

When a Jaspersoft report has Date input controls that are optional( date doesn't need to be entered), why doesn't the report return any data or less data than expected?

Answer:

For PPM out-of-box JasperSoft based reports.

When a Date input control is not mandatory, by design it will default to using a relative date. If the input control is "Start Date" and is made "optional" it will use this month's Start date as the relative date. This is done to ensure that the Report server doesn't hit performance issues due to too much data being returned.  This is the reason why most reports using FACTS tables instead of summary data will have input controls for dates being set up as mandatory.

If needed, you can take a report's existing query and redesign it to adapt it to your needs.

 

 

 

 

Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component: