Get started with reports

Reports provide visibility into what is happening with users and work. Using reports, you can display information about objects in Adobe Workfront.

For information about understanding objects and how they can be reported on in the Workfront application, see Adobe Workfront objects overview.

Report elements

Reports are a combination of the following three elements in Workfront:

View
Grouping
  • Categorizes information based on a common piece of information and lists the results of the report under headings.

  • For information about groupings, see Groupings overview in Adobe Workfront.

Filter
  • Controls the amount of information that appears in a report.

  • For information about filters, see Filters overview.

  • For information about filter modifiers, see Filter and condition modifiers.

  • You can filter by using wildcards, to make your filters more general and give them more flexibility of usage.

  • For information about using wildcards in filters, see Wildcard filter variables.

NOTE
When you select a new filter, view, or grouping from a list, that selection is retained even if you log out of Workfront or close your browser.

For information about report elements, see Reporting elements: filters, views, and groupings.

To enhance your reports, you can add the following elements:

  • A chart: a visual representation of the results in your report.
    For information about chart reports, see Add a chart to a report.

  • A matrix grouping: summarizes the information of the report in an aggregated table format.
    For information on matrix reports, see Create a matrix report.

  • A prompt: an open filter that you can customize and apply differently every time you run the report.
    For information about prompts, see Add a prompt to a report.

When building a report, you can modify any of these elements individually in the report builder.

Another way of enhancing the relevance of the information included in your reports is by applying conditional formatting to your views.
For information about using conditional formatting, see Use conditional formatting in views.

System reports

Workfront provides several system reports that come loaded in your system by default.
After entering information in your system you can use these reports to display the information visually.

For more information about how to access system reports and which system reports are available, see Use Adobe Workfront built-in reports.

Create reports

In addition to the system reports that Workfront provides, you can create your own customized reports to meet the needs in your organization.

To create a report you can do one of the following:

  • Build a report from scratch.
  • Copy an existing report.
    You must have at least View permission to copy a report created by someone else. For more information about copying a report, see Create a copy of a report.

For information about creating reports, see Calendar reports overview.

Prerequisites for creating reports prerequisites-for-creating-reports

  • You must have a Plan license (current licenses) or Standard license (new licenses) to create your own reports.
    For information about the Workfront license types, see Licenses overview for the current licenses, and New licenses overview for the new licenses.

  • Your Workfront administrator must give you access to Edit Reports in your Access Level.
    For information about granting access to Edit reports, see Grant access to reports, dashboards, and calendars.

  • Your Workfront administrator must give you access to Edit Filters, Views, and Groupings in your Access Level.

    For information abut granting access to Edit filters, views, and groupings, see Grant access to filters, views, and groupings.

  • You must define one object that you want to report on. Reports are object specific in Workfront and you must start with selecting an object type before you can start building the report. You can only report on objects available in the Workfront interface.

Report ownership report-ownership

When you create a report in Workfront, you become the default owner of the report and it displays in your My Reports section. You cannot change the owner of a report.

When you copy a report, you automatically become the owner of the copied report.
For information on copying reports, see Create a copy of a report.

You can see who owns a report by reviewing the Entered By field.

Entered By field

Create reports in the builder interface create-reports-in-the-builder-interface

We recommend that you use the report building interface first to build a new report. The interface offers a streamlined set of tools that walk you through putting elements together to create the report you want. You have objects and fields that you can select from lists and add to all your reporting elements.
For more information about creating reports in the report building interface, see Create a custom report.

For a list of objects that you can report on, see the Report on objects section in the article Adobe Workfront objects overview.

For more information on the fields that you can display in reports, see Glossary of Adobe Workfront terminology.

Create reports in Text Mode create-reports-in-text-mode

At times, you might be not able to find certain fields in the builder interface, but they might be available in the API.
For information about what fields are available in the API, see the article API Explorer.

For information about how to use the API Explorer, see the article Using the API Explorer.

NOTE
You cannot report in the Workfront interface on objects that are not available in the report builder. However, you can report on fields associated with the objects in the report builder if those fields are available through the API. To do this, you must use the Text Mode interface.

Text Mode enables you to create more complex views, filters, groupings, and prompts by allowing you to use fields that are not available in the standard mode interface.

Text Mode terminology text-mode-terminology

You must use a specific syntax to use the Workfront Text Mode interface.

For more details about the Workfront syntax for text mode, see Text mode syntax overview.

Calculated Columns, Conditional Formatting, and other uses of Text Mode calculated-columns-conditional-formatting-and-other-uses-of-text-mode

Outside of reporting on fields that are not available in the builder interface, you can use Text Mode to display calculations or comparisons between certain fields.

For a list of the most common uses of Text Mode in a report, see Overview of common uses for Text Mode.

For information about including calculated custom data in reports, see Calculated custom data in reports.

For information about comparing fields in conditional formatting, see Compare fields in conditional formatting.

