Previous Topic
Data Field Properties
The Data Field Properties dialog box is used to edit the properties of a DBField.
There are the following tabs in this dialog box: General, Font, Border, Others and Display.
OK
Applies the settings and closes this dialog box.
Cancel
Cancels the settings and closes this dialog box.
Help
Displays the help document about this feature.
General
This tab shows some general information of the data field.
Name
Specifies the display name of the data field.
Show NLS Value
Select this option to show the translated name for the display name of the object in the Name text box if you have enabled the NLS feature and translated it.
If selected, this option takes effect only when the display name of the object is not modified.
Format
Specifies the data format of the data field.
Auto Scale in Number
Specifies whether to automatically scale the data field values that are of the Number data type when the values fall into the two ranges:
- When 1000 <= value < 10^15, the following quantity unit symbols of the International System of Units are used to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
- When 0 < value < 0.001 or value >= 10^15, scientific notation is used to scale the values.
By default it is set to auto which means that the setting follows that of the field's parent data container. When it is true, the specified format applies to the integer part of the values after scaled, but if the specified format conflicts with Auto Scale in Number, for example, the values are displayed in percentage, then the Auto Scale in Number setting is ignored.
Position
Displays the position mode of the data field. If the data field is directly contained in the report body, a tabular cell, or a text box, its position mode can be modified.
- Absolute: The data field's position will be decided by its X and Y property values.
- Static: The data field will be positioned at the default location in its container. If selected, the X, Y and other position-related properties will be hidden or disabled.
X
Specifies the X coordinate of the data field.
Y
Specifies the Y coordinate of the data field.
Width
Specifies the width of the data field.
Height
Specifies the height of the data field.
Top Padding
Specifies the space between the text of the field and its top border.
Bottom Padding
Specifies the space between the text of the field and its bottom border.
Left Padding
Specifies the space between the text of the field and its left border.
Right Padding
Specifies the space between the text of the field and its right border.
Background
Specifies the background color of the data field.
To change the color, select the color indicator to baccess the Select Color dialog box and then specify a new color, or type a color string in the format #RRGGBB. If you want to make the background transparent, type Transparent in the text box.
Foreground
Specifies the foreground color of the data field.
To change the color, select the color indicator to access the Select Color dialog box and then specify a new color, or type a color string in the format #RRGGBB.
Font
This tab shows the font-related information of the data field.
Font
Specifies the font face of the text.
Size
Specifies the font size of the text.
Horizontal Alignment
Specifies the horizontal alignment mode of the text in the data field.
Vertical Alignment
Specifies the vertical alignment mode of the text in the data field.
Bold
Specifies whether to make the text bold or not.
Underline
Specifies whether the text will be underlined or not.
Strikethrough
Specifies whether or not to attach a strikeout line to the text.
Italic
Specifies whether to make the text italic or not.
Autofit
Specifies whether or not to automatically adjust the width of the data field according to the maximum length of the contents.
Word Wrap
Specifies whether or not to wrap the text to the data field width.
Ignore HTML Tag
If this option is set to false, Logi Report will parse HTML tag elements in the field value while the report is to be saved as an HTML file; or the field value will appear in the HTML file the same as that in Page Report Studio (HTML tag elements in the field value, if any, will not be parsed).
Border
This tab shows information about borders of the data field.
Color
Specifies the border color. To change the color, select the color indicator to access the Select Color dialog box and then specify a new color, or type a color string in the format #RRGGBB. If you want to make the border transparent, type Transparent in the text box.
Width
Specifies the border width in inches.
Top Line
Specifies the style of the top border line.
Bottom Line
Specifies the style of the bottom border line.
Left Line
Specifies the style of the left border line.
Right Line
Specifies the style of the right border line.
Shadow
Specifies whether the borders will have a shadow effect or not.
Shadow Color
Specifies the color of the border shadow. To change the color, select the color indicator to access the Select Color dialog box and then specify a new color, or type a color string in the format #RRGGBB.
Others
You can use this tab to view and configure some miscellaneous settings.
TOC Anchor
Specifies whether or not to add the node that represents the data field to the TOC tree in the TOC Browser.
Suppress When No Records
Specifies whether to display the data field in the report result when no record is returned to its parent data component.
Suppress If Null
If true and the field value is null, the data field will not be displayed.
Export to XLS
If true, the data field will be exported when you save the report result as an XLS file (make sure to check Data Format in the Export dialog box).
Export to CSV
If true, the data field will be exported when you save the report result as a TXT file with Delimited Format selected.
Scope
Available only for data fields in a table or crosstab. It is a representation of the standard HTML attribute scope. This attribute specifies the set of data cells for which the current header cell provides header information.
- Row - The current cell provides header information for the rest of the row that contains it.
- Column - The current cell provides header information for the rest of the column that contains it.
- None - The scope attribute will not be generated when exporting to HTML.
Logic Column
Specifies whether to show the data field in the next visible table cell in the same row when the column which holds the field is hidden.
Display
You can use this tab to modify the display type of the data field as one of the following: Text, Barcode, Image, Text Field, Text Area, check box, Radio Button, Image Button, Button, Submit, Reset, and Hidden. What you need to do is select the display type from the Display Type drop-down list, and then set the corresponding options.
Note: For the display type Text, there is no option available. For a field displayed as rank, you cannot change its display type.
Barcode
Specifies to display the data field as barcode.
Symbology
Specifies the barcode type.
Scale Mode
Specifies the unit for the values of the quiet zone, narrow width, supplement, height, and ratio.
Quiet Zone
Specifies the space around the barcode.
Narrow Width
Specifies the width of the narrowest barcode bar.
Supplement
Specifies the supplement of the barcode.
Height
Specifies the height of the barcode bars.
Message
Specifies the default value of the barcode.
Ratio
Specifies the width ratio of the thick bar to the thin bar.
Orientation
Specifies the rotation angle in degrees.
Use Default Message
Specifies whether or not to use the Message value as the barcode value when you view the report result.
Enable Checking Digits
Specifies whether or not to include check digits in the barcode.
Display HR
Specifies whether or not to display the characters together with the barcode bars.
Image
Specifies to display the data field as image.
Scaling Mode
Specifies the scaling mode of the image, which controls the image behavior when you adjust the size of the area for displaying the image. This option is enabled when Original Size is false.
- actual size - Shows the image in its actual size. If the size of the area for displaying the image is smaller than that of the image, part of the image will be cut off.
- fit image - Adjusts the image to fill up the area for displaying the image, with its original perspective remained but under the limitation of Max Ratio.
- fit width - Adjusts the image to fit the width of the area for displaying the image but under the limitation of Max Ratio.
- fit height - Adjusts the image to fit the height of the area for displaying the image but under the limitation of Max Ratio.
- customize - Adjusts the image according to the width and height that you specify in the Width and Height text boxes, regardless of Max Ratio.
Rotation
Rotates the image at a specified angle in degrees. The following is the meaning of different values:
- 0 - No rotation.
- Positive value - Rotates the image clockwise.
- Negative value - Rotates the image anticlockwise.
Note: When a rotation degree is specified for the image, in the report result the area for displaying the image maintains its original size hence it may result in that the rotated image exceeds the area boundary. In this case Logi Report will cut the parts that extend outside of the area.
Name
Specifies the name of the image. It is mapped to the HTML element attribute "name".
Alternate Text
Specifies the alternate text of the image, which will be shown when the image cannot be displayed.
Max Ratio
Specifies the maximum scaling ratio up to which the image can be scaled. By default the scaling ratio of the image is not limited. If you set the ratio to any value greater than 0, the actual scaling ratio will be less than or equal to it.
Width
Specifies the width of the area for displaying the image. This option is enabled when Original Size is false.
Height
Specifies the height of the area for displaying the image. This option is enabled when Original Size is false.
Original Size
Specifies whether or not to show the image in its original size.
Text Field
Specifies to display the data field as text field.
Type
Specifies whether to render the field as a normal text field or to a password box.
Name
Specifies the name of the text field. It is mapped to the HTML element attribute "name".
Title
Specifies the tip information which will be shown when you hover the mouse over the text field. It is mapped to the HTML element attribute "title".
Character Width
Specifies the width of the text field mesured in the number of characters.
Max Length
Specifies the maximum number of the characters that can be input into the text field.
Read Only
Specifies whether or not to make the text field read-only.
Disabled
Specifies whether or not to make the text field disabled.
Note: When displaying a data field as text field, the value you have specified for the field's font property Vertical Alignment will no longer take effect. This is because the property is not supported in HTML standards.
Text Area
Specifies to display the data field as text area.
Name
Specifies the name of the text area. It is mapped to the HTML element attribute "name".
Title
Specifies the tip information which will be shown when you hover the mouse over the the text area. It is mapped to the HTML element attribute "title".
Wrap
Specifies whether or not to wrap text to the width of the text area.
Note: When displaying a data field as text area, the value you have specified for the field's font property Vertical Alignment will no longer take effect. This is because the property is not supported in HTML standards.
Read Only
Specifies whether or not to make the text area read-only.
Disabled
Specifies whether or not to make the text area disabled.
Checkbox
Specifies to display the data field as check box.
Name
Specifies the name of the check box. It is mapped to the HTML element attribute "name".
Title
Specifies the tip information which will be shown when you hover the mouse over the check box. It is mapped to the HTML element attribute "title".
Disabled
Specifies whether or not to make the check box disabled.
Initially Checked
Specifies whether or not the check box is selected by default.
Radio Button
Specifies to display the data field as radio button.
Name
Specifies the name of the radio button. It is mapped to the HTML element attribute "name".
Title
Specifies the tip information which will be shown when you hover the mouse over the radio button. It is mapped to the HTML element attribute "title".
Disabled
Specifies whether or not to make the radio button disabled.
Initially Checked
Specifies whether or not the radio button is selected by default.
Image Button
Specifies to display the data field as image button.
Scaling Mode
Specifies the scaling mode of the image, which controls the image behavior when you adjust the size of the area for displaying the image. This option is enabled when Original Size is false.
- actual size - Shows the image in its actual size. If the size of the area for displaying the image is smaller than that of the image, part of the image will be cut off.
- fit image - Adjusts the image to fill up the area for displaying the image, with its original perspective remained but under the limitation of Max Ratio.
- fit width - Adjusts the image to fit the width of the area for displaying the image but under the limitation of Max Ratio.
- fit height - Adjusts the image to fit the height of the area for displaying the image but under the limitation of Max Ratio.
- customize - Adjusts the image according to the width and height that you specify in the Width and Height text boxes, regardless of Max Ratio.
Name
Specifies the name of the image button. It is mapped to the HTML element attribute "name".
Alternate text
Specifies the alternate text of the image, which will be shown when the image cannot be displayed.
Title
Specifies the tip information which will be shown when you hover the mouse over the image button. It is mapped to the HTML element attribute "title".
Max Ratio
Specifies the maximum scaling ratio up to which the image can be scaled. By default the scaling ratio of the image is not limited. If you set the ratio to any value greater than 0, the actual scaling ratio will be less than or equal to it.
Width
Specifies the width of the area for displaying the image. This option is enabled when Original Size is false.
Height
Specifies the height of the area for displaying the image. This option is enabled when Original Size is false.
Original Size
Specifies whether or not to show the image in its original size.
Disabled
Specifies whether or not to make the image button disabled.
Button
Specifies to display the data field as button.
Name
Specifies the name of the button. It is mapped to the HTML element attribute "name".
Title
Specifies the tip information which will be shown when you hover the mouse over the button. It is mapped to the HTML element attribute "title".
Value
Specifies the text displayed on the button by directly typing or using a formula. To make this property work, you need to set From Database to false.
From Database
If true, the current DBField value will be kept as the display text on the button. If false, you can use the Value property to specify the display text.
Disabled
Specifies whether or not to make the button disabled.
Note: When displaying a data field as button, the value you have specified for the field's font property Vertical Alignment will no longer take effect. This is because the property is not supported in HTML standards.
Submit
Specifies to display the data field as submit button.
Name
Specifies the name of the submit button. It is mapped to the HTML element attribute "name".
Title
Specifies the tip information which will be shown when you hover the mouse over the submit button. It is mapped to the HTML element attribute "title".
Value
Specifies the text displayed on the submit button by directly typing or using a formula. To make this property work, you need to set From Database to false.
From Database
If true, the current DBField value will be kept as the display text on the submit button. If false, you can use the Value property to specify the display text.
Disabled
Specifies whether or not to make the submit button disabled.
Reset
Specifies to display the data field as reset button.
Name
Specifies the name of the reset button. It is mapped to the HTML element attribute "name".
Title
Specifies the tip information which will be shown when you hover the mouse over the reset button. It is mapped to the HTML element attribute "title".
Value
Specifies the text displayed on the reset button by directly typing or using a formula. To make this property work, you need to set From Database to false.
From Database
If true, the current DBField value will be kept as the display text on the reset button. If false, you can use the Value property to specify the display text.
Disabled
Specifies whether or not to make the reset button disabled.
Hidden
Specifies to render the data field as hidden field.
Name
Specifies the name of the hidden field. It is mapped to the HTML element attribute "name".
Value
Specifies the value of the hidden field by directly typing or using a formula.