Reports

TimeControl has extensive unlimited functionality for creating reports. Once defined, reports can also be filtered in a virtually unlimited fashion. We have included samples from the different reporting functions of TimeControl on this page but this is just a sample of what you are capable of producing with the TimeControl reporting engines.

There are several methods of outputting TimeControl's data:

The Main TimeControl Report Interface

The What you see is what you get (WYSIWYG) Report designer is capable of producing reports on any timesheet data or any table of data within TimeControl. Click to see full-sized image Reports can be tabular or graphical. They can include logos, pictures, charts, pivot tables, calculated fields and more with complete layout and font control over every element. The report format is created using the full-screen TimeControl Report Designer and once created, the report can be viewed by any user who has been given rights to it in our TimeControl Report Interface. Reports in this format can be viewed with any browser or on any device including tablets and smartphones.

Security of the TimeControl Reporting environment is defined in the User Profiles area. First, an Administrator can determine if a user should be able to see any reports at all in Menu Security. Next, the Administrator can define which report formats are visible to which users in Report Security. Even if a user has access to a report format, the data that is visible is defined in the General Security area. Perhaps a user might only be able to see report data from their own department regardless of the format of that report. Click for a full-sized image of this report displayed on an iPad Finally, TimeControl reports even control data down to the field level. Even if a user has access to a particular report format and a collection of data, if there is a field on that report that has been blocked for that user, they will not see it.

Users also get the opportunity of filtering data at run time. Filters can be set in advance by an Administrator or can be dynamically defined at run time. Perhaps, for example, a user will only want to see timesheet data for a range of dates or only for a selection of projects or a particular department of employees. All of this can be defined by the user as the report is generated at run time.

You can bring your reports to the field with the new TimeControl Report Interface. Once a report has been designed, it can be displayed on a wide range of devices, browsers and interfaces. Want to get an update of what hours were posted yesterday on the project while out in the field? Display the results on your iPad or other tablet. Want to see what tasks are pending for the team you're meeting on the project site? Display a pending task and progress list on your SmartPhone.

Schedule Reports

The TimeControl Report Scheduler allows you to create an automatic report that will be sent via email to its intended recipients.

The schedule can include one or numerous reports. Each report can be directed to an email recipient or a group of recipients. The email can be sent as an attachment in PDF, Excel, Word or CSV formats or, if it is too large to email, a link can be sent instead and the report will be stored on the TimeControl server and optionally encrypted. TimeControl's security means that any report created cannot exceed the rights of the user creating it.

Scheduled reports have the potential to dramatically alter the way management interacts with timesheet data. If only exception reports are scheduled, they will only see the report if exceptions are present. This means management can get key decision making information without having to even enter TimeControl.

Legacy TimeControl Reporting system

First, the main reporting system itself has four categories:

Posted timesheet data

Since 1999, TimeControl included a spreadsheet-like interface for producing reports. This legacy system will continue to be supported for the foreseeable future to support the vast number of client-created report formats that are part of thousands of TimeControl deployments. As the functionality of the main TimeControl Report Interface is more extensive and the fact that reports from the Main TimeControl Report Interface can be viewed on any device or browser, we expect that over time a natural migration to the new Report Interface will occur. But, the functionality of the existing reporting system is still there and there are numerous pre-defined reports included out of the box to show timesheet data by employee, by week, by project or by charge.

The legacy TimeControl report interface includes a Reporting Wizard which allows any combination of fields from the posted timesheet data and any table data related to it. Reports can be sub-totaled, have page breaks and skip duplicate lines as you wish. Once created, the reports are only visible to the security user profiles you define. When the report is run, it can be optionally filtered dynamically with values entered in a screen at run time. The resulting report is in a spreadsheet format which can be printed or saved in Excel format.

Timesheet Tables

TimeControl also includes pre-defined reports and a Reporting Wizard to report on data in any of the supporting tables. Just like the posted reports, TimeControl table fields can be selected and filtered along with any related table data.

Missing timesheet report

A special category of report in TimeControl is one of the most popular. The Missing Timesheet report displays a list of timesheets that are either missing, not yet approved or both over a selected time period so that supervisors or administrators can quickly locate those timesheets in order to complete a period. The report contains numerous options and can be distributed to supervisors with the constraint that they can use it only for their own part of the organization.

Timesheet image report

In some cases, it will be required to show a printout of a timesheet looking just as it did when it was entered. The Timesheet Image report does exactly this. A range of employees and timesheet periods are selected and the resulting report appears in our standard spreadsheet format.

Drill-Down Analyzer

TimeControl's Drill-Down Anaylzer is a powerful method of making rapid queries of the TimeControl posted or unposted data. The system presents a preselected list of fields and the ability to add additional fields or additional pre-defined lists. A long optionally filtered list of data is presented in a spreadsheet format. Then, when the user drags any column to the summary bar, the data instantly groups and summarizes by that field. Add a second field and it makes a sub-group. Add a third and there's an instant third level of summary. It has to be experienced to get the full impact so take a quick look at our Online Video lesson on the feature. Drill-Down Analyzer views can be printed or saved as XML or Excel files for additional use.

TimeControl's Drill Down Analyzer

Export with XML style sheets

TimeControl's export functionality is very powerful and when data is exported, one of the options is to store it as XML with an optional XML stylesheet making the data into an instant browser-based report. The stylesheet can be created by TimeControl or you can define your own with whatever formatting, logos and graphics you wish.

3rd party report writers

Finally, TimeControl's data is an open structure and highly rationalized making it an ideal source for 3rd party report writers. Tables are linked by keys and this makes displaying them in a report writer very simple.

Report samples

Charge / Week Ending / Employee Hours Report TimeControl includes a number of pre-defined reports and allows a virtually unlimited number of user-defined reports. This report shows data summarized by charge number and week.

TimeControl includes a number of pre-defined reports and allows a virtually unlimited number of user-defined reports. This report shows hours and costs summarized by time period and employee for each charge code.

TimeControl includes a number of pre-defined reports and allows a virtually unlimited number of user-defined reports. This report shows a summary of hours and cost per project and within each project per charge code.

TimeControl includes a number of pre-defined reports and allows a virtually unlimited number of user-defined reports. This report shows the total hours and costs per employee and summarized per project and per charge code.

TimeControl includes a number of pre-defined reports and allows a virtually unlimited number of user-defined reports. This report shows the total hours and cost against each project scheduling system activity.

TimeControl includes a number of pre-defined reports and allows a virtually unlimited number of user-defined reports. This report shows the total hours and cost per resource code summarized by project. Since TimeControl supports a one-to-one and a many-to-one relationship between employees and project resources, this shows a summary of the information which would be translated back to the scheduling system if it were linked.

TimeControl is ideal for R&D Tax Credit report requirements. Here we see an example report showing a listing of employees showing their location and whether they are internal or contractors to be using in the R&D Tax Credit submission.

TimeControl is ideal for R&D Tax Credit report requirements. Here we see an example report showing the timesheet data for a particular month summarized by employee, by week, and by the number of hours for both eligible vs ineligible charges.

TimeControl is ideal for R&D Tax Credit report requirements. Here we see an example report showing the timesheet data for a particular month in a detailed fashion by employee, by week, by project, by task and by the number of hours for both eligible vs ineligible charges.