Skip to main content
Planview Customer Success Center

Creating Stacked List Reports

A "stacked" list report ("multi-column" in legacy reports) allows you to render field title-value pairs in columns. The values and titles can be auto-sized or fixed width, or a combination of both - you can even hide one or the other (technically you can hide both, but why??). You can also apply color to field labels and backgrounds.

Below are example stacked list reports that each show three rows of data. You configure the stacks in the Stacks section of the Display tab, described below.

1. Stacked list report, one stack (default)

title-value-pair.png

2. Two stacks - autosized, fields laid out left to right

stacked.png

3. Three stacks, auto-sized, fields laid out left to right, one "orphan" field spans the three stacks

stacked_auto_orphan.png

4. Three stacks, fixed widths, one "orphan" field wraps to column one and respects fixed width

2021-01-05_11-24-30.png

5. Three stacks (fields are project Title, Status, Description), all Titles hidden, Title fixed width, Status and Description auto-sized

2021-01-05_11-46-36.png

Setting up the Stack

  1. Create a new report, select the Topic and List:Stacked Type.
  2. Select fields in the Data tab and to the report.
  3. Click the Display tab and expand the Stacks section if not already open.
  4. Configure the stacks as described below.
2021-05-10_14-59-57.png

If you don't see the Stacks section on the report designer's Display tab, make sure you have selected the List:Stacked output Type on the General tab.

Number of Stacks - This setting controls how many stacks (or columns) to divide the title-value pairs into. You can have up to 4 stacks.

  • The columns populate left to right - if you have 8 fields and 4 stacks, fields 1-4 will render across the page, then fields 5-8 will render in the next row.
  • Note that if your number of fields does not divide evenly into the number of stacks, the "orphan" title/field will stretch to fit the space. For best results, either make sure your numbers are even, or use a fixed width (see below) for the Title and Value of each stack (see below).

Adjusting field width

You adjust the column width of the field titles and values. The Stacked section displays a row for the title and the value for each stack.

  • 1:Title and 1:Value represent the title/value pair in the first stack; 2:Title and 2:Value the second stack , and so on. 
  • The Width is set to Automatic by default. Automatic means that the system will evenly divide/space the fields and their titles. 
  • Setting Fixed Width to 0 pixels hides the title/value. See example above.

Label text color - Choose the color of the text

Label background color - Choose the background color

Hint: pick contrasting colors :)