Column Headings

Data Source: Not Applicable

To open the Column Headings screen, click a column name on the Columns tab.

The Column Headings screen allows you to edit, add to or change the heading on an existing column, create a group and total number fields.

The following fields appear on the Column Headings screen:

Field Description
Heading 1, 2, and 3 Use the heading 1, heading 2 and heading 3 to customize what you would like to have shown on the top of the column.
Total

Tells the program to tally the column.

Note:  
The total field only appears if the field selected is a numeric field. Also, if the Break on Change field is used, the system will show sub-totals at each break as well as a final total on the bottom.
Break on Change

Will cause a break (blank line) to appear when the value in this column changes.

Note:  
It is recommended that you make sure you sort the report by the field(s) selected for break.

Alignment

The alignment in which the data for this column will be presented once a report is generated for the query; either Left, Center, Right, or Default (right-aligned for numbers, left-aligned for characters).

Note:  Alignment settings are applied to any subtotals or totals in the selected column and will be carried over if the selected query is ported to a Microsoft Excel file.
Format

Note:  This field will not appear if the system determines that the data being generated in the selected is neither a dollar value or date.

The format in which the data for this column will be presented once a report is generated for the query. Depending on the type of data being generated, the formatting options will vary:

  • If the system determines that the data being generated is a date, the following format options are available:
    CCYY/MM/DD or CCYY/MM
    MM/DD/CCYY or MM/CCYY
    DD/MM/CCYY or MM/CCYY
  • If the system determines that the data being generated is a dollar value, the following format options are available:
    $-X,XXX.00
    $X,XXX.00 CR
    -X,XXX.00
  • If the system determines that the data being generated is neither a dollar value or date, no formatting options are available.

Note:  Format settings are applied to any subtotals or totals in the selected column and will be carried over if the selected query is ported to a Microsoft Excel file.

The following buttons allow you to complete your work on the Column Headings screen.

Button Function
Save Saves changes made to the Column Headings screen.
Close Closes the Column Headings screen and returns to the Columns tab.