Converting FPW 2.6 reports


The Report Designers are very similar in the two versions of FoxPro:

[FoxPro 2.6 and VFP Report Designers]

The only obvious differences are that the VFP Report Designer has a floating toolbar and has a grid in centimetres rather than in inches. Both Report Designers are based on Page Header, Detail and Page Footer bands and both have the same set of controls which can be dropped onto the report.

When you come to run the report you can use the same syntax as in FoxPro for Windows:

Report Form (<reportname>) To Printer

This command in Visual FoxPro can accept additional parameters but the basic FPW command will run unchanged.

Both Report Designers store the description of the report in a pair of dbf-format files with .frx and .frt extensions. Despite this similarity, the two are not compatible. If you open an earlier report file in Visual FoxPro then a dialog will appear asking whether you want to convert the report file.

When you do run the conversion, VFP will make backup copies of the original files with .f2t and .f2x extensions. Despite this safety factor, it would still be a very wise precaution to make your own backup of the files before starting.


Introduction | Data | Program code | Menus | Reports | Screens | Strategy


Hints & tips

The textbox class in Visual FoxPro 9 has a new Autocomplete property which shows the user the previous values that have been entered in that textbox.
Autocomplete in VFP 9

Your Access database will look more impressive if you add custom toolbars...
Custom toolbars

FoxPro has always had functions to read and write files at a low level...
Foxpro low level file functions

More...
More pages of hints and tips for users of Microsoft FoxPro and Access databases.

Site Map