FoxPro Report FRX Table Structure

Visual FoxPro 9 Report (FRX) Table Structure

Here is a link to a table showing all the field names and details for Visual FoxPro 9 Report (FRX) files. This table also applies to Label (LBX) files.

Click here: FoxPro-Report-FRX-Structure.html

The HTML table in the above link was generated from the 90Frx.frx report in the Tools\Filespec folder of the Visual FoxPro installation folder.

Preview:

7-6-2011 10-07-41 PM

Here is a nice article with some deep technical info on advanced programming of Reports in VFP 9:

http://spacefold.com/articles/RSFundaments_part1.aspx

FoxPro Report FRX Table Schema

Here is a basic view of the table schema, but it does not contain all the field details of the full report above. 

The schema contains 75 fields:

Field Name Data Type
PLATFORM C(8)
UNIQUEID C(10)
TIMESTAMP N(10)
OBJTYPE N(2)
OBJCODE N(3)
NAME M
EXPR M
VPOS N(9,3)
HPOS N(9,3)
HEIGHT N(9,3)
WIDTH N(9,3)
STYLE M
PICTURE M
ORDER M
UNIQUE L
COMMENT M
ENVIRON L
BOXCHAR C(1)
FILLCHAR C(1)
TAG M
TAG2 M
PENRED N(5)
PENGREEN N(5)
PENBLUE N(5)
FILLRED N(5)
FILLGREEN N(5)
FILLBLUE N(5)
PENSIZE N(5)
PENPAT N(5)
FILLPAT N(5)
FONTFACE M
FONTSTYLE N(3)
FONTSIZE N(3)
MODE N(3)
RULER N(1)
RULERLINES N(1)
GRID L
GRIDV N(2)
GRIDH N(2)
FLOAT L
STRETCH L
STRETCHTOP L
TOP L
BOTTOM L
SUPTYPE N(1)
SUPREST N(1)
NOREPEAT L
RESETRPT N(2)
PAGEBREAK L
COLBREAK L
RESETPAGE L
GENERAL N(3)
SPACING N(3)
DOUBLE L
SWAPHEADER L
SWAPFOOTER L
EJECTBEFOR L
EJECTAFTER L
PLAIN L
SUMMARY L
ADDALIAS L
OFFSET N(3)
TOPMARGIN N(3)
BOTMARGIN N(3)
TOTALTYPE N(2)
RESETTOTAL N(2)
RESOID N(3)
CURPOS L
SUPALWAYS L
SUPOVFLOW L
SUPRPCOL N(1)
SUPGROUP N(2)
SUPVALCHNG L
SUPEXPR M
USER M

Leave a Reply

Your email address will not be published. Required fields are marked *