Creating a Personalized Report |
|
The standard reports that are available in the Time & Attendance module provide you with a variety of useful data. However, personalizing reports can make them even more useful. You can use a standard report as a template and edit some or all of its default settings to meet your specific needs. When you save the changes, a new report based on your personalized settings is created in the My Reports list on the main reports page. (Note that the original standard reports always remains unchanged.)
You can create multiple personalized reports based on the same standard report, as long as you save each one with a different name. All of your personalized reports appear in the My Reports section on the main reports page, from which you can quickly view, save, or print them. These customized reports are associated with your Time & Attendance module user ID and are only available to you.
To create a personalized report:
From the Reports menu, select Time & Attendance Reports.
Note: If the Time & Attendance Reports option is not visible, make sure that you have selected Practitioner in the Role Selector.
In the Report Categories section, click the or Supervisor Reports link. A report category page opens and displays the names and descriptions of all of the reports in the selected category.
If you are not sure which standard report you should use as the basis for your personalized report, click the button that appears next to a report to view the report with its default settings. (Repeat this step as necessary.)
When you find the standard report you want to use, click the button to the left of the report in the list. The Edit Report page opens and displays the default settings associated with the report.
Review the settings on the Edit Report page and make changes as necessary. The table below provides general information about the fields and settings that appear most commonly on the Edit Report page.
Note: The fields and settings described in the table below do not apply to every report type. If the field being described does not appear on the Edit Report page, skip to the next row of the table.
Name |
Enter a logical name for your new report. Tip: The name you enter in this field is displayed in the My Reports section of the Reports page. Although you can leave this field unedited and create a personal report with the same name as the generic report, it is more helpful to make the report name indicate that the new report is a more specific version of the generic report. |
Report Title |
Enter the title of the report, as you want it to appear in the header (and on the title page, if you choose to have one) of the report. |
Description |
Enter a description of the report that clearly identifies the report's contents. Tip: If the report will be for a specific time period or will be filtered in some way, it is helpful to indicate this in the description, since the description also appears in the My Reports list. The description can help you distinguish two similar reports (for example, two versions of the same basic report that differ only in their time frame or employee filtering.) |
Print Options |
Allows you to specify print options for the report:
|
Time Frame |
Click the and select from the list of options the time period for which you want data to be displayed. Notes: |
Available Fields / Selected Fields |
Use the and buttons to move fields from the Available Fields box to the Selected Fields box and/or from the Selected Fields box to the Available Fields box until only the fields that you want to appear in the report are listed in the Selected Fields box. Then use the and buttons to adjust the order in which the selected fields should appear on the report. Notes: |
Employee Status |
Allows you to select the employees who are included in a report based on employment status. You can select one of the following options:
Note: If you generate a report using the All current employees setting and you select a time frame in the past, employees who currently have a status of Terminated will not be included in the report, even if their status was Active during the selected time frame. In order to include employees who are now terminated but were active during the selected time frame, you must select either the All employees setting or the Include only employees who are setting with at least the Terminated check box selected. |
If you want to narrow the scope of the report, click the in the Create a New Filter - Select Field box and select the category for which you want to create a filter.
Notes:
- If you have set your preferences in the Timecard Manager to display
either the Rate Modifier or Shift Override field, you may be able
to display the data from these fields in the following reports: Timecard
Report, Timecard Report with Notes, Timecard with Payroll Report,
or Timecard Exception Report. (Contact your practitioner
to find out if your company is configured to display this data in
reports) If you want to filter the data from these fields, select
Rate Modifier or Shift Override from the Create a New Filter - Select
Field box and then go to step 7.
- For Timecard reports, if you want to view loaned employee time, you
must apply a filter for the labor charge field (LCF) that has been
loaned to you.
If a Qualifier drop-down and a Value field appear to the right of the filter field you have selected, use them to specify the criteria for your filter.
Note: The filter selection fields vary by filter type and are designed to be self-explanatory. Consult the following general guidelines if you need help.
Some filter types do not allow the definition of additional settings. For example, Adjustments Only or Terminated Employees Only require no further specification, so no Qualifier and Value choices will appear if you select one of these filters. In such cases, skip to the next step.
The Qualifier drop-down menu allows you to select one option from a menu of functions in order to create a formula by which the report records can be filtered. To select a qualifier, click the and select an option from the drop-down list. The available qualifiers vary according to the filter type you select. Some common choices on the Qualifier menu are Equals, Not Equal, Begins With, and the symbols indicating Less Than (<), Less Than or Equal To (<=), Greater Than (>), and Greater Than or Equal To (>=).
The Value field functions differently depending on the type of filter you have selected. If the filter category has a small number of options that do not change often, they may be listed in the Selected Value field. To select the values you need to complete your formula, simply click each value in the list. To select more than one item from the list, hold down the Ctrl key while you make your selections. Remember that if you selected Not Equal To from the Qualifier menu, you are selecting the items that you want to be excluded from your report. (Use Equals as the qualifier if you want to specify which records should be included.)
If the Value field can be set to one or more values that are drawn from another list or data source within the Time & Attendance module, the Values field will be a multiple-selection lookup box labeled Selected Values. Click the button to open a lookup window and select one or more items to add to the values already displayed in the Selected Values box. Use the button to remove items from the list in the Selected Values box.
If the filter category is based on a date, the Value field will be a simple Enter Value text box. Either manually enter the appropriate date for your formula or click the button to select the date from a calendar lookup window.
If the Value field can only be set to a single option, such as True or False, these options will appear in a drop-down menu. Click the and select the desired option from the drop-down list.
If the Value field requires a text entry, simply type the appropriate value in the Enter Value text box. For example, if you selected Last Name as the filter category, and Begins With as the qualifier, enter the appropriate letter or letters in the text entry field to select only the subset of employees whose last names start with the letter(s). The filter is not case-sensitive.
After you have made selections in all of the available filter definition fields, click the Add Filter button to add the filter. The page refreshes and the new filter is displayed in the New Filters (not yet saved) section of the Edit Reports page. The filter settings are not saved until you save the entire report.
If you want to create another filter for this report, repeat steps 6-8.
Tip: You can delete a filter from the report by clicking the button that appears to the left to the filter name.
When you have edited all of the report settings and created all of the filters you want to apply, select the appropriate button at the bottom of the page to save and/or preview your new, customized report. The effect of each button is described below.
Save |
Saves the report with the name, title, description, settings, and filters you have specified. The report will now appear in your My Reports list, from which you can delete, edit, download, or view it. |
Preview |
Runs the report with your new settings and displays the results, in PDF format, in a new browser window. This allows you to preview the report so that you can make further adjustments to your settings, if necessary, before saving the report settings. Notes: |
Save and Preview |
Saves the report with the name, title, description, settings, and filters you have specified and then runs the report and displays the result, in PDF format, in a new browser window. The report will now appear in your My Reports list, from which you can delete, edit, download, or view it. Notes: |