Reporting

Lists with Filters, Groupings, and Totals

Use time cockpit’s powerful data grid to work with your time tracking data interactively.

Browse through your time tracking database with time cockpit’s powerful data grid. Use it to maintain master data, manage your team’s time sheets, create invoices, etc. The browser-based online client offers the same functionality in the data grid as the full client.

• Select from a variety of predefined filter options
• Full text search that works across all text fields
• Wizard for building custom filter criteria
• Sort your list by clicking on a column header
• Group your list by dragging & dropping the corresponding column header
• Totals and sub-totals (for grouped lists) for numeric fields
• Navigate between lists using hyperlinks
• Possibility to add your own list definitions for frequently occurring usage scenarios (read more about customization options ...)

Reporting Engine for Custom Reports

Create and integrate custom reports using Microsoft SQL Server Report Builder or Microsoft Visual Studio. Read more about time cockpit's support for custom reports ...

• Generate a default print view for any time cockpit list.
• Download generated RDL file as a starting point.
• Use Report Builder or Visual Studio to customize the report.
• Add tables, cross-tables, charts, or sparklines.
• Export reports to PDF or Microsoft Excel.
• All your customizations and extensions in the time cockpit data model are available in the reports.
• Permission system applies to reports, too.

Export to Microsoft Office Excel

Export data from time cockpit lists into Microsoft Office Excel.

Export any list that you have on the screen to Microsoft Office Excel (.xlsx) with one mouse click. Time cockpit will export only the data rows that correspond to your selected filter criteria. Export to Microsoft Office Excel works in the full client (online and offline) as well as in the online browser client.

Templates for Exporting Data to Microsoft Office Excel

Use templates to create powerful reports in Microsoft Office Excel.

Create templates for exporting data from time cockpit to Microsoft Office Excel. You do not need programming skills or knowledge about Excel macros for templates. Currently export templates are only supported in time cockpit’s full client; the browser client does not support them. Examples for features that time cockpit export templates support:

• Add calculations using time cockpit’s formula language
• Add Excel-based formulas that will work with the exported data
• Build pivot tables and pivot charts that are populated during the export process automatically

Access Time Cockpit Data from 3rd Party Reporting Tools

Use your favorite report generator to build reports directly from your time cockpit database.

Contact us if you are interested in accessing your time cockpit database with your favorite report generator. Behind the scenes time cockpit uses a SQL Server-compatible relational database cluster to store your data. If your report generator supports SQL Server (e. g. via ODBC) it is likely that it can access your time cockpit database (note that OLE DB access is not supported).