Pick Report Columns (Data Fields) [Supplier Reports]

Pick Report Columns (Data Fields) [Supplier Reports]

Specifying Report Columns

The Columns page for a report is where report data fields are specified for display in the report, and the order of those fields.

Select and Re-order Data Columns

To save scrolling through a long list of fields, a field name can be typed in the Filter text box. The Filter text box limits the list to matching fields.

• Click » or « to move selected items to the right or left.
• Click »» or «« to move all items right or left.
• Click Top, Bottom, Up, or Down to change the position of a selected field in the Selected Data Fields box. The position sets the order in which columns appear in the report.

Select the Show row number in the first column of exported report check box to include a row number column in exported reports.

Sort Order

Report data can be sorted by up to four fields in ascending or descending order. The first sort field takes precedence over the following sort fields.

Select the field to sort on. Choose Asc (A->Z) or Desc (Z<-A) to specify the sort order.

Customize Reports Columns

Click the Customize Reports Columns button at the lower left of the Columns page to customize column headers in the report.

The Customize Reports Columns window lists columns saved in Selected Data Fields. The window displays system-generated standard column headers under Default Column Label.

To modify the column headers on the final report: 1. Enter new column labels under Custom Column Label. 2. Click Save (or Save and Close) to save changes. 3. Click Run Report to see results or continue customizing the report.