Overview
The Columns page for a report is where you specify the data fields to be shown in the report, and in what order. 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 save scrolling through a long list of fields, you can type any part of a field name in the Filter text box. That’s a predictive search that 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; that’s the order in which columns will appear in the report. You may also opt to turn off the default setting to Show row number in first column of exported report formats. The row number is used mostly to provide a navigational aid for users.
Select and Re-Order Data Columns
- Available Data Fields are listed on the left.
- Use the arrow controls to move fields to the Selected Data Fields list on the right.
- To save scrolling, type part of a field name in the Filter text box. The search limits the list to matching fields.
- The order in the Selected Data Fields box determines the column order in the report.
Show Row Number
- You may turn off the default setting to Show row number in the first column of exported report formats.
- The row number is used mostly to provide a navigational aid for users.
Sort Order
- You can specify up to four fields on which to sort report data in ascending, descending, or a custom order in this area.
- The first field takes precedence over those that follow it.
- Pick the field you would like to sort on and choose Asc (A-->Z), Desc (Z-->A) or Custom (see-->). To specify the order for the sort.
- When Custom (see--> ) is selected, a separate text window appears to the right of the sort order drop-down.
- In this text field enter your custom sort criteria, separated by commas for multiple criteria.
- Example: First, I want to sort by Category in neither ascending nor descending order.
- Secondly, I want my report to sort by Last Name within each Category.
- Order By: "Category", Sort Order: "Custom (see-->)", in the text box enter: DEANS,SPEAKERS,PARTICIPANTS,CONFERENCE SUPPORT STAFF
- Order By: "Last Name", Sort Order: "Asc (A-->Z)"
- The report will sort results first by the custom sort order, based on Category (Deans, then Speakers, then Participants, then Conference Support Staff) and within each category the rows will be sorted by Last Name.
Customize Report Columns
- Click the Customize Reports Columns button to customize the column headers/labels in your report.
- The Customize Reports Columns window displays the system-generated column headers under Default Column Label.
- If a column in your report is a Date-based field then the Column Format section will display a drop-down for you to select a specific Date format for that column in the report.
- To modify the column headers on the final report:
- Enter new column labels under Custom Column Label.
- If the column is a Date-based field, specify the date format under the Column Format drop-down.
- When finished, click Submit or Submit and Close to save your changes.
- Click Run Report to see the results or continue customizing the report.
Note
- If you designate a report as a Changes Report you cannot edit the report columns after the report has been "locked".
Was this article helpful? 0 out of 0 found this helpful
Have more questions? Submit a request
Comments 0 comments Please sign in to leave a comment.