Click on the desired tab when appears for information about that program tab.

Main Column Definition Query Sort Print

The Column Definition tab of the Report Writer window is the "heart" of the report definition. This is where columns and formulas are defined. Each report can consist of up to 200 columns that are user defined. Rows always represent one client record. The number of rows depends on the number of clients you have in Tabs3. Each column will be either a field from the Tabs3 Data or a formula line. This tab includes the Tabs3 field used for the column, a formula if the column is a formula column, the width of the column, the column headings, the subtotaling prompt, the option to leave amounts blank when zero and whether to print on the primary or secondary subtotal line. Not all fields are available for all columns. The fields that are displayed depend on the type of column being defined.

Field Hold/Print
Print on Report Transactions
Col. Width Tcode
Header 1 Timekeeper
Header 2 Timekeeper Level
Left Indent Category
Subtotals Cost Type
Blank when Zero Statement Date
Print on Secondary Subtotal Line User ID
Include Field Label Date Entered
Indent Label Receipt Allocation Type
Custom Field Include Fee Compensation Amounts
Receipt Allocation Period Print
Date Formula
Bill Code  

As each column is added, it is shown in the display of columns in the lower portion of the window. Each line in the display of columns represents a single column. To modify an existing column, simply highlight the desired column and the associated fields with that column will be displayed in the upper portion of the window.

The New Column button can be used to define a new column. You can also click on the (New Column) row in the column display to add a new column. To insert a column between existing columns, add a new column and then use the Move Up button to move the column to the desired position.

The Delete button can be used to delete the highlighted column. A column that has been defined as a sort column, selection criteria or used in a formula cannot be deleted.

The Move Up button or Ctrl+Up can be used to move the highlighted column up one row. All column references in formula lines will automatically be renumbered.

The Move Down button or Ctrl+Down can be used to move the highlighted column down one row. All column references in formula lines will automatically be renumbered.

Archive Note: When specifying archive information, amounts for deleted clients are not accessible.

See also:   Spacer Columns
  Overflow