Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Forms > Form Designer > Form Controls > Database Controls > Enhanced DB Grid > Columns

Enhanced Properties

Scroll Prev Top Next More

 

ð Band

Specifies the band to be assigned to the column

 

ð Sort Caption

Specifies the caption displayed when sorting records

 

ð Field Type

Specifies an enhanced data representation to display based on the column's field type. Options include: Standard, Progress Bar, Password, Hyperlink, Checkbox, and Lookup Expression

 

Standard - displays characters, with possible formatting

Display Format for Non-Text Values - specifies the display format for integer, date, time, etc. values. Use the provided button, or press [F6] for example formats. The display format overrides to the form-level format for the field.

Input Format Mask - specifies keystroke restrictions and formatting for data entry actions. Use the provided button for example formats. For more information, see Using Format Masks in Forms.

Character Case - specifies a case of the entered characters, which are converted as the user types. Changing the Character Case property changes the actual contents of the text, not just the appearance. Any case information is lost and can't be recaptured by changing Character Case to Normal. Supported Options: Normal, Upper Case, Lower Case, Word Case, Sentence Case, Title Case

Progress Bar - displays a progress bar for the field value

Minimum - specifies the minimum value allowed for the progress bar display

Maximum - specifies the maximum value allowed for the progress bar display

Bar Color - specifies the color for the progress bar

Progress Value - specifies if the value in the percentage is displayed

Position - specifies the text position of the progress percentage. Left, Center, and Right are relative to the cell. Progress Center and Progress Right are relative to the progress bar

Text Color - specifies the color of text displaying the progress percentage

 

EnhancedDBGrid_EnhancedOptions_ProgressBarField

 

Password - displayed a specified character to hide the actual value

Hyperlink - displays text as a hyperlink, which can be used to launch a Web browser

Checkbox - displays a check box, where the checked and unchecked values can be specified

Lookup Expression - displays a value based upon a lookup expression. When using a Lookup Expression field type, changes to the cell value will display the previous value after it is changed, and only updates when the focus is moved to another row. As the column change is known within memory (from moving from cell to cell within the row) and not yet passed to the engine (from moving from row to row), the Lookup Expression can be dynamically replaced with the current in-memory value before passing to the engine for evaluation by enclosing the field name within "less than" and "greater than" characters; "<" and ">". Example: AccountName IN Account WHERE AccountType = <AccountType>

 

ð Footer

Type

Specifies the type of data displayed in the footer beneath the column. Options include a custom Value/Text or one of several aggregate functions.

Alignment

Specifies the alignment of the of the footer value

Value

Specifies the custom value to be displayed in the footer

Text

Specifies the custom text to be displayed in the footer

 

ð Text Ellipsis

Specifies where the field ellipsis takes place

 

ð Filter Type

Specifies the condition type for the filter applied to the grid column. Options include: Same As Grid, CONTAINS, LIKE, and EQUAL

 

ð Read Only

Disables user from editing data in field

 

ð Title Clickable

Specifies whether the Enhanced DB Grid column is clickable to allow the column values to be sorted in ascending or descending order

EDBGrid_Column_EProps