How to Use Report Fields in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

Learn how to add, remove, organize, and manage fields within the Report Fields section of a VDM View.

What is the Report Fields section?

The Report Fields section contains the fields that will be returned when a View is executed. Fields can be added from the Tables and Fields panel and organized to control the structure of the View results.

Fields can be added by:

• Double-clicking a field in the Tables and Fields panel.
• Dragging a field into the Report Fields section.

How Report Fields Affect View Results

The fields listed in the Report Fields section determine which columns are returned when a View is executed. The order of fields in the Report Fields list also controls the order of columns displayed in the results.

Video Tutorial

When Would I Use Report Fields?

Use the Report Fields section to:

• Select the data returned by a View.
• Organize the order of returned columns.
• Remove unnecessary fields.
• Add custom calculations and functions.

Common Report Field Tasks

Before working with Report Fields, you must first add fields from the Tables and Fields panel. For more information, see How to Use the Tables and Fields Panel in VDM.

Remove Fields

1. Select the field you want to remove from the Report Fields section.

2. Right-click the field and select Remove or double-click the field to remove it.

Change Field Order

The View returns fields in the same order they appear in the Report Fields list.

1. Click and hold the field you want to move.

2. Drag the field to its new position in the list.

3. Release the mouse button to place the field in its new location.

Add Custom Functions

Custom Functions allow calculations, string manipulation, and database-specific logic to be added directly to a View. For more information, see Creating and Using Custom Database Functions in VDM.

1. Right-click within the Report Fields section and select Add Custom Field/Function.

2. Enter the custom field or function.

3. Specify the returned column name and click Add.

Report Fields Right Click Options

Example Workflow

1. Add fields from the Tables and Fields panel.
2. Rearrange the field order.
3. Remove unnecessary fields.
4. Add custom calculations if needed.
5. Run the View.