Fields

Data Type - Define the application field type.
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 Select Command 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).

Single Value

Display a single value to the field by direct substitution. The value store in the database is substituted by a label defined in a list.

Figure1.1: Single Value lookup settings.

Label - Text displayed in the grid.
Value - Attribute stored in the table. For example, M is displayed Male.

Multiple Values (Delimiter)

Display more than one value for the selected field by replacing the string saved in the table by full description. The string values are separated by a defined delimiter. For example, the stored value S;M is displayed Sports(S) and Movies(M) in a list.

Figure1.2: Multiple Value lookup settings (delimiter).

Label - Text displayed in the grid.
Value - Attribute stored in the table.
Delimiter - Define the character used to separated string values.

Multiple Values (Position)

Display more than one value for the selected field by replacing the string saved in the table by full description. The values are retrieved based on the string position and size.

For example, in a string to save Gender (one byte), Marital Status (one byte) and Hobby (two bytes) the information stored includes label, start position in the string and size in bytes that each info occupies in the list:

Label	Value	Start	Size
Male	M	1	1
Female	F	1	1
Married	C	2	1
Single	S	2	1
Sports	SP	3	2
Movies	MO	3	2
Books	BO	3	2
Traveling	TR	3	2

A string saved as MMBO is displayed: MaleMarried Books .

Figure1.3: Multiple Value lookup settings (position).

Label - Text displayed in the grid.
Value - Attribute stored in the table.
Start - String start position for the data stored. (First position is always 1).
Size - Data size in bytes in the string.

Multiple Values (Binary)

Display more than one value for the selected field by replacing the string saved in the table by full description. In this options the values are stored as decimal and retrieved by specific algorithm.

For example, the following information list has the data and the value automatically attributed relative to the position that each value occupies. (the values are displayed):

Attributed Value	Lookup Description
1	Sports
2	Movies
4	Books
8	Traveling
16	Music

To display the info 11 and 12 (stored in the database), according to the list above, use the following algorithm:

11 = 1 + 2 + 8 = (Sports - Movies - Traveling)

Attributed Value	Lookup Description
1	Sports
2	Movies
4	Books
8	Traveling
16	Music

12 = 4 + 8 = ( Books - Traveling)

Attributed Value	Lookup Description
1	Sports
2	Movies
4	Books
8	Traveling
16	Music

Figure1.4: Multiple Value lookup settings (Binary).

Label - Text displayed in the grid.

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.

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.

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

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.