>Hi all,
>
>I have an app that needs to print on A4 and 8.5 X 11 paper. It looks like Foxpro compliles the paper size into the report. Does anyone know if this is true? Are there ways to get around this?
>
>Thanks
>
>Jeff

Hi Jeff,

Yes, this is correct that Foxpro keeps the paper size in the .FRX
In many cases the solution may be to clear out EXPR, TAG and TAG2 field, and the report will just go with the default printer settings but in some cases the information in EXPR field may be important for the print output you are trying to get. If your report has the Landscape orientation and you wipe out EXPR field it will run with the default Portrait orientation, so the right side of it will be cut. IF your report has Portrait orientation and the layout fits in both A4 and 8.5 X 11 you may be OK, but you need to play around with settings and see.

You may have 2 versions of the report for A4 and Letter size but it is not convenient for the report maintenance.
Another option may be to edit the .FRX on the fly, replacing the PAPERSIZE, PAPERLENGTH and other necessary parameters in EXPR field according to selected printer. In this case you need to keep this report separate from your EXE. And if it is networking app, to avoid the collisions you may need to copy this report to temporary directory, change the parameters and run the copy, or have the local copy of the report on each workstation.

Nick