Reports > Summary Reports Color coding | Filters Use the Summary Report feature to view totals over designated time periods. You select the items to be totaled in the report as well as the time period. Summary reports can be run for items within a specific module or can be run across modules on an account-wide basis. Time Period - # of Periods Select the time period for which you want the data to be calculated, and the number of periods for which to calculate it. For example, if you choose "Monthly" as the time period, and "3" as the number of periods, your report will group your results by month over 3 months. There are default periods available. If you have created any custom time ranges, they will also be available in the list. The maximum number of time periods allowed in a report for different periods are: - Daily = 31 - Weekly = 16 - Bi-Weekly = 26 - Semi-Monthly = 24 - Monthly = 24 - Quarterly = 16 (only 4 if the report includes utilization values) - Annual = 16 (only 1 if the report includes utilization values) Note: For Invoices summary reports, if the timebills on invoices were created on dates outside the date range of the report, the value of those timebills won't be included in the report. Ending Date The default ending date is "Today", or the current date. To run a report for an earlier time period, either: 1. select a pre-defined date range from the "Ending date" dropdown, or 2. select Custom => from the "Ending date" dropdown and enter an ending date manually or by using the calendar icon. For example, if today was August 1, and you ran a report with "Monthly" as the time period over 3 periods, you would get data for June, July, and August. If you want data for earlier in the year, say from January to March, specify a date in the month of March as the ending date. Note: The data that is included in the report will depend on what "Date to use" you choose in the Options section. See the example below. For weekly and bi-weekly reports, the data included will also depend on the day of the week that weekly and bi-weekly reports start on. To change this setting, go to The Reports > Options link, and change the day in the "Global Report Options" dialog box. Options Select the value that you want to be totaled for each period. The available values will vary for different module-specific reports and for account-wide reports depending on the user role and company account settings. (If you have enabled multi-currency functionality, the base currencies will appear.) Note: Your choice of the "Date to use" for various reports will determine what data is included in the report. For example, if your company uses weekly timesheets from Monday through Sunday, a timesheet report for December 2002 (i.e. period = Monthly, # of periods = 1, end date = 12/31/2002) would include the following data depending on your choice of "Date to use": Time entry date - Sunday, 12/1 through Tuesday 12/31. Timesheet start date - Monday 12/2 through Sunday 1/5. Timesheet end date - Monday 11/25 through Sunday 12/29. Hierarchy In any user or project summary report, if there is a user or project hierarchy in existence, you can select to report by hierarchy. Hide empty rows Select whether to hide rows that are empty so that they do not appear in the report. First Sub-total You can further divide the report's totals per period by some other factor. Second Sub-total You can divide the first sub-total by some other factor. Additional Sub-totals Depending on the report, up to 10 levels of sub-totals are supported. Color Coding You can create a color-coded scheme for the report. You can specify ranges of values that will be displayed in certain colors in your report. To set up color coding for your report, click on the "Create >" or "Edit >" button next to "Color Coding." In the popup dialog box, enter the range of values you want coded and select a color for the range. There are seven colors available. Different ranges can have the same color, if desired. You can use decimal places for the ranges (for example, 10-19.99, 20-29.99, etc.). Overlapping ranges are not allowed. Click "OK" when you are done selecting the colors. Suppress Color Coding on Sub-Totals You can choose from a dropdown menu whether or not to suppress color coding on sub-total rows. Suppressing color-coding helps the visual display of reports. Suppress report total column You can choose not to display the grand total column on any module or account-wide summary report. Percentage format In Timesheets you can select the format in which percentages will be displayed in reports. Filters You can create filters to limit the items that are included in the report. If, for example, you only want the report to include data from two of your clients, click on the "Create >" (or "Edit >") button for the client filter. In the popup form that appears, remove from the Selected items list all the clients you do not want to include in the report. To make these selections, either pick from the available items, or search for specific items through the "Find" link at the top of the box. Detail Fields You can add detail for entities included in any report value or sub-total. If, for example, you want the report to include phone numbers for the clients you are reporting on, click on the "Create >" (or "Edit >") button for the client detail field. In the popup form that appears, add the phone number field to the list of Selected items. Or, if you are sub-totaling the report by project, click the "Create >" (or "Edit >") button for the project detail field to add the project owner or other project-related details. Denominators You can choose how to calculate the denominator for various utilization reports. Check the "Use work schedule hours" button if you want to calculate based on all hours that are actually scheduled, taking into account vacation for example. Check "Use base work schedule hours" to calculate based on all hours that could be scheduled in a user's "normal" week. For historical utilization reports, you can also check "Use timesheet hours" to use hours from approved timesheets. If you want to use only a subset of these hours you can use the filters to limit the items that are included in the report, either using the same filter that was applied to the numerator or creating a different filter. Project pricing approval status In accounts that use project pricing scenarios, reports can be further filtered based on the project pricing approval status by selecting "Not approved," "Staffing approved," or "Finance approved." The default is to include all three. Other When you run a report, you have the option to save it so you can run the same report over again. When you are setting up a report, check the "Save this report as..." check box, and enter a name for the report. The next time you want to run the report, go to the "Saved reports" tab, and click on the "run" icon for that report. You can also edit and delete saved reports. For more information on saved reports, see Reports > Saved Reports. If you check the "For downloads, generate distinct columns for each entity when sub-totaling is specified" box, any downloaded information from this report will have a different column for every type of data you download.