Microsoft KB Archive/159755

= FIX: The page footer and some data is not printed when you use the PROMPT clause of the REPORT FORM command =

Article ID: 159755

Article Last Modified on 2/11/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition

-



This article was previously published under Q159755



SYMPTOMS
If you run Visual FoxPro 5.0 on Windows 95 and use the PROMPT clause on the REPORT FORM command, the Page Footer does not print and some records might be missing between pages of a landscape report.



CAUSE
The PROMPT clause on the REPORT FORM command in Windows 95 causes the page footer and some records not to print.



WORKAROUND

 * 1) Do not use the PROMPT clause.

-or-

Use the Windows NT 4.0 operating system.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0a.



MORE INFORMATION
This problem occurs only on the Windows 95 operating system. It does not occur in Visual FoxPro 3.0 or 3.0b.

Steps to Reproduce Behavior
The following instructions assume a working knowledge of the Visual FoxPro Report Designer:

 Create a new report. On the File menu, click Page Setup. Choose the Print Setup button in the Page Setup dialog box and click landscape orientation. Click OK to exit both dialog boxes. Add a table to the Data Environment of the report. (The sample Customer table from the Samples\Data directory may be a good choice.) Add a field from the Customer table to the detail band of the report.</li> Create another field in the detail band of the report and use the RECNO function for the expression in this field.</li> Create a field in the Page Footer of the report. Use "Page"+ALLTRIM(STR(_pageno)) for the expression.</li> Save the report, and click Print Preview. Note that the record numbers are consecutive (assuming the table doesn't have an index order set) and that the page number appears in the Page Footer.</li>  In the Command window, type the following command to print the report: REPORT FORM TO PRINT RANGE 1,3 The RANGE clause allows the first three pages to print. Note that the Page Footer appears on all three pages and the record numbers are in sequence. The report matches the Print Preview. </li>  Now use the PROMPT clause on the REPORT FORM command: REPORT FORM TO PRINT PROMPT RANGE 1,3 In the Print dialog box, click OK. In the printed report, the Page Footer and several records are missing between the pages. </li> If you modify the report to print in portrait orientation, the missing records from the landscape version are printed in the report.</li></ol>

Keywords: kbbug kbfix kbvfp500afix kbprint kbusage KB159755

-

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

© Microsoft Corporation. All rights reserved.