Field | Type | Default | Description |
---|---|---|---|
id | int (11) | NOT NULL | PRIMARY KEY - Auto increment field to hold unique ID |
reportid | int(5) | 0 | Link to the report ID this field is a part of. |
entrytype | varchar(15) | NOT NULL | Defines the tpye of field. Types include: datafield: Hold the data field information used in reports and forms. One or moer entries are required per report/form. |
seqnum | seqnum(3) | 0 | The sequence number of the field. Used for ordering the fields. This value determines the display order in preparation of the output for reports but is only used to display the order of the fields in Reportbuilder for forms since fields are placed individually on a form. |
fieldname | fieldname(255) | NOT NULL | The name of the field as related to the databases used to generate the report/form. An equation can be entered here to generate more complicated report outputs. |
displaydesc | varchar(25) | NOT NULL | This field hold the textual desxcription of the field. The value entered here will be displayed in the header of reports but is only used for field setup in Reportbuilder for forms. |
visible | 0, 1 | 1 | Indicates whether the field will be displayed on the report or form. |
columnbreak | 0, 1 | 1 | Indicates whether the field will cause a column break after being displayed. If not set, the next field to display will be shown below this field. Column widths will default to the largest column displayed of all fields in a given column |
params | text | NULL | This is an encoded (serialized) string of parameters used to further identify the field. Form fields contain significant information related to the font, color, position, etc. The field is freeform in that there are no criteria regarding the contents. |