Skip to main content
Planview Customer Success Center

Layout/Editing List Reports

You can configure list report data right in the Preview pane. Once you add some fields to your list report definition and save, the report Preview pane will be visible from any tab (General, Data, Display, Scope & Filters, Team). You can enter a Container Title for a list report on the Display tab, but all other configuration takes place in the Preview pane.

You can choose columns to display, drag columns to reorder and resize them, choose sort fields (up to 3), as well as configure specific settings to control max/min width, data wrapping, sorting, and alignment. In addition, there is an extensive menu of date formats, and the option to show/surpress decimals for float fields.

The configuration controls are located in the column header menu. Hover your cursor over the down arrow and click to display the menu, as shown below:


Column Header Menu Setting Description


Sort Ascending 

Sort Descending



Choose the sort column and sort order by clicking on the menu icon of the column you want to designate as a sort column and choosing Ascending or Descending.  A numeric indicator in the column header tells you which columns are in use for sorting and in what position - 1, 2, or 3. Up to 3 columns can be sort fields. (See screenshots to the left.)

Ordering a multi-column sort can be a little tricky - you need to select your tertiary and secondary sort fields (if using them) before you select your primary sort field (the last column you click will be your primary sort field). If you want to change the primary sort field you'll need to start from the 2nd or 3rd column and work toward your left. Or, if you want to remove a field from the sort order altogether, remove the field from the report and then put it back on.

Note: Sorting by lookup list fields uses the sequence number of the list item - in other words, the sort goes in the order of the items in the list, and not alphanumerically. This was the default behavior in legacy requests; other sort options, such as alphanumerically, coming in later releases. Text and string fields are sorted by field value.

Show Columns


Click the Show Columns menu icon to display a submenu that lists all the available columns defined for the report. Enable the checkbox next to any column you wish to appear in the list report.

If you want to add/delete columns, go to the Data tab and add or remove fields.


Change Display Name

You can double-click into a column heading and edit its label, or you can select Change Display Name to explicitly make the column label editable, then delete or type over the existing name. This is what a header looks like after you double-click it or choose Change Display Name:


Change Width or Wrapping


You can drag fields to resize them or you can impose limits on how a column can be resized and how wide the column can be, as well as whether or not the column data should be wrapped.

Column Width settings:

  • Automatically resize based on report window size - Space that is not allocated to fixed width columns will be divided equally among columns that automatically resize when you increase or decrease window size.
  • Fixed (resizeable in Preview only): # pixels - Enter a value for a fixed field width. Note that in the Preview pane you can still drag to resize - the "pixels" field will reflect the size you manually sized the field and when the report is rendered that will be the fixed size limit.
  • Resizable: - Allows you to set the minimum and maximum size of the field. When this option is selected, dragging to resize is limited to the min/max values. 

Column data wrapping settings:

  • Automatically wrap based on column width - Wrap field data according to Column Width size set above
  • Truncate (do not wrap) - Shows ellipsis close to column width boundary, which indicates there there is more text that is not shown
Align Horizontally

Justify column field data Left, Center, or Right.

Align Vertically Align column field data vertically Top, Middle, or Bottom

Display Data As

Lookup lists can be assigned a color and/or an icon for each a list value. When using a lookup list in a report that is configured to use color/icon, you can choose the visual treatment to apply to the list field value by configuring the "Display Data As" setting. Note that Pie charts and Column charts automatically use any lookup list color assignment.

The Display Data As options are shown below, along with an example of each:

  • Value Only

  • Value on top of Color

  • Colored Value

  • Color Only

  • Icon Only

  • Colored Icon

Export Data/Color As

If you plan to export a report that makes you of list values that render color and/or icons, lets you specify how to treat the value/color when exporting. Options are (see Display Data As, above, for examples):

  • Value Only
  • Value on Top
  • Colored Value
  • Value Only