You can also refer to collection fields using Text Mode in reports.
For information about using Text Mode to display collection information in a report, see Reference collections in a report.

Text Mode samples text-mode-samples

We have a library of samples of the most used views, filters, and groupings you can create with Text Mode.

To browse this library and use some of the samples we offer, see the article Custom view, filter, and grouping samples: article index.

The tabs of a report

A report can contain several tabs when you run the report in the interface.

For information about running a report, see the article Run a report.

On each tab, the information you include in the report displays in slightly different formats. Choose the format that best fits the needs of your organization.

You can make any tab the default tab of the report. The default tab is the first tab that displays when you click the name of a report to open it, and it is the tab that displays when you place the report on a dashboard.

Details tab details-tab

The Details tab of a report displays the object of the reports and the attributes that you choose for that object in a list form. Every report has a Details tab.

IMPORTANT
Information in the Details tab may display differently from the Chart tab based on your time zone.
For example, a user in California completed a task at 9:30 pm PST on February 12. When a user in New York views a report that includes this task completion, the Actual Completion Date displays as February 13 in both the Details tab and the Chart details because it was completed at 12:30 am EST on February 13. However, in the chart, it is included in the February 12 grouping until you expand the chart element.

Summary tab summary-tab

Reports that include a grouping have a Summary tab.

The same information displayed in list format on the Details tab is summarized and aggregated according to the groupings in the report on the Summary tab.

For information about groupings, see Groupings overview in Adobe Workfront.

Matrix tab matrix-tab

Reports that include a Matrix Grouping have a Matrix tab.

The same information displayed in list format on the Details tab is displayed in a table format, grouped by the groupings in the report on the Matrix tab.

When you add a Matrix grouping to a report, the Summary tab is replaced by the Matrix tab.

For information about building a Matrix Grouping, see the article Create a matrix report.

Chart tab chart-tab

Reports that include a chart have a Chart tab.

Consider including a chart in your reports for impactful dashboards for your executives. Charts are a concise way to display the information in a report. You can expand a chart element by clicking it to display the items included in that element.

IMPORTANT
When you click a chart element, the expanded information may display differently from the chart based on your time zone.
For example, a user in California completed a task at 9:30 pm PST on February 12. When a user in New York views a report that includes this task completion, the Actual Completion Date displays as February 13 in both the Details tab and the Chart details because it was completed at 12:30 am EST on February 13. However, in the chart, it is included in the February 12 grouping until you expand the chart element.

For information about building a report with a chart, see the article Add a chart to a report.

Prompts tab prompts-tab

Reports that include a prompt have a Prompts tab.

A prompt allows you to add a filter to a report every time you run the report. When you add a prompt to the report, the Prompts tab becomes the default tab of the report automatically. This cannot be changed to another tab.

For information about building a prompt for a report, see the article Add a prompt to a report.

Share reports

After you create a report, you can share it with other users.

Give sharing permissions to a report give-sharing-permissions-to-a-report

You can give sharing permissions to another user to View or Manage a report you create. You can give another user a level of permissions equal or lesser than yours. You can also make a report public using sharing permissions. For information about sharing a report, see Share a report in Adobe Workfront.

Schedule a report delivery schedule-a-report-delivery

You can schedule a report for delivery. The users you are sharing the report with receive an email with an attachment of the report results. The attachment can be in the following formats:

  • HTML
  • PDF
  • Excel
  • .TSV

For information about scheduling a report delivery, see Report delivery overview.

Export the results of a report export-the-results-of-a-report

You can export the results of a report to the following file formats:

  • PDF
  • Excel (.xls and .xlsx formats)
  • Tab Delimited

For information about exporting the results of a report, see Export data.

After the report is exported to one of these formats, you can share it with other users by emailing it as an attachment or printing it.

Add a report to a dashboard add-a-report-to-a-dashboard

You can add a report to a dashboard and share the dashboard with other users. For information about adding reports to a dashboard, see Add a report to a dashboard.

Create calendars

If you want to display your data in a calendar format, you can create calendars instead of reports.

For information about building and using calendars, see Calendar reports overview.

Report usage

After creating reports and sharing them with other users, you can track how often they use these reports.
For information about report usage, including how often they are viewed, by what user, and what dashboards they display on, see the article Report usage overview.

Common terms used in reference to reports

The following terms are used in reference to Workfront reports:

Term or Phrase
Definition
Advanced Options

Refers to the link on the Columns (View) tab of the report builder that provides the ability to do the following:

  • Set column conditional style formatting of text and images based on criteria you select.
  • Relabel your column.
  • Format the values in your column.

For example, you may want to show all parent tasks in bold, or you may want to display the Planned Completion Date in red if the task is late.

