|
|
|
|
|
Displays the name of the field.
Displays the display name of the table the field is stored in. If the field is stored in more than one table, the table that the field was selected from when it was placed in the report layout is displayed.
Allows you to specify the array index, indicating which element of the array field you want to use on the report. The Report Field Options window will appear automatically when you drag an array field to the report layout, allowing you to specify the array index for each field.
To add all the elements of an array to a report, hold down the Control key and drag the array field to the report layout. All the elements will be added to the layout automatically - you don't need specify the array index for each one. Each array element will appear with a number after its name, indicating its position in the array.
Allows you to determine how the field is displayed by selecting one of the following options:
The field is always displayed on the report, even if the field is blank for a given record. This is the default selection. If a visible field is blank but has a format applied to it, the formatting will be displayed on the report without any data. For example, a ZIP code field could be formatted to include a dash between the fifth and sixth characters. If this field is included on a report and is visible, and a given record has no ZIP code data, only a dash will appear in the ZIP code field for that record on the report.
The field will never be shown on a report. Commonly, fields are marked as invisible when their values are needed for use in calculated fields, but are not needed for display on the report. For example, you may want to display a field on the report showing the difference between the highest and lowest values of specific field. To accomplish this, add the field to a footer in the report layout twice. Change the display type of one instance to Minimum, and the display type of the other to Maximum. Then, create a calculated field that subtracts the minimum value from the maximum value. Since only the calculated field needs to be displayed on the report, set the visibility of both the minimum and maximum value fields to invisible.
If a record doesn't contain an entry for this field, the field won't be included on the report. For example, if a customer record doesn't include a telephone number, and the phone number field is marked as hide when empty, then for that customer record, the empty phone number field and any related formatting won't be included on the report.
|
Selecting hide when empty prevents formatting characters from appearing on a report when the field contains no data. |
You also can mark the Skip Blank Transactions option in the Report Definition window to skip records that contain incomplete data.
Displays the format applied to the field. The format defines data display characteristics for string, currency, composite and integer data types. Click the Format Lookup button to open a lookup window in which you can select an existing format to apply to the field or create a new format.
|
Don’t apply a specific format to a report field and use the Report Field Options window to specify a format field for the same report field; the format results will be unpredictable. |
Allows you to specify how the data in the selected field will be evaluated. The default display type for fields placed in the body of the report or in headers is Data; information in those fields is printed as it was entered and stored in tables. The default display type for fields placed in footers is Last Occurrence, which displays the most recent occurrence of data for that field in the Last Occurrence field. You can change the display type for fields in footers to any type except Data. Refer to the following topic for a complete description of each display type:
Not all display types can be used in all sections of a report. Refer to the following topic for a summary of what display types can be used in each section of a report.
When your report layout contains a string, currency or variable currency field that gets its formatting based on a format field, use the fields in this group to identify the format field, so that the Report Writer can retrieve the format information and print the record the same way it was saved.
|
Don’t apply a specific format to a report field and use the Report Field Options window to specify a format field for the same report field; the format results will be unpredictable. |
The format field must be an integer field. It is common to use a drop-down list for this purpose. To select a format field, click the visual switch until "Calculated Fields" or the appropriate table name is displayed. Then select the field name from the list. If you want to select a different field, Click None to deselect your original choice. Refer to the following topic for a complete description of using format fields: