Export (0) Print
Expand All
Expand Minimize

MODIFY REPORT Command

Opens the Report Designer to create or modify a report.


MODIFY REPORT [FileName | ?] 
   [[WINDOW WindowName1] [IN [WINDOW] WindowName2 | IN SCREEN]] 
   [NOENVIRONMENT] [NOWAIT] [PROTECTED] [SAVE]

Parameters

[FileName | ?]

Specifies the file name for the report or displays the Open dialog box so you can select an existing report file or type the name of the report file to create. The default file name extension for reports is .frx.

NoteNote

If the report file you specify does not exist or cannot be found, MODIFY REPORT creates a new report file. Calling MODIFY REPORT without arguments displays the Open dialog box. Choosing New opens the Report Designer and creates a new report file with the default name of ReportNumber. When you close the Report Designer, Visual FoxPro prompts you to save changes to the report and provide a different name.

[[WINDOW WindowName1]

Specifies a window whose characteristics the Report Designer inherits.

For example, if the window specified was created with the FLOAT option of DEFINE WINDOW, you can move the Report Designer. The specified window must be defined, but it does not need to be active or visible.

NoteNote

The Report Designer has a default size that can be larger than the specified window. In this case, the Report Designer still inherits the characteristics of the window with the upper-left corner of the Report Designer placed at the same coordinates as the upper-left corner of the specified window but extends beyond the specified window's borders.

[IN [WINDOW] WindowName2 | IN SCREEN]]

Specifies opening the Report Designer in a parent window or in the main Visual FoxPro window after placing the Report Designer in a parent window. The Report Designer does not assume the characteristics of the parent window and cannot move outside the parent window. If the parent window is moved, the Report Designer moves with it.

NoteNote

You must first define the parent window using DEFINE WINDOW and make it visible for access by the Report Designer.

[NOENVIRONMENT]

Prevents saving the Visual FoxPro data environment with the report and is included for backward compatibility with 2.x reports. For more information, see Controlling Data in Reports.

NoteTip

You can restore the data environment associated with a Visual FoxPro report by setting the data environment's AutoOpenTables property to True (.T.). To make sure that the report environment closes when the report finishes printing, set the AutoCloseTables property to True (.T.). For more information, see AutoOpenTables Property and AutoCloseTables Property.

[NOWAIT]

Continues program execution after the Report Designer opens. The program does not wait for the Report Designer to close but continues program execution on the immediate following line. If you omit NOWAIT, the Report Designer opens, and program execution pauses until the Report Designer closes.

When calling MODIFY REPORT with NOWAIT in the Command window, NOWAIT has no effect.

[PROTECTED]

Specifies that the Report Designer should open in “protected” mode, which disables or suppresses certain features of the Report Designer. Intended to be used in applications to expose end-user editing of report forms in a safer, controlled fashion where some potentially harmful editing actions cannot take place.

[SAVE]

Specifies that the Report Designer remain open after activating another window. If you omit SAVE, the Report Designer closes when you activate another window.

When calling MODIFY REPORT with SAVE in the Command window, SAVE has no effect.

You can also edit reports using the Visual FoxPro user interface. For more information, see How to: Open Reports and Labels. You can also create reports using a wizard. For more information, see How to: Create Reports (Visual FoxPro).

Community Additions

ADD
Show:
© 2014 Microsoft