United States Department of Agriculture
Natural Resources Conservation Service
National Water and Climate Center Go to Accessibility Information
Skip to Page Content
National Water and Climate Center

 

Change Column Order

This tutorial shows how to change the order of the columns in a report in Report Generator. The example moves the metadata element HUC to the top of the order. The final report will therefore display the HUC as the first item in the report, followed by air temperature average and air temperature maximum.

Note: If you're continuing this tutorial from the Add a Metadata Column tutorial, go to Lesson 2: Change order of data types.

Lesson 1: Add data types

  1. Start Report Generator.
  2. Select the Create/Modify Report tab
  3. Add a station. In the Select Stations Enter station(s) field, enter 526. The Hogg Pass station is added to the Selected Stations list.
  4. Add an element. In the Select Columns pane, select the Data tab.
  5. Under Element, select "air temperature maximum."
  6. Under Depth, select "None."
  7. For Value Type, select 'Value."
  8. For Function, select "None."
  9. Select the Add button to add the element to the Manage Selected Columns list.
  10. Add a second element for the previous year. Under Element, ensure "air temperature maximum" is selected.
  11. Under Depth, keep "None"
  12. For Value Type, select "Previous Year's Value."
  13. For Function, select "None."
  14. Select the Add button to add the element to the Manage Selected Columns list.
  15. Add a metadata element. In the Select Columns  pane, select the Metadata tab.
  16. Under Metadata, select Hydrologic Unit Code (HUC).
  17. Select the Add button.

The display should look similar to the following.

Lesson 2: Change order of data types

  1. Enable the checkbox next to the HUC Data Type.
  1. Select the Move Up button. The HUC data type will move up one level in order.
  2. Select the Move Up button again. The HUC data type will move to the top of the list, and will therefore appear first on the final report.

Note: The previous result could have also been obtained by enabling the checkboxes next to the first two data types, and then selecting the Move Down button.

This completes the Change Column Order tutorial.

Proceed to the Remove Columns tutorial