Label - Field title in the display. For example: a field identified in database as fld_client_name,
could be label Client Name. That is because the label is a field nickname in the application layer.
Case Settings - Converts the field text depending on the option:
Uppercase
Converts all texts to capital letters.
Lowercase
Converts all texts to lower case.
Uppercase first word
Capitalizes only first word (converts only the first letter of the first word to capital letter).
Uppercase all words
Capitalizes each word (converts the first letter of each word to capital letter).
Grid Mask - Define the field display mask. See below the characters used to define the mask.
Character
Description
X
Placeholder to any character. Replaced by any character. If number of characters entered are less then the mask size, the field value is completed with zeros (Filling full size field entry is required).
Z
Replaced by any character retrieved from database. Suppress zeros at field left (Complete field filling is optional). When used combined with the mask character X it should be placed at the mask left.
Examples:
Mask
Field Value
Formatted Value
(xx) xxxx - xxxx
1234567890
(12) 3456 - 7890
(xx) xxxx - xxxx
12345678
(00) 1234 - 5678
(zz) xxxx - xxxx
1234567890
(12) 3456 - 7890
(zz) xxxx - xxxx
12345678
( ) 1234 - 5678
(zz) xxxx - xxxx
0012345678
( ) 1234 - 5678
SQL Type - Define the field type in the database.
Grid Lookup
Used to modify the display of a grid field. For example, a field gender in the database with values M or F is displayed as Male or Female (see lookup manual) or the display values retrieve from a database table (see lookup automatic).
Before Lookup
After Lookup
Grid Lookup - Automatic
Lookup used to modify a field display dynamically, retrieving the values from a database table.
Figure3: Automatic Grid Lookup Interface.
Attributes :
SQL Select Statement - Define the SQL statement to retrieve the grid field display value. The statement has the following format "SELECT display_field FROM table WHERE key_field = {grid_field}".
The grid field should be enclosed in curly brackets. During execution the field enclosed in curly brackets is substituted by its table value.
Multiple Options - Select Yes when the SelectCommand entered returns more than one informed value.
Delimiter - Define the delimiter between the multiple values returned by the Select Command. Use this option when Multiple Options = Yes.
Use lookup in:
Grid
Apply the lookup in all grid types (HTML, PDF, XML , CSV and RTF).
Summary
Apply the lookup summary only (HTML and PDF).
Both
Same as selecting Grid and Summary.
Default Value - Define a default value used when the select command does not return any value.
Display original and lookup value - Select No, to display only the Select Command return value. Otherwise, the field original value and the Select Command return value separated by the character defined in Separated by.
Separated by - Define the characters used to separate the field original value and the Select Command return value. Use this option when Display original and lookup value = Yes.
Choose connection - Select a different connection available in the project.
Grid Lookup - Manual
Lookup used to modify a field display with predefined values.
Figure1: Manual Grid LookupInterface.
Attributes :
Lookup Types - Define the lookup operation mode: Single Value , Multiple Values (Delimiter), Multiple Values (Position) and Multiple Values (Binary).
Insert - Add the
values entered in Label and Value to the value list .
Update - Update selected item.
Remove - Remove selected item.
Clear - Clear the attributes.
Save - Save the values entered to the "lookup definitions" list to be used afterwards (for reuse).
Load lookup definitions - Loads a pre-defined Values List to use in lookup.
Use lookup in:
Grid
Apply the lookup in all grid types (HTML, PDF, XML , CSV and RTF).
Summary
Apply the lookup only in (HTML and PDF).
Both
Same as selecting Grid and Summary.
Default Value - Define a default value used when the selected command does not return any value.
Display original and lookup value - Select No, to display only the Label value . Otherwise, the field original value and the Label value are displayed separated by the character defined in Separated by.
Separated by - Define the characters used to separate the field original value and the Select Command return value. Use this option when Display original and lookup value = Yes.
Group By Settings
Image1: Group By Fields Interface.
Attributes:
Fields Position - Define the group by fields display organization.
Columns - Define how many columns are used to display the break down info.
Display Label- Display the field label on break down.
Line break - Display break down line.
Summary line (grid) - Display summary line in the grid.
Total line (summary) - Display line total in the summary.
Total line message - Define the text message displayed in the total line. Ex.: Orders total in the state.
Records amount - Display the amount of records displayed in the break down.
PDF Grid Break Pages - Display each grid break in a separate PDF page. Ex.: Display each state orders in a different report page.
PDF Summary break page - Display each summary break in a separate PDF page.
HTML Grid Break Pages - Display each grid break in a separate HTML page.
HTML Summary break pages - Display each summary break in a separate HTML page.
Start TreeView - TreeView initial state.
Sorting - Order in which the field will appear in the Group By.
Fields - Select the fields (VALUE and SUM) displayed in the group by line.
Group by line layout (Label)
Image2:Group by line layout (Label) Interface.
Attributes:
Text Font - Allow
to define the font used on the breaking label.
Font Size - Allow to define the font size used on the breaking label.
Text Color - Label color on the breaking.
Background Color - Breaking background color.
Bold Text - Allow to turn on or turn off the bold label of the breaking.
Group by line layout (Value)
Image3: Group by line layout(Value) Interface.
Attributes:
Text font - Allow to define the font used on the breaking label.
Font size - Allow to define the font size used on the breaking label.
Text color - Label color on the breaking.
Bold text - Allow to turn on or turn off the bold label of the breaking.
Configure the total line layout
Image4: Configure the total line layout Interface.
Attributes:
Text font - Allow to define the font used on the breaking label.
Font size - Allow to define the font size used on the breaking label.
Text color - Label color on the breaking.
Background color - Breaking background color.
Bold text -Allow to turn on or turn off the bold label of the breaking.