+---------------------------------+
|             REPORT              |
+---------------------------------+
REPORT [FORM <file> | ?]
        [ENVIRONMENT]
        [<scope>] [FOR <expL1>]
        [WHILE <expL2>]
        [HEADING <expC>]
        [NOEJECT]
        [NOCONSOLE]
        [NOOPTIMIZE]
        [PLAIN]
        [PREVIEW]
        [TO PRINTER | TO FILE <file>]
        [SUMMARY]
        [PDSETUP]

-----------------------------------
Produces a report.
-----------------------------------

The REPORT command produces reports from report definition files that
have been generated by the CREATE/MODIFY REPORT commands.  These reports
may be sent to the printer, screen, a window or to an ASCII text file.

If the command REPORT is issued without any additional arguments the
Open File dialog appears displaying a list of existing report files to
choose from.

FORM <file>
        You may specify which report to print by including the name of a report
definition database <file> after the FORM keyword.

?
        If you include ? the Open File dialog appears displaying a list of
existing report files to choose from.

ENVIRONMENT
        When you create or modify a report you may optionally save the current
FoxPro environment with the report definition file.  Saving the FoxPro
environment places an additional record in the report definition
database.  This record contains the names of all open database and index
files, the index order and any relationships between the databases.

        If you include the ENVIRONMENT keyword, the environment saved in the
report definition file is restored.

<scope>
FOR <expL1>
WHILE <expL2>
        A detail line for each record in the active database will be produced
unless a <scope>, FOR or WHILE clause is specified.

HEADING <expC>
        The HEADING option is used to specify an additional heading line that
is to be placed on each page of the report.  If both the HEADING and
PLAIN option are specified with the REPORT command, the PLAIN option
takes precedence.

NOEJECT
        NOEJECT suppresses a form feed to the printer prior to printing the
report.

NOCONSOLE
        Including the NOCONSOLE option suppresses the echoing of reports to the
screen or a window when reports are being printed or sent to a text
file.

NOOPTIMIZE
        The REPORT command benefits from FoxPro's Rushmore technology.
Rushmore optimizes data retrieval.  Commands (like REPORT) that support
a FOR clause use Rushmore to enhance their performance.

        There are rare cases when you should disable Rushmore.  When a command
that utilizes Rushmore is issued, Rushmore determines which records
match the FOR clause criterion.  The command is then executed on records
in the database that match the Rushmore record set.

        If a potentially optimizable command like REPORT modifies the index key
in the FOR clause, Rushmore's record set may become outdated.  In a case
like this, you may disable Rushmore to ensure that you have the most
current information from the database.

        To disable Rushmore, include the NOOPTIMIZE keyword.  Rushmore may be
globally disabled (or enabled) for all commands that benefit from
Rushmore with the SET OPTIMIZE command.

        For further information on utilizing FoxPro's Rushmore technology, see
the Rushmore discussion in the FoxPro Developer's Guide, and the SET
OPTIMIZE command in this help facility.

PLAIN
        If the PLAIN option is specified, FoxPro suppresses the printing of
page numbers and the date at the top of each report page.  Page headings
will appear only at the beginning of the report.

PREVIEW
        Including the PREVIEW option sends a representation of the report to
the screen, letting you check the report for content and layout before
the report is printed.  If PREVIEW is included, the report is sent to
the screen for preview and is not printed.  To print the report you must
issue another REPORT FORM command without the PREVIEW option.

TO PRINTER | TO FILE <file>
        If TO PRINTER is included, the report is sent to both the designated
print device and the screen or a window.  If it is omitted, the report
is displayed on the screen only.  The TO FILE option sends the report to
the specified ASCII text <file>.

SUMMARY
        The SUMMARY option suppresses detail line printing.  Only totals and
subtotals are printed.

PDSETUP
        Uses a printer driver setup saved with the report.

For more information on creating and modifying reports, refer to the
FoxPro Interface Guide, or the report lesson in the FoxPro Getting
Started manual.


-----------------------------------

See Also:  CREATE REPORT, MODIFY REPORT, _PDRIVER, SET PDSETUP

-----------------------------------