Add Tables to Report Designs

Create a report design file.

Tables are at the heart of most report designs. They lay out information in row and column form but they're more than simple grids - tables iterate through all the data rows that a data set returns. Tables are typically used to display multi-instance object field values.

To add a table to your report design, drag the

Table

item from the

Palette

view to the required position in the

Layout

tab of the main view.

From the

Data Set

drop-down list, select the data set that contains the columns you want to bind, then select the columns. You can adjust the table's binding on the

Binding

tab of the

Property Editor - Table

view. By default, a table returns all entries within a data set.

Specify the number of columns and details rows that you want to see in your table.

(Optional) Specify the order your results are returned in on the

Sorting

tab of the

Property Editor - Table

view. You can use any field in the data set bound to the table as a sorting key. The sorting field doesn't have to be part of the table's output.

(Optional) Specify 1 or more conditions that must be met for an entry to be output in a table on the

Filters

tab of the

Property Editor - Table

view. If you specify multiple conditions, the entry is only returned if they evaluate to true.

(Optional) Adjust the appearance of your table's cells on the

General

tab of the table's

Property Editor

view. Table cells have no default height or width values. Workday recommends that you don't impose any. Adding height and width values can cause the generated PDF to have unwanted line breaks.

If you add a table within a table, avoid truncation of values by ensuring that the column width of the outer table is greater than the column width of the inner table.

(Optional) Improve readability by assigning a color to every other table row. On the

Highlights

tab of the

Property Editor - Table

view:

In the

Condition

section, specify

row.__rownum%2 Not Equal to 0

Select the

Background Color

of your choice.