Hi Leo,
You didn't specify if this is a BO or Jaspersoft report. Here are the prerequisites for the report (Jaspersoft - Advanced Reporting):
If you're using BO (regular Reports from Reports and Jobs) ignore the part with Load Data Warehouse job:
Report Prerequisites:
• The Load Data Warehouse and Load Data Warehouse Access Rights jobs must be run before you run this report. If the Data Warehouse is not populated, the report will display a message that there are no matching records. Also, most of the report parameters do not display options.
• The report displays resources that are set up to enter time in CA PPM. If the resource does not have a timesheet in CA PPM for the time period and timesheet status selected when running the report, then the resource will display in the report with a timesheet status of 'Open' with zero hours. It is not necessary to have at least one timesheet for the resource to display in the report.
• The resource is considered set up for time entry if the following conditions are met on the resource: the open for time entry field is checked; the track mode set to 'Clarity' or 'Other'; the date of hire is blank, prior to the time period, or within the time period; and the date of termination is blank, after the time period, or within the time period.
• There must be time reporting periods created (Administration/Project Management-Time Reporting Periods). The time reporting period must have a status of open in order to enter time in the period.
• The investment must have the open for time entry field checked and the track mode set to 'Clarity' in order to enter time against the investment. If the investment is a project, then the open for time entry field on the task must also be checked in order to enter time against the task.
• The investment must have at least one resource assigned to a task in order for the resource to enter time against the investment and for it to display in the report. For projects, the resource must be assigned to a task in the Gantt unless the project has an effort task with resources automatically assigned. For investments other than the project, resources added to the team are automatically assigned to an effort task for the investment. Note: Effort task is a task with the Task ID of '~rmw'.
In a timesheet, resources may also assign themselves to tasks if they are a team member on the project and the 'Prevent Unassigned Timesheet Tasks' field is unchecked on the project. This field is in the time and staff section of the settings properties on the project. They may also create unplanned tasks in a timesheet if they are a team member on the project and have the appropriate permissions (Project – Edit Project Plan).
• The resource available hours are calculated based on the time slice with the name DAILYRESOURCEAVAILCURVE (Administration/Data Administration-Time Slices). This time slice is not a Data Warehouse request, therefore, it must be configured to cover the dates displayed in this report or the report will not display data for those dates.
Please could you follow these prerequisites and see if Missing Time displays the time correctly?
Looking forward to hearing from you.
Kind Regards
Nika Hadzhikidi
CA Technologies
Principal Support Engineer
#helpinghands