ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Clarity PPM: Jaspersoft Timesheet Detail report not reporting hours on a Sunday


Article ID: 130364


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


The Jaspersoft report Timesheet Detail is not reporting time for Sundays.
This occurs on Clarity implementations on MS Sql Server.

Steps to Reproduce:
1. Post a timesheet with hours for a resource with the hours being included on Sunday
2. Run the Post Timesheets, Update Report Tables, Load Data Warehouse Jobs
3. Run the Timesheet Detail report.

Expected Result: The hours posted for Sunday should show up on the report.
Actual Result: The hours posted for Sunday do not show up on the report.


The report query is not evaluating correctly.


Component: PPMJSP


This is reported as DE37752 and is fixed in