Reporting in eTrack is powerful, customizable, intuitive, graphical and optionally ‘instant’. Many reports are available ‘out of the box’ and eTrack also comes with a built in report writer.
Reports can be exported to many different formats such as .XLS, PDF, HTML, TEXT for further manipulation or publishing. Alternatively, a standard SQL Reporting tool such as Microsoft Excel or Crystal Reports may be used. Large reports may be displayed instantly by scheduling them to run using the eTrack Event Service and viewing the stored results.
eTrack comes with many ‘out of the box’ Custom Reports which you can edit or develop your own using the built in Report writer.
The report gallery shows all reports relevant to the currently selected tree item that the logged in user has security to run. You can define your own report grouping and add business processes to the descriptions. Additional criteria can be selected and the result grouping defined.
The following is an example of a simple project summary custom report that was created with the built in Report Writer, with date range selection criteria and some simple result fields.
The same Custom Report can be run across the whole system or from various branches of the eTrack tree (eg. a portfolio, client, project, or person). Features include…
The report writer is completely integrated and easy to use. Existing custom reports can be copied and changed or new ones created. Security is all incorporated with a simple drag and drop. Features include…
The following shows a custom project report being designed in the eTrack Report Writer where you define selection criteria, result fields and security permissions. Additional selection criteria can be defined at run time that dramatically reduces improves performance of very large reports.
Standard reports can be run from many points in the eTrack tree hierarchy and have a selection criteria dialog allowing each to be run in various different ways. The result is a large number of possible reports. The results can be exported to many formats such as PDF, XLS, HTM, RTF (ie .doc).
For example, the Budget Report below has been run for all active Projects with the option to show a single line roll up of each Project. It shows hours and dollars for the original plan, the actual hours from the timesheet, estimates to complete (ETC), and the calculated forecast (actual+estimate) and variance (plan-forecast).
Or for example the Budget Report below has been run for one Project with the option to display all details including Stages, People and Roles, Equipment and Disbursements.
Another popular report is the Activity Report that shows all time booked by staff. The example below shows one row for every timesheet day booked by each staff member between selected dates for the Client Mr and Mrs Blogs. It has included options to show hours, comments, the charge rate and fee. Examples of how this report is used includes: