Microsoft KB Archive/191955

= The NOWAIT clause of REPORT command breaks filter printing report from Preview window =

Article ID: 191955

Article Last Modified on 2/11/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Professional Edition
 * Microsoft Visual FoxPro 8.0 Professional Edition
 * Microsoft Visual FoxPro 9.0 Professional Edition

-



This article was previously published under Q191955



SYMPTOMS
When the NOWAIT clause is present in the REPORT FORM command, printing a report by clicking the printer icon in the report preview window will not print according to the filter setting, rather, it prints all the records.



CAUSE
The filter setting is not retained due to the NOWAIT keyword.



RESOLUTION

 * Remove the NOWAIT clause from the end of the REPORT FORM command. -or-


 * Create a cursor with the filter setting before calling the REPORT FORM command.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
  Create a table by running the following code: CREATE TABLE cust ( Name C(10), State C(2)) INSERT INTO cust VALUES ("Smith", "MA") INSERT INTO cust VALUES ("Mary", "AL") INSERT INTO cust VALUES ("Tom", "MA") INSERT INTO cust VALUES ("Joe", "MA") INSERT INTO cust VALUES ("Tomi", "CA") INSERT INTO cust VALUES ("John", "CA") INSERT INTO cust VALUES ("Linda", "MA")  Create a quick report based on the preceding table. Save the report as Cust.frx.  Create a program (.prg) and place the following code in the .prg file: DEFINE WINDOW wShowInq ; FROM 0,0 TO 10,10 ; SYSTEM ; ZOOM ; TITLE [&tcTitle.]

ZOOM WINDOW wShowInq MAX USE cust

*-- Comment the NOWAIT clause to obtain the expected results. REPORT FORM cust FOR State = "MA" PREVIEW NOWAIT  Save the program and run it.

When the Print Preview appears, only all the "MA" records are in the print preview.
 * 1) Click the Printer button on the Report Preview toolbar to print the report.

You will see all the records are printed in the hard copy of the report.

Additional query words: kbPrinting kbReportWriter kbvfp500 kbvfp500a kbvfp600

Keywords: kbprb KB191955

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.