CREATE REPORT – Quick Report Command

See Also

Programmatically creates a report.

Syntax

CREATE REPORT FileName1 | ? FROM FileName2
  [FORM | COLUMN] [FIELDS FieldList] [ALIAS]
  [NOOVERWRITE] [WIDTH nColumns]

Arguments

FileName1

Specifies the file name for the report. If you don't specify an extension for the file name, Visual FoxPro automatically assigns an .frx extension.

?

Displays the Create dialog box that prompts you to name the report being created.

FROM FileName2

Specifies the name of the table from which the report is created. The table doesn't have to be open.

FORM

Specifies that the report is created with the fields and their names arranged from top to bottom in the Detail band.

COLUMN

Specifies that the report is created with the fields arranged from left to right across the page in the Detail band. The field names are placed in the Page Header band. If you omit FORM and COLUMN, the report defaults to the COLUMN format.

FIELDS FieldList

Specifies the fields from the table that appear in the report. Separate the fields in FieldList with commas.

ALIAS

Specifies that the table alias is added to the field names in the report.

NOOVERWRITE

Specifies that an existing report isn't overwritten. If a report already exists with the name specified with FileName1, the report isn't created.

WIDTH nColumns

Specifies the width of the report page in columns.

Remarks

This form of CREATE REPORT creates a quick report without opening the Report Designer. The report is created as if you chose Quick Report from the Report menu.

Another form of CREATE REPORT, discussed in the previous topic, opens the Report Designer to let you interactively create a report.

For additional information on reports and labels, see Designing Reports and Labels in the Using Visual FoxPro section, and Chapter 7, Designing Reports and Labels, in the User's Guide.