Microsoft KB Archive/101016

From BetaArchive Wiki

HOWTO: Print a Report with "Page # of #" Format in Footer

ID: Q101016



The information in this article applies to:

  • Microsoft FoxPro for MS-DOS, versions 1.02, 2.0, 2.5x, 2.6x
  • Microsoft Visual FoxPro for Windows, version 3.0




SUMMARY

To print a report with a footer that has a "Page # of #" format, you must use a user-defined function (UDF), as explained below.


MORE INFORMATION

Include the variable in the report where it is required: for instance, on the report layout, the footer would contain:

Page _PAGENO of _TOTPGS 

where _TOTPGS is the variable.

Run the following code before the actual printing of the REPORT FORM statement, and you have the desired results:

***  Start code
_TOTPGS=0
REPORT FORM reportname RANGE 9000
_TOTPGS=_pageno
***  End code 


REFERENCES

"Commands & Functions," version 2.0, page C3-662 "Language Reference," version 2.5, page L3-820

Additional query words: REPORT FORM reportname PREVIEW

Keywords          : kbVFp300 
Version           : MS-DOS:1.02,2.0,2.5x,2.6x; WINDOWS:3.0
Platform          : MS-DOS WINDOWS 
Issue type        : kbhowto 

Last Reviewed: September 18, 1999
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.