Specifying Report Columns
The Columns page for a report specifies the data fields to be shown in the report.
Select and Re-order Data Columns
Available Data Fields are listed on the left.
Using the arrow controls, select fields there and move them to the Selected Data Fields list on the right.
To limit the list to matching fields, type any part of a field name in the Filter text box.
Click the right-arrow symbol to move selected items to the right.
Click the left-arrow symbol to move selected items to the left.
Click the double-right-arrow to move all items to the right.
Click the double-left-arrow to move all items to the left.
Click Top to move a field to the top of the list.
Click Bottom to move a field to the bottom of the list.
Click Up to move a field upward in the list.
Click Down to move a field downward in the list.
This determines the order in which columns will 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
You can specify up to four fields on which to sort report data in ascending or descending order.
The first field takes precedence over the others.
Pick the field you would like to sort on.
Choose Asc (A->Z) or Desc (Z<-A) to specify the order for the sort.
Customize Reports Columns
Click the Customize Reports Columns button at the lower left of the Columns page.
This action customizes the column headers in your report.
The Customize Reports Columns window lists the columns saved in Selected Data Fields.
The window displays the system-generated standard column headers under Default Column Label.
To modify the column headers on the final report, enter new column labels under Custom Column Label.
Click Save (or Save and Close) to save your changes.
Click Run Report to see the results or continue customizing the report.
Was this article helpful? Yes No
Have more questions? Submit a request
Comments 0 comments Please sign in to leave a comment.