System Settings → Report Templates → System Reports → Missing Timesheets

Missing Timesheets

This report shows timesheets that were not submitted or saved for a user-defined date range and specified resource team. Only open timesheet periods are displayed.

The user-configurable parameters in this report are:

Fields

Descriptions for the fields that are available in this report can be found in the following table.

Field Description
Capacity Hours

The amount of planned hours that could be reported during the missing timesheet reporting period.
Hours Not Yet Posted

The variance between the actual hours and planned hours in the missing timesheet reporting period.
Period End

The date on which the missing timesheet reporting period ends.
Period Start

The date on which the missing timesheet reporting period begins.
Reported Hours

The name of the work item, log item, or discussion.
Timesheet Period / Resource Team / Resource

The name of the timesheet period, resource team, and resource.

Screen Shot

Screen shot of the Missing Timesheets system report.

Adding a report that uses the Missing Timesheets report template

To add a report that uses the Missing Timesheets report template, open the New Report dialog box from the My Reports tab and then follow the steps below.

To add a report that uses the Missing Timesheets template
  1. Open the Tools module.
  2. Select the My Reports tab.
  3. Click New Report, select Resource Team, and then click OK.

    New Reports dialog box.

  4. In the New Report dialog box, type a name for the report.
  5. On the General tab, from the Report Template drop-down, select Missing Timesheets, enter a description (optional), and indicate whether you want to run the report immediately (after you are finished creating it).

    Choose a report.

  6. Under Associate Report With, click the ellipses button and then use the Select Resource Team dialog box to identify the groups of resources that will be included in the report data.

    Choose a resource team (or group of resource teams) to which the report will be associated.

  7. On the Schedule tab, select Run this report on a schedule if you want the report to be run on a periodic basis. Once selected, you can define how frequently you want the report to be run, the format in which the report will be presented, and how many previous instances of the report you want to store.

    Indicate whether you want to run the report on a scheduled basis.

  8. If you have chosen to run the report on a scheduled basis, you can use the Recipients tab to select the users, security groups, and security roles who will receive a notification when this report is run. After you have chosen the recipients, click Add.
  9. If you have chosen to run the report on a scheduled basis, you can use the Template tab to define parameters for the email notification. You can define the title (as it will appear in the subject line). You can add the Timestamp and Report Name attributes into the title or the template (the message body). You can add a URL link into the message body that will allow any recipient to link directly to the report.

    Indicate whether you want to run the report on a scheduled basis.

  10. When finished, click OK.

View

You can view the Missing Timesheets report directly after adding it by selecting the Run this report immediately option in the New Report dialog box. (Reports can also be run from the My Reports tab in the Tools module or the Reports tabs in the Projects module.) Set the filter options and click Apply Icon Apply.

The filters that are available for the Missing Timesheets report.

Filter options:

Filter Description
Based on Capacity

Indicates whether submitted or unsubmitted timesheets will be shown. If this option is selected, reported hours, capacity hours, and hours not yet posted will be shown for each resource in the report, including the variance between reported and capacity hours. If this option is not selected, only unsubmitted timesheets will be shown.
End Date

The date on which the reporting period ends. Use the calendar picker to select this date.
Group By
For any report that includes both investment and resource data, you can choose to filter the report by investment or by resource, and then by the other. For investment reports, users can view the report sorted by item and then by resource team. They can also sort the report by resource team, resource and then by item. For resource team reports, users can view the report sorted by resource team for the entire date range or by resources broken down into timesheet periods. Filter options:
  • Investment reports: Investment / Resource Team or Resource Team / Investment
  • Resource Team reports: Role / Resource Team, or Resource Team / Role
Start Date

The date from which the reporting period begins. Use the calendar picker to select this date.

Copyright © 2003–2011 Serena Software, Inc. All rights reserved.