Skip to main content

Filter Control

  • Updated

BackPrevious Topic  Next TopicNext

Filter Control

The properties of a filter control are:

Property NameDescription
General
Display NameSpecifies the display name of the object.

Data type: String

Instance NameShows the instance name of the object. This property is read only.
Geometry
HeightSpecifies the height of the object, in inches. Enter a numeric value to change the height.

Data type: Float

WidthSpecifies the width of the object, in inches. Enter a numeric value to change the width.

Data type: Float

XSpecifies the horizontal coordinate of the top left corner of the object, relative to its parent container. This property is unavailable if thePositionproperty is set to static. Enter a numeric value to change the position in inches.

Data type: Float

YSpecifies the vertical coordinate of the top left corner of the object, relative to its parent container. This property is unavailable if thePositionproperty is set to static. Enter a numeric value to change the position in inches.

Data type: Float

Color
BackgroundSpecifies the background color of the object. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

ForegroundSpecifies the foreground color of the object. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Border
Border ColorSpecifies the color of the border of the object. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Border ThicknessSpecifies the width of the border in inches. Enter a numeric value to change the thickness.

Data type: Float

Bottom LineSpecifies the line style of the bottom border of the object. Choose a style from the drop-down list.

Data type: Enumeration

Left LineSpecifies the line style of the left border of the object. Choose a style from the drop-down list.

Data type: Enumeration

Right LineSpecifies the line style of the right border of the object. Choose a style from the drop-down list.

Data type: Enumeration

Top LineSpecifies the line style of the top border of the object. Choose a style from the drop-down list.

Data type: Enumeration

Title
BackgroundSpecifies the background color of the title bar. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

BoldSpecifies whether to make the text bold in the title bar.

Data type: Boolean

Font FaceSpecifies the font of the text in the title bar. Choose an option from the drop-down list.

Data type: Enumeration

Font SizeSpecifies the font size of the text in the title bar. Enter an integer value to change the size.

Data type: Integer

ForegroundSpecifies the foreground color of the title bar. Choose a color from the drop-down list or select Custom to define a color in the Color Picker dialog. You can also enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.

Data type: String

Horizontal AlignmentSpecifies the horizontal justification of the text in the title bar. Choose an option from the drop-down list.

Data type: Enumeration

ItalicSpecifies whether to make the text italic in the title bar.

Data type: Boolean

Map NameSpecifies whether to use the name of the DBField added to the filter control as the text displayed in the title bar.

Data type: Boolean

Show Title Specifies whether to show the title bar. It is meaningful to set all the other properties in the Title category when this property is set to true.

Data type: Boolean

TextSpecifies the text displayed in the title bar. This property can be edited only when Map Name is set to false. Enter a string to change the text.

Data type: String

UnderlineSpecifies whether to underline the text in the title bar.

Data type: Boolean

Text Format
Auto Scale in NumberThe property is available when the field added in the object is of the Number data type. It specifies whether to automatically scale the field values that 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.

The option "auto" means that the property setting follows that of the object's parent data container.

Data type: Boolean

BoldSpecifies whether to make the text bold.

Data type: Boolean

Font FaceSpecifies the font of the text. Choose an option from the drop-down list.

Data type: Enumeration

Font SizeSpecifies the font size of the text. Enter an integer value to change the size.

Data type: Integer

FormatSpecifies the display format of the text in the report result. It varies with data type and can be manually defined.

Data type: String

Notes:

  • For the BigDecimal data type, to avoid precision loss, you should enter a prefix JRD when setting the Format property value.
  • For the Number data type and when the Auto Scale in Number property is true, the Format property applies to the integer part of the values after scaled, but if the specified format conflicts with the Auto Scale in Number property, for example, the values are displayed in percentage, then the Auto Scale in Number property is ignored.
ItalicSpecifies whether to make the text italic.

Data type: Boolean

UnderlineSpecifies whether to underline the text.

Data type: Boolean

Others
Export to CSVSpecifies whether to include the object when exporting the report to CSV.

Data type: Boolean

Export to ExcelSpecifies whether to include the object when exporting the report to Excel.

Data type: Boolean

Export to HTMLSpecifies whether to include the object when exporting the report to HTML.

Data type: Boolean

Export to PDFSpecifies whether to include the object when exporting the report to PDF.

Data type: Boolean

Export to PostScriptSpecifies whether to include the object when exporting the report to PostScript.

Data type: Boolean

Export to Report ResultSpecifies whether to include the object in Web Report Studio or when the report is opened in Web Report Result.

Data type: Boolean

Export to RTFSpecifies whether to include the object when exporting the report to RTF.

Data type: Boolean

Export to TextSpecifies whether to include the object when exporting the report to Text.

Data type: Boolean

Export to XMLSpecifies whether to include the object when exporting the report to XML.

Data type: Boolean

InvisibleSpecifies whether to show or hide the object. All formulas and calculations will still be performed if the property is set to true. You can also use a formula to control whether or not to show the object.

Data type: Boolean

Item Bottom Padding Specifies the space between the text and the bottom border of the filter control. Enter a numeric value to change the padding.

Data type: Float

Item Top Padding Specifies the space between the text and the top border of the filter control. Enter a numeric value to change the padding.

Data type: Float

PositionSpecifies the position of the object. Choose an option from the drop-down list.
  • static - The object is positioned at the location in which it is inserted. If selected, the X, Y and other position-related properties will be hidden or disabled. The position of the object is affected by preceding objects in the same container.
  • absolute - The object will be located at the position specified by dragging and dropping or by setting its X and Y property values. The position of the object is not affected by preceding objects in the same container.

Data type: Enumeration

BackPrevious Topic  Next TopicNext

Related articles