Selecting the column display

Choose the columns for your report from the attributes in all of the entities in the domain, and define the sort hierarchy.

About this task

The number of columns cannot exceed:
  • 30 string columns
  • 25 numeric columns
  • 6 text columns
  • 8 date columns

Procedure

  1. In the Columns to Display area, select the columns you want to appear in the report. The drop-down list contains all the entities in the domain.
  2. Click an entity to open a list of its attributes, select all the attributes you want from all of the entities, and click Add.
  3. Optionally select Distinct to display one-row-per-value in the report (there is one row in the report for each combination of the column values). This option yields condensed reports, but option can impact performance.
  4. Optionally select Count. The Count option adds a count column (#) to the report, with the number of occurrences of the set of values in any one row. This count can be used for sorting. When using Count, you can have up to 4 columns in the report, including count.
  5. Arrange the attributes in the order you want them to display in the report, using the up and down arrows. Top to bottom in the UI is left to right in the report.
  6. For each attribute, select what to print for the field: its Value, Count (number of distinct values), Min, Max, Average (AVG) or Sum.