Overview

Report generator is a tool to produce custom reports. Think of a custom report as a set of bricks you put together in any combination to produce a desired report. Additional aids are filters and other options, such as Hide, which allows you to hide a column on a report. Any report can be made available on the Dashboard. See below for details. Reports can be generated in four formats:

• Table,
• Bar chart,
• Pie chart, or
• Metric

Once generated, a report can be exported as a PDF, Excel, or CSV file. Direct sending to a printer is also available.

Creating a custom report

Take these steps to create a custom report:

1. Click Reports on the main menu.
2. Click + Add report.
3. Give a name to the report.
4. To start adding fields to your report, first choose the data source from the "Generate report from" dropdown list. Think of a data source as a pool of interlinked data fields. For example, the "All activities (hierarchical)" data source offers a full assortment of activity- and project-related fields and allows producing reports with a hierarchical view of activities.
5. Select report type: Table, Bar chart, Pie chart, or Metric.
6. To have the report displayed on the Dashboard, select Make available on Dashboard.
7. If you'd like to include an archived project, select Include archived projects.
8. In the "Key Information" section, click + Add field to start adding fields to the report from a drop-down menu. To quickly find a field, in the "Type to search" field type a field name, for example, "Project name".
9. For the Table report type only: select a value in the "Filter" selector (default option: none): None, Prompt for a single value, or Prompt for value range. Select other options: group, hide, or sum (for metric values). These options allow you to group items by certain fields, hide fields used as filters, or calculate totals of metric items. Set the appropriate column size: auto, small, medium, or large.
10. For Bar chart or Pie chart: select an option in the "Axis" selector (default option: none): None, Value, Category. Select an option in the "Function" selector (enabled when Value is selected in the "Axis" selector). Select a value in the "Filter" selector (default option: none): None, Prompt for a single value, or Prompt for value range.
11. Click "Save" to save the report. Or, "Save & Run" to save and run the report.

Duplicating custom reports

To duplicate a report:

1. Open the report you want to copy/duplicate for editing (see Editing a custom report).
2. Click the "Copy" button at the bottom of the report edit panel in the right-hand half of the screen.
3. A copy of the report will appear on the left side of the custom report page with the word "Copy" appended to the original name
4. You can rename the copy by clicking the pencil icon next to it and editing the name in the report name box at the top of the report edit panel. Complete the renaming process by clicking the "Save" button.

Drag and drop

As data in a report is sorted column by column from left to right, you can use drag and drop to arrange the sequence the fields are ordered. To do that, place the mouse pointer on the "handle" of a row (thick dotted vertical bar on the left end of the row), take hold of it by keeping the left mouse button pressed, then drag it to a new position on the list, and, finally, drop it there by releasing the button. It is shown in the illustration:

Exporting a report to a selected format

As soon as a report is generated, you can export it to Excel, PDF, or CSV.

To export a report:

1. Click Export on the toolbar.
2. Select the format you want to save the report in (available formats include: PDF, Excel, and CSV). 
3. The report will be converted to the format selected and downloaded into your default downloads folder.

Printing a report

You cannot print out a custom report from the preview screen. To print a report, you need to export it to an appropriate format first. See how to export a report above. 

Making reports available on the Dashboard

1. If you select the "Make available on Dashboard" checkbox before saving a report, it will be available for anyone to choose from the “Widgets” section on the Dashboard page, as shown in the illustration.
2. Alternatively, mark the report visible on the Dashboard on the report list. To do so, click the checkbox in the "Published" column.