Adding a Field as a Report Column

In this section:

How to:

To create a report, you must add fields to it. Ordinarily, when you add a field to a report, the field name appears as the column title and the field values appear within that column. If you choose to organize data horizontally rather than vertically, the field name appears as a row label rather than as a column title. But, from the point of view of adding fields to a report, the principle is the same. For details, see Sorting Data.

The Fields tab in the Object Inspector lists all field names available for use in your report. This includes fields in the open file, and any joined files, as well as temporary fields and variable fields.

Selecting a field in the Fields tab displays the field properties in the bottom pane of the Object Inspector. You can right-click a field and adjust the amount, type, and order of information that appears in the Fields tab. For example, you can automatically sort the fields and display the format and/or description for each field.

Note: Right-click and click Hide Details section to show or hide details anywhere in the Object Inspector.

You can also create a variable field as a column to control output. For example, in a cost report, the variable might be &COST, which would allow a user to specify RETAIL_COST or DEALER_COST at run time. For details, see How to Create a Variable Field in Your Report.

Top of page

Procedure: How to Add Columns to Your Report

To add columns to your Report Painter window from the Fields tab in the Object Inspector:

Top of page

Procedure: How to Create a Temporary Field in Your Report

You can create a temporary field based on existing information in the data source, and then add that field to your report request.

Click the Options button from the Output Format toolbar and click the Computes tab from the Report Options dialog box, where you can create the temporary field.

Tip: You can also select the Compute icon, located on the Setup toolbar.

The temporary field that you create will be listed in the Computed Fields (in the Fields tab in the Object Inspector) so that you can add it to the report as you would any other field.

As you create your temporary field, the fields in the data source you are reporting against are listed in a secondary Fields window that shows field names and descriptions by default. Click the Fields button on the Computes tab to open the secondary Fields list window. To adjust the information that you see in the Fields list window (for example, to display field aliases, along with the field names), right-click in the window and click Show Alias from the pop-up menu.

For details about creating temporary fields in reports, see Creating a Calculated Value With Report Painter.

Top of page

Moving or Deleting a Column

How to:

You can copy, cut, paste, drag and drop, and delete columns in reports.

Procedure: How to Cut or Copy and Paste a Column
  1. Select the column or columns you want to cut or copy.
  2. Select Cut or Copy from the Edit menu.
  3. Position the mouse pointer between columns in the column title area.

    You will see a hand with a finger pointing down at the target location.

  4. Click the left mouse button.

    The Insert Mode symbol displays at the target location.

  5. Click Paste from the Edit menu.

Procedure: How to Drag and Drop a Field

To drag a field from the Fields tab in the Object Inspector to the Report Painter window, select the field and drag it to the desired location.

To move a column from one location to another in the Report Painter window, select and drag the column to the new location.

Procedure: How to Delete a Column

To delete a column from a report, right-click the column and click Delete from context menu or press the Delete key.