Adding and modifying content
While the Results section is populated when a query is run, a Table section is initially blank with no columns added. Columns are added and rearranged in a table and results by manipulating the columns shown in the Data Layout of the section. The Section Title Bar controls toggling the Data Layout, Filter, and Sort lines of the table and results section by clicking on the button in the bar to show or hide the window. The following screenshot shows the Section Title Bar buttons for a Table and Results Section:
Data layout
The Data Layout line drives the order of the columns in the section. The column order of the Results section is initially set by the order of the columns in the Request line of the query before the first process. After a query has been processed for the first time, new columns added to the query appear at the end of the Results section regardless of where the columns are added in the Request line. In addition, columns modified in the Request line...