These instructions will assist with building a summary report to capture any timesheet entries that have not been approved in a given date range.
A separate report can be created to capture any timesheet users who have zero time created in a given date range.
Link: Reporting Template: Timesheet Users with Zero Hours, Summary
The ability to build reports is linked to your Role permission. Administrators typically have this permission built in to their role, and can grant it to other roles if needed.
Designing Your Report: Creating the Report Template
Login to Nexonia on the web and navigate to the Reporting module.
Click the Create Report button to start the report configuration.
You'll see the General tab appear. Enter the following:
- Name and Description
- Type - select Time
- Summary - select Yes
Click the Add button.
You should now see the five tabs for configuring the report:
- General - general information and sharing permissions
- Selection Criteria - report template filters and defaults
- Columns - data columns for the report
- Categories - data categorization for the report
- Order - order of the report results
Important: as you update the settings in each tab, it's important to hit Apply to save your changes before moving to the next tab.
Most of the information will have been provided on your initial General screen. Here you can also configure:
- Shared - allows the report template to be private, shared with all other users or specific roles
- Header & Footer - you can enter information you'd like to see in the report header and footer, such as the title
This tab allows you filtering of the report data to be included. A number of fields can be set as hidden or visible to users running the report, set with defaults, or locked in with a predefined selection.
For this report, the key values are:
- Date Range - establishes the date range range of entries being pulled when this report is run.
- Date Range - Interval - this will be the default date range when a user runs this report.
- People - this will be the list of users whose data will be included in the report. By default it will include everyone visible to you based on your role permission. You can limit this to specific subsets of users or predefine which users will be included.
- Status = Check off the values you'd want to include in this report. For this report you'd want to check off the following:
- Draft - time entries that have been created but not submitted for approval
- Submitted - time entries submitted and currently pending approval
- Rejected - time entries that have been rejected and have not been deleted or resubmitted
For summary reports, you'll want to move to the Categories tab next. Categories controls which data values are available in the Columns tab for summary reports.
Click the Add link on the left and select the Category of data to include from the dropdown menu. Include the following:
- Week or other relevant period
- Current Approver - optional, but useful if you want to identify which approver a submitted entry is currently assigned to.
The Column tab is where you define what information you want to include in the report. We’ve included some columns of data that can be useful, but you can choose to add others, remove columns or sort them in a different order. Click Add and select the column value below.
For this report, include these five values:
- Week or relevant period
- User - Full Name
- Current Approver - Full Name
Order is what order are the results being presented. For example, you could sort the results by Date, then by User and Status.
You have now completed building your reporting template.
Running Your Report
Under the Reporting module, you should see the reporting template you just built. If you’re not seeing it, double check you don’t have a filter enabled.
Click the Action link to the left of the reporting template and you should see a dropdown menu with your Run option.
You’ll now see your Selection Criteria for the report. Make any selections if needed, and then click “Run”.
Tip: for the report format, use HTML if you want a pop-up with the results, PDF if you want a copy of the report to print, save or email, and .CSV if you want to open the report in a spreadsheet program in Excel -this can be useful for filtering the values to only view users with zero hours reported.
Here is a sample of the results:
Article is closed for comments.