Report types

Report definition reports

A report definition rule defines a report definition report. Because of the ease-of-use of report definition rules, managers can create, share, modify, and schedule report definition reports with little or no assistance from application developers.

The two types of report definition reports are summarized reports and list reports. List reports display unsummarized or detailed data about individual cases or other data instances. Summarized reports display summary counts, totals, or averages, and you can drill down to supporting information. Summarized reports can also contain charts.

Summarized reports contain two types of columns. At least one column must be a summarized column, which contains data that is summarized by using one of the following built-in functions:

  • COUNT()
  • COUNT DISTINCT()
  • SUM()
  • AVG()
  • MIN()
  • MAX()

Examples of summarized columns include counts of class instances (or record counts) , total dollar amounts, average elapsed time between the start and resolution of a work item, the most recent (maximum) date value, and the earliest (minimum) date value.

Columns that do not contain summarized data are group by columns. The group by columns organize the summarized data. For example, you can display summarized values based on numeric properties.

The columns in reports can contain either property values or the values of expressions that contain SQL functions.

To simplify assembling data from several classes, or to satisfy complex conditions, you can designate subreports within report definition reports. A subreport is a report that is called by another report to provide data. When you designate a report as a subreport, the original report is not altered, and you can still access it. However, a subreport cannot have its own subreports.