Attribute
The field of an object as defined in the database. It is used in a Text Mode expression.
For example, the Status field is displayed as status when used in a Text Mode expression.
Bean or JavaBean
A Bean represents a reusable-programming element. The term Bean identifies relationships between different objects in the Workfront application. It is important to be familiar with these relationships as you attempt to display additional attributes about an object that are not available in the basic reporting tools.
Builder Interface or Report Builder
The Builder Interface is the series of drop-down menus containing fields displayed in the Columns (View), Filter, and Grouping tabs. It provides an intuitive mapping of the Bean relationships to assist in identifying the columns in a view, the criteria of a filter, and the common attributes of a grouping.
Camel Case

Camel Case refers to a specific way to write programming elements to string multi-word attributes together. When spelling an attribute in Camel Case, the first letter of the first word is lower case, there is no space between the words, and the first letter of any subsequent word is uppercase.

For example, Home Group would be written as homeGroup, Resource Pool would be resourcePool, and Actual Start Date would be actualStartDate.

Chart

A tab inside the report builder, a report tab, after you save the report, as well as an optional element of a report which allows you to add a chart to any report. You must define a Grouping in the report before you can create a chart.

The following are types of charts that can be added to any report:

  • Column
  • Bar
  • Pie
  • Line
  • Gauge
  • Bubble

For more information about adding charts to reports, see the article Add a chart to a report.

Details
This is one of the tabs of a report, after you save the report. It displays the findings of your report, displayed in the view and grouping of your choice.
Expression
An expression is a written formula in Text Mode to convey information to be searched for or displayed when using the Text Mode interface. It is typically one line in a larger Text Mode statement.
Fields

Refers to the attributes of your objects. For example, "Status" is a field for Projects, Tasks, or Issues. "Portfolio Manager" is a field for the Portfolio object.

You can also have custom fields that you create yourself and add to custom forms.
For information about creating custom forms, see the article Create or edit a custom form.

Field Name
The value of an attribute that is displayed in a view, or used in the condition of a filter, or as the common element of a grouping. The options for the Field Name are dependent on the Field Source selection.
Field Source
The value of an object that is displayed in a view, or used in the condition of a filter, or as the common element of a grouping. The options in the Field Source are dependent on the object type of the UI element being created. The Field Source allows you to reference attributes from objects other than the object type of the UI element.
Filter
A main report element that determines which results display in the report.
Form
Used interchangeably with "Custom Form." Fields and sections are added to forms, which are then attached to an object to extend the number of fields you can associate with an object.
Grouping
A main report element that identifies how a list of results is organized. The grouping creates horizontal bars throughout the report to group the results by common attributes defined when creating it. Groupings are used in Matrix Reports to aggregate data, as well as in charts, to determine the axes of charts.
Object or Object Type
An object is a Workfront application element (for example, Project, Task, Group, Company, Filter). The Object Type is used when creating a new report, view, filter, or grouping to identify which object is the focus of the report. Reports can have only one object type, which is the main object of the report.
Parent objects may be referenced in the same report.
For more information about the hierarchy of objects, see the section "Understanding the Interdependency and Hierarchy of Objects" in the article Adobe Workfront objects overview.
Prompt

An optional report element that can be added to a report when you need to use a different filter every time you run the report.

For information about prompts, see Add a prompt to a report.

Qualifier or Condition Modifiers

This field appears in the following areas of a report:

  • On the Filter tab

  • The Advanced Options screen for the column in the Columns (View) tab. By defining a qualifier, you can compare the Field Name to another field or value.

  • In a Custom Prompt

    For information about prompts, see Add a prompt to a report.

    .

For example, when building a filter for tasks with a Planned Completion Date of Today, you would select Equal in your Qualifier field, and today's date in the Date field:

Task> Planned Completion Date>Equal>(today's date)

In this scenario the Qualifier is Equal.
For more information about qualifiers, see the article Filter and condition modifiers.

Report
The combination of a view, a filter, and (sometimes) a grouping. The purpose of a report is to display data consistently across the interface, to distribute information, and to eliminate the need to run the same search or query on a regular basis.
Statement
Consists of several expressions that are put together to define what information displays in a report when using Text Mode. A statement can be created for a view, filter, grouping, or for a Custom Prompt in a report.
Summary
This is one of the tabs of a report, after you save the report. This tab is created only when you define a grouping for the report. It summarizes information based on the grouping defined during report creation and gives a quick overview of the aggregated objects of the report. It does not display every object in the report, just those that are aggregated.
Text Mode Interface
Provides the ability to create or modify the code of custom views, filters, groupings, and prompts originally created through the Builder Interface. It is suggested that report elements are initially created through the Builder Interface and then converted into the Text Mode after they have been saved to simplify the coding of advanced views, filters, groupings, or prompts.
User Interface (UI)
Refers to the components or building blocks of what displays on the screen of a user at any given time.
View (or Columns)
One of the main elements of a report. It identifies the column headers that will be displayed in the list of a report.
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43