Overview

Reports column headings may not be the terms used in your business or institution, and the ordering may not be the structure you want for easy interpretation and analysis. To 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, Report Builder will allow you to rename and reorder fields. The renamed column names will appear in your output report headings, and their ordering as you specified.

Workflow

Status
colour Green title 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.selected fields, go to the below section for you to rename and reorder the fields.

Image Added

Status
colour Green title 2

Edit the necessary column names you want to appear in your report headings. The column on the left (Custom Field Name) contains the current or original field names in the system. You have the option to rename this section by entering or typing a new name (the way you want them to appear on your report output). While the Original Field Name column in the middle will give you the system field names in instances where you will rename the fields on the left for the purpose of reporting.

Example: from the original field names (Full Name and Enrolment Status Code), you renamed these fields to just (Name and Enrolment Status). Note that in the middle column, it will still give you the original field names of the fields that you’ve renamed.

Image Added

Status
colour Green title 3

Reorder or organise the columns (data or information) the way you want them to appear in your report output (e.g. First Full Name 4 field on top, would mean seeing all first full names data in the fourth first column of your report). To reorder the column headings, edit click the up and down arrows under the Order Number column.

Image Removed

column, or you can drag and drop the field name by clicking on the button before each field name, drag and drop it to your desired sequence.

Image Added

Output Format (based on the screenshot above):

Image Removed InfoINFO: sample above made from the Report Column Name and Order Number columns to the screenshot below.Image Removed

Edited Output Format (based on the edited column names and order number as shown in the screenshot above):

Image Removed

 

Image Added

Status
colour Green title 4

Click the UPDATE REPORT COLUMNS button once you’re happy with your field names and order.

Image AddedRenaming_Reordering_Fields.mp4

Status
colour Green title 5

Proceed to the next page for the for the next workflow or instructions.

---

---

_{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}