The Crosstab Report allows time entry records to be selected and summarised across all users, projects and tasks and presented in pivot table format with the axes defined by the user . The information can be printed, exported, copied. The report selection criteria and configuration can be saved as a report profile and restored at a later point by simply reselecting the profile record.
Report Axis
The x and y axes of the report are defined by the 2 drop down-lists. The report is re-run automatically when either axis is changed.
Either axis can summarise data by Cost Center (if enabled), Project, Task, User, Week number, Month, Quarter or Year.
Summary Column
Defined the value to summarised as either the number of Hours or the Value of the hours (calculated by multiplying the number of hours by the rate). If Value is selected then only time records with an associated rate will be included in the report.
Report Filter
The report filter panel displays the filter information applied to produce the report.
Report Title
The report title can be entered and will be included on the output report.
Hours Report
Search
Clicking on the Search button will open the search dialog which will allow the criteria by which the report should be filtered to be entered.
Export
Exports the selected rows in HTML, Word, Excel or CSV format.
Chart
See Charting
Columns
Opens the column selection dialog which allows the displayed columns of the report to be modified. Removing columns will automatically be reflected in the report grouping so that by removing columns from the report you can increase the degree of summary.
Save/Report Report
Opens the report profile dialog which allows the user to save the current report configuration including the filter, sort order, columns and report title. Once saved the report profile can be selected to restore the report configuration with a single click. See Report Profiles.
Report Customisation
The report template can be customised (for example to add a company logo) by editing the file crosstab_report.htm in the DbNetTime folder
The User Crosstab Report has the identical functionality to the Crosstab Report except that the report will only include timesheet data from the user currently running the report. This makes the report suitable for general timesheet users who need to produce a report of their own hours covering more than one week.