Overview

Renaming and reordering fields will present the data in the desired format including any naming localisations to remove the need for manual manipulation of the data prior to its use in supporting business decision making. The renamed column names will appear in your output report headings, and their ordering as you specified on this section.

Workflow

NOTE: The instructions below assume the following:

That you have already chosen a base or saved report and is already loaded in the system. If this is not the case, refer to the Step 1 - Select a Base Report instructions; and
That you have already selected the columns (data or information) you want included in your report output. If not, refer to the Step 2 - Add and Remove Fields instructions.

1 With all your chosen columns (data or information) added, in the table where you can see all the system and report column names, and their order number, go to the second column called Report Column Name.

2 Edit the necessary column names you want to appear in your report headings.

3 Reorder or organise the columns (data or information) the way you want them to appear in your report output (e.g. First Name 4, would mean seeing all first names data in the fourth column of your report). To reorder the column headings, edit the Order Number column.

Output Format:

INFO: Given the sample screenshot above, notice the changes made from the Report Column Name and Order Number columns to the screenshot below.

Edited Output Format:

_{Introduction to Report Builder}_|_{Step 1 - Select a Base Report}_|_{Step 2 - Add and Remove Fields}_|_{Step 3 - Rename and Reorder Fields}_|_{Step 4 - Add Filter Clauses}_|_{Step 5 - Save Report}