You are here: Commands > Define Report / View

Define Report / View

The quickest and easiest way to produce a new report and maintain an existing one is to work directly from a View. The Define Report command is simply a different way of accessing the View on which a report is based.

You can also use the Define Report command to:

Display a blank View to allow you to create a new report if the View name used does not exist for the current table
Display a report View from the current table to allow you to modify an existing report

Creating a report from a View and all report formatting options are described in Reports.

This command can be issued only in command mode. For more information, see Issuing Commands.

Command Mode Syntax

DEFINE REPORT View-name <FIELDS field-list>

or

DEFINE VIEW View-name <FIELDS field-list>

view-name allows you to access an existing View or create a new View with the specified name. If you give the View a two-word name, be sure to include the underscore character between the two words
field-list allows you to specify the fields in a new View

If you want to add columns to a new view, use Define View to create the new empty View, then use Define Column to add columns to the View from left to right. Define Column provides additional capabilities beyond specifying the field, as useful field modifiers can also be specified. For more information see Define Column.