Report PDF Fields - Text

Image1: Field General Settings Interface.

• Data Type - Define the application field type. A field type text it accepts letters, numbers and special characters.

• Case Settings - Convert the field font case. All upper case, if the select option is Upper Case, all lower case if the select option is Lower Case, only first letter of first word to upper case, if the select option is Capitalize first word, first letter of each word to upper case if the select option is Capitalize all word.

• HTML Content - Define the field content as HTML. An HTML Content field process html tags.

• Grid Mask - Define the field grid mask. For example, to format a phone number with parentheses and dashes. The mask uses the characters "X" and "Z", where X enable zero and Z disable zero.

• SQL Type - Determine the field type in 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.

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).
  
  

• 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.