Property Definitions

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U - V

W - Z

A

Accessed Via

Properties for Entity

The name of the entity from which this entity must be generated.  This is an optional property.  For example, if the entity has certain conditions that must be met on a screen entity before it can be run, the name of the screen entity should be entered here.  This prevents the original entity from being improperly accessed.  For templates, this is the default setting for the entities created from the template.

Active Style

Properties for Link Style

Pop-list containing all exiting styles.  Select the name of the style to use for the Active state. Links that the user has just clicked on are in the Active state.

Add Block or Labels

Option to add more New Blocks to Screen: (entity name)

Checkbox set to on indicates that you wish to continue to add blocks or labels to the entity.  When you set this checkbox to on, the explorer tree for this entity will be displayed to allow you to select the object to which you are adding blocks or labels.

After Save

Properties for Converter
Properties for Report
Properties for Screen

Enter any code that should be run after all queries are executed on this screen.  The code entered here should be written in SQL.

Allow Annotation

Properties for Report
Properties for Template

Pop-list indicating whether user annotation is allowed for pdf files generated from this report definition.  When set to true, the pdf file can be annotated by the user.  When set to false, the pdf file cannot be annotated by the user.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption, and only applies to the user setting.  The user setting is when the user password has been entered to open the pdf.  

Allow Anonymous

Properties for Entity

Pop-list displaying true or false indicates whether anonymous users can view this entity.  

When this pop-list is set to true, anonymous users can view the entity.  

When this pop-list is set to false, anonymous users cannot view the entity.

Allow Assembly

Properties for Report
Properties for Template

Pop-list indicating whether user assembly is allowed for pdf files generated from this report definition.  When set to true, the pdf file can be assembled by the user (insert/delete/rotate entities, make bookmarks, thumbnails, etc).  When set to false, the pdf file cannot be assembled by the user.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption, and only applies to the user setting.  The user setting is when the user password has been entered to open the pdf.  

Allow Copy

Properties for Report
Properties for Template

Pop-list indicating whether the Copy function (Ctrl+C) is supported from within pdf files generated from this report definition.  When set to true, the pdf file supports the Copy function (Ctrl+C) from within the pdf file.  When set to false, the pdf file does not support the Copy function.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption, and only applies to the user setting.  The user setting is when the user password has been entered to open the pdf.  

Allow Degraded Print

Properties for Report
Properties for Template

Pop-list indicating whether pdf files generated from this report definition can be printed in degraded mode.  When set to true, the pdf file can be printed in degraded mode (i.e. as an image) by the user.  When set to false, the pdf file cannot be printed in degraded mode (i.e. as an image) by the user.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption, and only applies to the user setting.  The user setting is when the user password has been entered to open the pdf.  

Allow Print

Properties for Report
Properties for Template

Pop-list indicating whether pdf files generated from this report definition can be printed exactly by the user.  When set to true, the pdf file can be printed exactly by the user.  When set to false, the pdf file cannot be printed exactly by the user.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption, and only applies to the user setting.  The user setting is when the user password has been entered to open the pdf.  

Allow Readers

Properties for Report
Properties for Template

Pop-list indicating whether Accessibility Readers can be used to view pdf files generated from this report definition.  When set to true, Accessibility Readers can be used to view the pdf file.  When set to false, Accessibility Readers cannot be used to view the pdf file.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption, and only applies to the user setting.  The user setting is when the user password has been entered to open the pdf.  

Allowed Table Query

Properties for Datasource

The select statement used to populate the list of tables available when creating a new block.

Auto Save

Properties for Field

For Upload File fields, set to true or false to indicate whether the file or the contents of the file should be saved automatically after upload.  

Auto Value Type

Properties for Field

This property is a future feature used when generating sequences for new records.  Leave this property set to Not Automatic at this time.

B

Background

Properties for Style

The selected color for the background for this style is displayed.  The property is displayed when the Background Inherited property is set to false or the style is a top-level style with no parent style.  To change the color, double-click on the color.  See the Using the Color Selector section for information on choosing your color.

Background Inherited

Properties for Style

Select true or false to determine whether the background for the style will be inherited from the style's parent style.  This property is only displayed for styles with parent styles.

Bad Browser List

Properties for Repository Configuration

The list of browsers that cannot be used to run the entities in this Xephr repository.  If a browser included in this list is used to access an entity in this repository, the Bad Browser Page entity will be displayed instead.  The bad browser list can include a specific browser, such as LYNX or a version of a browser, such as MSIE 3.0.

Bad Browser Page

Properties for Repository Configuration

The name of the entity that should be displayed when the browser that is being used to access an entity in this Xephr repository is included in the Bad Browser List property.  This entity should have the HTML Output Only property set to true and should include no scripted links.

Based On

Creating Entity

Pop-list containing a list of existing templates.  Select the template from which to take the default settings when creating this entity.

Before Save

Properties for Converter
Properties for Report
Properties for Screen

Enter any code that should be run before any queries are executed on this entity.  The code entered here should be written in SQL.

BG Image

Properties for Style

If you have an image that you wish to be displayed in the background for this style, enter the path to the image from the Xephr® server.

Block Name

Adding New Block to (entity)/(block)

Names for all objects are user-defined.  Enter the desired name for the block.

Block Type

Adding New Block to (entity)/(block)

Select the type of block to be created.  The types displayed in this pop-list are determined by the type of entity that is being created or to which a block is being added.  For more information, see the Adding Blocks section for the entity type to which you are adding the block.

Body Style

Properties for Automatic Total Block
Properties for Block

Pop-list containing the styles that have been entered.  The selected style will be used for the body on this block on this screen.  If set to (from parent), the default body style for the screen will be used.

Creating Entity
Properties for Entity
Properties for Template

Pop-list containing the styles that have been entered.  The selected style will be used for the body on this entity.

Bold

Properties for Style

Pop-list indicating whether the text for the style will be displayed as bold.  When this pop-list is set to true, the text for this style will be displayed as bold.  When this pop-list is set to false, the text for this style will be displayed as normal.  For styles with parent styles, set this pop-list to (from parent) to have the setting of this property determined by the parent style.

Border Color

Properties for Style

The selected color for the border for this style is displayed.  The property is displayed when the Border Color Inherited property is set to false or the style is a top-level style with no parent style.  To change the color, double-click on the color.  See the Using the Color Selector section for information on choosing your color.

Border Color Inherited

Properties for Style

Pop-list that determines whether the border for the style will be inherited from the style's parent style.  This property is only displayed for styles with parent styles.

Border Size

Properties for Style

Pop-list indicating the thickness for the bottom border for the style.  For styles with parent styles, set this pop-list to (from parent) to have the setting of this property determined by the parent style.  Choices are

Border Type

Properties for Style

Pop-list containing No Line or Solid Line.  When set to No Line, the style does not have a border.  When set to Solid Line, the style has a border.  For styles with parent styles, set this pop-list to (from parent) to have the setting of this property determined by the parent style.

Bottom Margin

Properties for Report
Properties for Template

The bottom margin for this report or report template, in the measurement unit defined by the Reports Layout Measurements In property.

Bottom Title

Properties for Block

The title to be displayed at the bottom of the chart.

Break Position

Properties for Field

Select the order in which this column will be used when creating breaks.  Only fields with break types have this property.
For example, if you have a break on the customer number field, the sales order number field, and the item number field in a block, and you want the screen or report to first be ordered by customers, then by orders, and then by items on those orders, you would give the customer number field a break position of 1, the sales order number field a break position of 2, and the item number a break position of 3.    The report or screen would then look like this:

Customer  1001A

Order 101

Item A1

Item A2

Order 103

Item A4

Customer 1001B

Order 102

Item A1

Item A3

Break Type

Properties for Field

If a break or total block should be created based on the values in this field, set this pop-list to the desired setting.

C

Category

Creating Datasource

The kind of datasource that you are creating.  Choices are Database Datasource, Xephr Service Datasource, and Xephr Interconnect Datasource.

Chart Title

Adding Block

For Chart Type blocks, enter the title for the chart.

Chart Type

Adding Block
Properties for Block

For Chart Type blocks, select the type of chart that will be displayed in this block.  If you do not know which chart you want to create, choose one, and continue.  You will be able to change it later, if desired.  Choices are:

Collapsible

Adding Block
Properties for Block

Determines whether the records will have a collapsible detail block.  When this property is set to true, at runtime the detail block can be collapsed so that the entire detail block is hidden or can be expanded and displayed.  When this property is set to false, the detail block cannot be hidden and expanded and will always be displayed

Column

Adding Fields to (block name) under Screen: (entity name)

For Standard Block and Chart Block types, this is the column name in the table for which you are creating the block.

Column Names Query

Properties for Datasource

The select statement used to select the column information for a table.  This is used to populate the selection list for simple query blocks for this datasource.

Commit Order

Properties for Block

The number that define the order in which the data in the block will be committed when the record is saved.  The higher the number, the later the block will be saved.

Compress Javascript

Properties for Repository Configuration

Pop-list set to true or false determines whether the javascript functions will be compressed in the entity source.  When set to true, the Xephr functions in the entity source will be compressed into one line to decrease the bandwidth used by the entity.  When set to false, the Xephr functions are expanded in the source to allow them to be read more easily.

Container Id Column

Adding Block
Properties for Block

The column from the complex query or from the table that is used to store the container ID for the record.  The container ID determines in which container the record will be placed when the block is loaded, and is updated when records are moved between containers.

Container Widths (comma separated)

Properties for Block

The width of each container, separated by commas.  The position of the values corresponds to the container for which you are defining the width.  The container widths are relative to the values that you enter here and the width defined for the block.  The values entered are added up and the width of the block is divided by that value, then the appropriate width is applied to each container.  If no values are entered here, all columns are assumed to be the same width.

For example, if you had a three container property, and you entered 1,1,3 in this field, these values would be added together to get 5, then the width of the block would be divided by 5, and the first two containers would be 1/5 of the width value wide, while the third column would be 3/5 of the width value wide.

Content Constraint List (comma separated)

Properties for Block

The number of records that each container can contain, separated be commas.  The position of the value corresponds to which container is restricted.  If the field is left blank, then all columns are unconstrained.

For example, if you had a five container drag drop block, and container 1 was restricted to 10 records, containers 2 through 4 were unrestricted, and container 5 was restricted to 25 records, you would enter 10,,,,25.

Contents

Properties for Field

The data contained in this field, for visible, non-database, non-formula fields.

Copyright

Properties for Repository Configuration

The copyright text to be included in the meta tags for the html generated by the Xephr server.

<META NAME="copyright" CONTENT="xxxxxxxxxxxxxxxxxxxxxxxx">

Create block similar to:

Adding Block

If you wish to create the block based on an existing block on the entity, select the desired block here.  Otherwise, select (none).  This option is only available if you are adding the block to an entity and not another block.

Create Heading

Adding Block

For Standard Block types, this checkbox set to on or off indicates whether a heading will be created for the block.  Set this flag to on to create a heading for the block.  Set this flag to off if you do not want a heading to be created for the block.

Create Join

Adding New Block to (entity)/(block)

For Standard Block types, if there are multiple blocks on the entity and you wish to create joins between the blocks, set this flag to on.

Created On

Properties for Automatic Total Block
Properties for Block
Properties for Database Login
Properties for Datasource
Properties for Entity
Properties for Field
Properties for File
Properties for Format Mask
Properties for Group
Properties for Join
Properties for Link Style
Properties for List of Values
Properties for Menu
Properties for Menu Link
Properties for Paper Size
Properties for Published Entity
Properties for Repository Configuration
Properties for Role
Properties for Style
Properties for Template
Properties for User

The date on which the object was created.

D

Data Type

Creating Format Masks
Properties for Format Mask

The type of field to which this format mask can be applied.  Format masks can be applied to date fields, date and time fields, currency fields, and numeric fields.  For more information, see the Format Masks section.

Database

Properties for Datasource - IBM DB2
Properties for Datasource - PostgreSQL

The name of the database to which this datasource establishes a connection.

Database Name

Properties for Datasource - Microsoft SQL Server

The name of the Microsoft SQL Server database to which you are connecting.  This property is used in the generation of the URL property.

Database Type

Properties for Datasource

The database type for this datasource.  The type selected during creation is displayed and cannot be changed.

Datapoint Label

Properties for Field

The label that will be displayed for this field value on the chart.

Datasource

Adding New Block to (entity)/(block)
Properties for Block

The default datasource for the block.  All entered datasources are displayed.  If set to (from parent), the default for the entity or parent block will be used when this entity is loaded.

The datasource for a Xephr Interconnect block must be a Xephr Interconnect datasource.  Only Xephr Interconnect datasources will be displayed for selection for this property.

The datasource for a Xephr Service block must be a Xephr Service datasource.  Only Xephr Service datasources will be displayed for selection for this property.

Creating Database Logins
Properties for Database Logins

This is the datasource for which you are setting up log ins for the user.  

Creating New Users

On the user properties, this is the default datasource for this user.  All entered datasources are displayed.  This is the datasource from which the data is taken for entities generated for this user.

On the database log in properties, this is the datasource for which you are setting up log ins for the user.  

Creating Entity
Properties for Entity

The default datasource for the entity.  All entered datasources are displayed.  If set to (default), the default for the user's log in will be used when this entity is loaded.

Properties for User

This is the default datasource for this user.  All entered datasources are displayed.  This is the datasource from which the data is taken for entities generated for this user.

Default Catalog

Properties for Datasource

The catalog name that you wish to access in this datasource.

Default Datasource

Properties for Repository Configuration

Select the default datasource for this Xephr instance.  In the datasource hierarchy, this is the datasource that is used when no other datasource is assigned at any level to an entity or object.

Default Directory

Properties for Datasource - Microsoft Excel Database

Enter the default directory for the datasource.

Default LOV Height

Properties for Repository Configuration

The default height for the list of values screens that are opened from fields on screens and parameter forms.

Default LOV Page Size

Properties for Repository Configuration

The default number of rows returned in the list of values screens that are opened from fields on screens and parameter forms.

Default LOV Width

Properties for Repository Configuration

The default width for the list of values screens that are opened from fields on screens and parameter forms

Default Mode

Creating Entity
Properties for Entity

The setting of this pop-list determines which view type will be displayed by default for this entity.
Converter and converter templates: Execute Convert
Data exchange and data exchange templates: Run Report and Parameter Form
Reports and report templates: Run Report and Parameter Form
Screens and screen templates: QBE View, List View, Edit View, and New View
Spreadsheets and spreadsheet templates: Run Report and Parameter Form
XML documents and XML document templates: Run Report and Parameter Form

Default Papersize

Properties for Repository Configuration

Select the default papersize for reports and report templates.  When the papersize pop-list is loaded, this is the papersize that is selected by default.

Default Password

Properties for Datasource - Xephr Interconnect

The password to access the published entities on this host.

Default Printer

Properties for Entity

If the Results Disposition property is set to Print, in the Default Printer property, enter the default printer to which the results will be sent.  The printer name entered must be the exact printer name on the machine on which the report is run.  For shared network printers, it should be entered as the network path to the printer, such as //server/printer_name.

The Xephr global variable XEPHR_PRINTER will override the Default Printer entered here if it is set in the session before the report is run.

*At this time, printing a report automatically is only available for the Microsoft Windows platform and requires that Adobe Acrobat Reader version 8.x be installed on the Xephr server.

Note: ADOBE ACROBAT VERSIONS OTHER THAN 8.x WILL NOT WORK.

Additionally, to make use of this experimental feature it is necessary to manually configure the Xephr service to be able to interact with the desktop. Failure to do this will result in the inability to automatically direct generated reports to a printer.

If you want to print to a shared network printer, you will need to run the Xephr service as a user with the rights to access the shared printer.

Default Report Row Limit

Properties for Repository Configuration

The default number of rows returned on report database blocks.

Default Screen Row Limit

Properties for Repository Configuration

The default number of rows returned on screen database blocks.

Default User

Properties for Datasource - Xephr Interconnect

The user ID to access the published entities on this host.

Default Value

Properties for Field

Enter the default value for this field.  This can be a user-defined value or a reference to a Global Variable.  You cannot enter SQL statements to select information from the database.

Deletable

Properties for Block

Determine whether the data on this block can be deleted when the Delete function is performed on the screen.  When this property is set to true, and the Delete function is performed, the record(s) on the block will be deleted from the database.  When this property is set to false, and the Delete function is performed, the record(s) on the block will not be deleted from the database.

Description

Properties for Automatic Total Block
Properties for Block
Properties for Datasource
Properties for Entity
Properties for Field
Properties for Group
Properties for Link Style
Properties for List of Values
Properties for Menu
Properties for Paper Size
Properties for Style
Properties for Template
Properties for User

Descriptive text for this object.

Properties for Published Entity

Descriptive text for the published XML document.  This value cannot be changed.

Detail

Adding Fields to (block name) under Screen: (entity name)

This flag indicates whether the column will be included as a field on the detail block.  To set the Detail flag for all displayed columns, left-click once on the gray Detail column header.

Display As

Adding Fields to (block name) under Screen: (entity name)

For Standard Block types, this pop-list determines that way that the data for this column will be displayed.  The Field flag must be selected for this column in order for this option to be available for modification.  Choices are:

Button
Checkbox
Client Date
Client DateTime
Default Button
Image
Label
Object
Option List
Password
Reset Button
Text
Text Area
QBE Column Selector and Orderer
Upload File

Properties for Field

Pop-list determines the way that the data for this field will be displayed.  Some of these options are only available under certain circumstances.  Choices are:

Button
Checkbox
Client Date
Client DateTime
Default Button
Image
Label
Object
Option List
Password
Reset Button
Text
Text Area
QBE Column Selector and Orderer
Upload File

Display File As

Properties for Field

Select Link or Image to determine how the file will be displayed on the block.

Display Only

Properties for Block

Pop-list displaying true or false indicates whether the data on this block be displayed as text only and cannot be modified.  

When this pop-list is set to true , the data will be displayed as text only and cannot be modified.  

When this pop-list is set to false, the data will be displayed as form fields by default, but field level settings can override this.

A list is considered to be editable if the block's Display Only pop-list is set to false.

Properties for Field

Pop-list containing true or false indicates whether the data in this field will be display text only.

When this pop-list is set to true, the data will be displayed as text only and cannot be modified.  

When this pop-list is set to false, the data will be displayed as a form field.

Properties for Screen
Properties for Template

Pop-list displaying true or false indicates whether the data on this entity will be displayed as text only and cannot be modified.  

When this pop-list is set to true, the data will be displayed as text only and cannot be modified.  

When this pop-list is set to false, the data will be displayed as form fields by default, but block and field level settings can override this.

Display Text

Properties for Menu
Properties for Menu Link

The text that will display on the parent menu as a link to this entity or menu.

Document Security

Creating Reports

Pop-list indicating the security level for the pdf file for this report.  Choices are:

DSN

Properties for Datasource - Generic ODBC

Enter the DSN for connecting to the database for this datasource.

E

E Mail

Creating New Users

The user's email address.

Edit

Adding New Block to (entity)/(block)

For Standard Block and Chart Block types, checkbox set to on or off indicates whether this field will be included on the Edit mode for this block.

Editability

Properties for Block

The setting of this pop-list determines whether the data in the fields on this block will be editable.

Properties for Field

The setting of this pop-list determines whether the data in this field will be editable.

Editable Field Style

Properties for Automatic Total Block
Properties for Block

Pop-list containing the styles that have been entered.  The selected style will be used for the editable (non display only, non label) fields on this block on this entity. If set to (from parent), the default editable field style for the entity will be used.

Creating Entity
Properties for Entity
Properties for Template

Pop-list containing the styles that have been entered.  The selected style will be used as the default for the editable (non-display only, non-label) fields on this entity.

EMail Address  

Properties for User

The user's email address.

Enforce LOV

Properties for Field

Pop-list set to true or false indicates whether only entries that exist in the assigned list of vales can be entered in the field.  When set to true, the user can only enter values in the field that exist in the assigned list of values.  When set to false, the user can enter values in the assigned list of values, or any other values.

Entity

Properties for Menu Link

The name of the entity that this menu link will open when it is selected on a menu block.

Entity Name

Creating Entity

Names for all objects are user-defined.  Enter the desired name for the new entity.

Executable XML Commit Size

Properties for Repository Configuration

The number rows at a time are committed to the database when doing bulk inserts with Executable XML blocks on XML Documents.

Execute After

Properties for Block

In the Execute After property, enter any SQL statements that should be executed after the query for this block is executed.  Not from Query blocks will not have this property.

• SQL statements entered here must be fully formed and call a procedure (not a function).

• SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.

Execute Before

Properties for Block

In the Execute Before property, enter any SQL statements that should be executed before the query for this block is executed.  Not from Query blocks will not have this property.

• SQL statements entered here must be fully formed and call a procedure (not a function).

• SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.

Execution Mode

Properties for Menu Link

The default mode in which this entity should be opened when this menu link is selected.

Expand Type

Properties for Automatic Total Block
Properties for Block
Properties for Field

Pop-list containing Expandable, Fixed No Scroll Bars, Fixed with Scroll Bars and/or Variable, which defines the size of the block or field.

When set to Expandable, the block or field will be at least the size of the Width and Height values, but it can be larger.

When set to Fixed No Scroll Bars, the block or field will be the exact size defined using the Width and Height values.

When set to Fixed with Scroll Bars for non-report blocks, the block or field will be the exact sized defined using the Width and Height values, but there will be a scroll bar that allows you to scroll up or down within the block or field.  Report blocks do not have this property choice.

When set to Variable for report blocks, the largest that the block will be is the exact sized defined using the Width and Height values, but it will shrink to fit the data displayed in it.  Only report blocks have this property choice.

Example: an address block on a report may be fixed size, while the block for the line items on an invoice will be expandable so that all line items will be visible when the report is generated.

F

Field

Adding Fields to (block name) under Screen: (entity name)

For Standard Block types, this flag indicates whether the column will be included as a field on this block.  To set the Field flag for all displayed columns, left-click once on the gray Field column header.

Field Separator

Properties for Data Exchange
Properties for Template

Pop-list displaying the characters that can be used to separate the columns in the data exchange.  Select the desired character.  For templates, this is the default setting for data exchanges created from the template.  Choices are.

Field Style

Properties for Field

Pop-list containing the styles that have been entered.  The selected style will be used for this field on this block on this screen. If set to (from parent), the default non-editable field style or editable field style for the block will be used, depending on the settings of the field.  Label fields and display only fields will use the non-editable field style from the block.  Other fields will use the editable field style from the block.

File

Uploading Files

The location and the name of the image file that you wish to upload.  You can type the desired location and file into this field manually.  The file structure of your computer is displayed for you to browse through for the file.  Find the directory, and select the file in the directory. The program will enter the selected file into the field.

Filename Column

Properties for Field

Select the column in the database block that contains the file name for the uploaded file.

Filters

Adding Blocks
Properties for Block

Define the additional or overriding filters to restrict the information returned by the select statement for this block, if appropriate.  This is also referred to as the where clause.  The statement begins with the word WHERE.  Not from Query blocks will not have this property.

If the data returned needs to be further restricted, such as by a global variable, this is where you would enter the additional filters for that restriction.

If the No Default Where pop-list is set to true for the block, enter the overriding filters here, beginning with the word WHERE.

For Complex Query blocks, the filters for your complex query are entered here.

First Name

Creating New User
Properties for User

The user's first name.

Font Name

Properties for Style

Pop-list displaying the name of the font that you wish to apply to the foreground text for this style.  For styles with parent styles, you can set this pop-list to (from parent) to have the font determined by the parent style.  Choices are:

Font Size

Properties for Style

Pop-list displaying the size of the font that you wish to apply to the foreground text for this style.  The font size is defined in points.  For styles with parent styles, set this pop-list to (from parent) to have the font determined by the parent style.

Foreground

Properties for Style

The selected color for the foreground text for this style is displayed.  The property is displayed when the Foreground Inherited property is set to false or the style is a top-level style with no parent style.  To change the color, double-click on the color.  See the Using the Color Selector section for information on choosing your color.

Foreground Inherited

Properties for Style

Select true or false to determine whether the foreground text for the style will be inherited from the style's parent style.  This property is only displayed for styles with parent styles.

Form

Adding New Block to (entity)/(block)

For Standard Block types, setting this radio button to on indicates that this block will be created in form style.  Form scheme indicates that label fields and database column fields will be created within the same block and listed from the top to the bottom of the screen.  In general, if only one record will be displayed in the block on the screen, select the Form radio button.

Form is for QBE/New

Properties for Block

The setting of this property indicates to the system whether the block's defined query should be executed and return the database results to the screen.  For New and QBE screens, since we are either entering a query against the database, or inserting a row into the database, we do not want the query to be executed.  If this block will be displayed on the screen in QBE or New mode, this property should be set to true.  If this block will not be displayed on the screen in QBE or New mode, this property should be set to false.  Edit and list blocks should always have this property set to false, even if the block definition contains new rows.

Format

Adding Fields to (block name) under Screen: (entity name)

For Standard Block types, this is the format mask for the data in this field.

Format Mask

Creating Format Masks
Properties for Format Mask

The format mask to be applied to fields.  See the Format Masks section for more information.

Properties for Field

The format mask for the data in this field.  Format masks can be applied to date, date and time, numeric, and currency fields.

Formula

Properties for Field

The formula for this field.  Only fields with the Is Formula pop-list set to true will display this property.

From Block

Properties for Join

The child block for the join.  This is the block for which data display will be affected according to the column value on the To Block.

From Column

Adding New Block to (entity)/(block)

When creating a join, this is the column on the child block (which you are adding) that will be joined to the column on the To Block.  This is the column on the child block that will have its values compared to the column on the To Block.

Properties for Field

The database column from which the data for this field is taken.  This is the column in the query defined in the From Query property from which the data for this field will be obtained.  The value in this field can be changed to another column from the same query.  Only database fields have this property.

Properties for Join

The column on the child block that will be joined to the column on the To Block.  This is the column on the child block that will have its values compared to the column on the To Block.

From Database

Properties for Field

Pop-list containing true or false, indicating whether the data in this field is taken from a database column or not.

From Query

Properties for Field

The block in which the query includes the column from which the data for this field will be obtained.  It is used in conjunction with the From Column pop-list.  Only database fields have this property.

FTP Binary

Properties for Entity

When the Results Disposition property is set to FTP, select true or false.  When set to true, the file will be uploaded using binary transfer mode.  When set to false, the file will be uploaded using ASCII transfer mode.

FTP Directory

Properties for Entity

When the Results Disposition property is set to FTP, enter the directory on the FTP server to which the file will be uploaded.

FTP Host

Properties for Entity

When the Results Disposition property is set to FTP, enter the FTP host to which the results file will be uploaded.

FTP Passive

Properties for Entity

When the Results Disposition property is set to FTP, select true or false.  When set to true, the file will be uploaded to the FTP server using passive mode.

FTP Password

Properties for Entity

When the Results Disposition property is set to FTP, enter the FTP password for logging into the FTP Server.

FTP User

Properties for Entity

When the Results Disposition property is set to FTP, enter the FTP user name for logging into the FTP server.

H

H-Align

Properties for Style

Pop-list indicating how the contents will be laid out horizontally.  For styles with parent styles, set this pop-list to (from parent) to have the setting of this property determined by the parent style.  Choices are:

Header

Adding Fields to (block name) under Screen: (entity name)

This flag indicates whether the column will be included as a field on the header block.  To set the Header flag for all displayed columns, left-click once on the gray Header column header.

Height

Properties for Automatic Total Block
Properties for Block
Properties for Field
Properties for Report
Properties for Screen
Properties for Template

Enter the height for the entity, block, or field.  Screens and their objects have the height entered in pixels.  Reports and their objects have the height entered in the unit of measure determined by the Reports Layout Measurements In property.

Properties for File

The height of the image in pixels.  This value cannot be changed.

Properties for List of Values

The height of the list of values screen in pixels.  This value defaults from the Default LOV Height property for the Repository.

Properties for Paper Size

Enter the height for the paper size in the unit of measure defined in the Units of Measure property.

Hide If

Properties for Block
Properties for Field

Enter the conditions under which this field or block should be hidden when the entity is shown.  When an entry is made in this property, the Show If property will be hidden.  The value entered in this property represents an expression.  When the expression entered in this property evaluates to true, the field will be hidden.  The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block.  (i.e. This does not "watch" user input in a field and dynamically hide a field; everything is locked in when the entity is first output).

The code entered in this field can also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||

Horizontal Padding (in Pixels)

Properties for Block

The number of pixels in between records horizontally within a container.

Host

Properties for Datasource - PostgreSQL

The name of the server on which the database lives.

Properties for Datasource - Xephr Interconnect

The host on which the interconnect entities were published, to which this datasource grants access.

Host Process

Properties for Datasource - Microsoft SQL Server

The process ID of the application connecting to Microsoft SQL Server 2000.  The supplied value appears in the hostprocess column of the sysprocesses table.

Hover Style

Properties for Link Style

Pop-list containing all existing styles. Select the name of the style to use for the Hover state.  If the user has the mouse over a link but has not yet clicked it, the link will be in the Hover state.

HTML Output Only

Properties for Screen

Pop-list set to true or false indicates whether the entity will only be generated with HTML output.  When this property is set to true, no javascript will be output in the entity source code and no scripted links should be used on the screen.  It is recommended that this property be set to true when creating a redirect entity for use when a non-supported browser is used to access an entity in the repository.

Hyperlink Scripted

Properties for Field

Pop-list containing true or  false.  When this pop-list is set to true, it indicates that the entry in the Hyperlink To property is a script.  If you entered a Database Function Calls or a Link between Entities, this pop-list should be set to true.  When this pop-list is set to false, it indicates that the entry in the Hyperlink To property is a direct link and not a script.

Hyperlink To

Properties for Block

For iFrame blocks on screens, enter the URL for the external document that you wish to display in this block.  For example, if you wanted to display the Xephr Online Help in this block, you would enter http://www.ndsapps.com/webhelp/xephr22/

Properties for Field

Enter the HREF value for the link or image.  This is also where Database Function Calls and Links between Entities should be entered.  When possible, relative URL's should be entered (/xephr/show/entity) rather than absolute URL's (http://test1.ndsasp.com/xephr/show/entity).  Only visible fields have this property.

I

Ignore Columns

Properties for Datasource

Enter the names of the columns to be excluded from selection in tables when the column names query is executed during block creation.  Separate column names by commas.  These columns will be completely ignored by Xephr.

Image Location

Properties for Field

The location of the image for this field.  When possible, relative URL's should be entered (/xephr/images/image.gif) rather than absolute URL's (http://ndsdev.xephr.com/xephr/images/image.gif).

Incoming Date Format

Properties for Datasource

Enter the format in java in which the dates are stored in this datasource.  See the Format Masks section for choices.  For example, if this property were set to yyyy-MM-dd then May 20th, 2007 would be stored as 2007-05-20.

Incoming Date/Time Format

Properties for Datasource

Enter the format in java in which date and times are stored in this database, if they are in a field that combines the two.  For example, if this property were set to yyyv-MM-dd HH:mm:ss, then May 20th, 2007 at one thirty pm would be stored as 2007-05-20 13:30:00.

Incoming Time Format

Properties for Datasource

Enter the format in java in which the times are stored in this datasource.  See the Format Masks section for choices.  For example, if this property were set to HH:mm:ss then, one thirty pm would be stored as 13:30:00.

Inherits From

Properties for Entity
Properties for Template

The template from which this entity takes its defaults.  This cannot be changed.

Properties for Style

The style from which the properties the new style default.  If this is a top-level style, this property displays (none).  You cannot change this property, but if you wish to change the parent of a style, you can drag and drop the style object to its new parent within the Explorer Tree.

Initial State

Adding Block
Properties for Block

If the Collapsible property is set to true, this property determines whether the detail block will be displayed initially when the drag drop block is generated.  When set to Collapsed, the records will be loaded on the block with the detail block collapsed and hidden.  When set the Expanded, the records will be loaded on the block with the detail block expanded and displayed.

Instance Name

Properties for Datasource - Microsoft SQL Server

The name of the instance to which you are connecting.  

Interconnect

Properties for Published Entity

Pop-list set to true indicates that the XML document will be used for Xephr Interconnect once it is published.

Interconnect Entity

Adding New Block to (entyt)/(block)
Properties for Block

Select the published entity on which to base the block.  Choices are determined by the published entities on the Xephr Inteconnect datasource selected.

Invalid Access Redirects To

Properties for Entity

The entity to which the user will be redirected if this entity is improperly accessed.  This property is only displayed when the Accessed via property or the Required Roles property is entered.  

For templates, this is the default setting for entities created from the template.

Is Formula

Properties for Field

Select true or false to indicate whether this field contains a formula.  The property is only displayed for visible non-database fields.  When set to true, the field contains a formula, the Formula property is displayed, and the Contents property is removed.  When set to false, the field does not contain a formula.

Is Secure

Properties for Datasource - Xephr Interconnect

If the host and port must be accessed using a secure connection, set this flag to on.  When this flag is set to on, the datasource will connect using https:// protocol

Isolation Level

Properties for Datasource

Select the isolation level for the datasource.  The following choices are available:

No Transaction Isolation: Transactions are not supported.  It is recommended that this option NEVER be selected.

Read Committed: Dirty reads are prevented.  Non-repeatable reads and phantom reads can occur.

Read Uncommitted: Dirty reads, non-repeatable reads, and phantom reads can occur.

Repeatable Read: Dirty reads and non-repeatable reads are prevented.  Phantom reads can occur.

Serializable: Dirty reads, non-repeatable reads, and phantom reads are prevented.

Italics

Properties for Style

Pop-list containing true or false indicating whether the foreground text for this style will be displayed in italics.  When set to True, the foreground text is displayed in italics.  When set the False, the foreground text is displayed normally.  For styles with parent styles, set this pop-list to (from parent) to have the setting of this property determined by the parent style.

K

Key

Adding Fields to (block name) under Screen: (entity name)

For Standard Block types, checkbox set to on or off indicates whether this column is a primary key for the table/view.  

For Chart Block types, checkbox set to on or off indicates whether this column will be included in creation of the chart.  

Key Field

Properties for Field

Pop-list displaying true or false indicating whether this field is a primary key for the view.

Key Required

Adding Fields to (block name) under Screen: (entity name)

For Standard Block types, checkbox set to on or off indicates whether a column must be selected as a key for the new block.  This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on.  The [Next] button cannot be pressed until the key column is selected or this flag is set to off.

L

Label

Adding Fields to (block name) under Screen: (entity name)

For Standard Block types, this flag indicates whether a label should be created for the column on this block.  To set the Label flag for all displayed columns, left click once on the gray Label column header.

Last Name

Creating New Users
Properties for User

The user's last name.

Left Margin

Properties for Report
Properties for Template

The left margin for this report or report template, in the measurement unit defined by the Reports Layout Measurements In property.

Left Margin (in Pixels)

Properties for Block

The number of pixels in the margin between the left side of the container and the left side of the record in the container.

Left Title

Properties for Block

The title to be displayed at the left of the chart.

Legend

Properties for Block

If you wish to have a legend displayed on the chart, select the location for the legend to be displayed.  Choices are (none), Top, Bottom, Left, or Right.

Link

Adding Fields to (block name) under Screen: (entity name)

For Bread Crumb block creation, set this flag to on for the column that will be displayed as the link on the bread crumb block.  Only one column can have this flag set to on.

Link Style

Properties for Automatic Total Block
Properties for Block

Pop-list containing the link styles that have been entered.  The selected style will be used for the links on this block on this screen.  If set to (from parent), the default link style for the screen will be used.

Properties for Field

Pop-list containing the link styles that have been entered.  The selected style will be used for this link on this block on this screen.  If set to (default), the default link style for the block will be used.

Creating Entity
Properties for Entity
Properties for Template

Pop-list containing the link styles that have been entered.  The selected style will be used as the default for links on this entity.

List

Adding New Block to (entity)/(block)

In the Mode section, for Standard Block and Chart Block types, checkbox set to on or off indicates whether this field will be included on the List mode for this block.

In the Scheme section, for Standard Block types, setting this radio button to on indicates that the block will be created in list style.  List scheme indicates that label fields and database column fields will be created in different blocks and listed from the left to the right of the screen.  In general, if multiple records will be displayed in the block on the screen, select the List radio button.

List of Values

Properties for Field

Pop-list containing the lists of values that have been created.  Select the list of values that will be used for this field.  When set to List of Values, the Display As property will only allow you to select Text Area or Text.

Login

Creating New Users
Properties for User

The login for this user.  This is the user ID for this user when logging into the Xephr Studio or Runtime.

Properties for Published Entity
Publishing Entities

The log in that must be used to gain access to this entity once it is published.  This is an optional property.

Login Entity

Properties for Repository Configuration

The entity displayed when user authentication is required, used to log into the Xephr Runtime.

Lov Style

Properties for Entity

Pop-list containing the link styles that have been entered.  The selected style will be used as the default for lists of values that are activated from fields on this entity.

M

Max Active

Properties for Datasource

The total number of connections that can be created in the connection pool for this datasource.

Max Idle

Properties for Datasource

The total number of idle connections that can exist in the connection pool for this datasource.

Max Number of Rows

Properties for Block

For blocks with the Query Type set to Simple Query or Complex Query, this is the maximum number of rows that will be displayed on the screen for this block.  If this property is set to 0, the system wide restriction of 200 rows will be used.  

Max Wait

Properties for Datasource

The length of time to wait for a connection in milliseconds for this datasource.

Menu Name

Properties for Menu

The name of the menu.

Middle Initial

Creating New Users
Properties for User

The user's middle initial.

Min Evictable Idle Time

Properties for Datasource

The number of milliseconds for which a connection can be idle before it can be considered for eviction from the connection pool.

Modified On

Properties for Automatic Total Block
Properties for Block
Properties for Database Login
Properties for Datasource
Properties for Entity
Properties for Field
Properties for File
Properties for Format Mask
Properties for Group
Properties for Join
Properties for Link Style
Properties for List of Values
Properties for Menu
Properties for Menu Link
Properties for Paper Size
Properties for Published Entity
Properties for Repository Configuration
Properties for Role
Properties for Style
Properties for Template
Properties for User

The date on which the object was last changed.

Mutability

Properties for Block

Pop-list with containing Fully Mutable, Positionally Mutable, and Not Mutable.  This property is only available for blocks on templates.

N

Name

Creating New Users
Creating New Global Variables
Properties for Global Variables

The name of the global variable that will be created and to which a value will be assigned when the users logs into Xephr.

Properties for Automatic Total Block
Properties for Block
Properties for Datasource
Properties for Entity
Properties for Field
Properties for File
Properties for Group
Properties for Join
Properties for Link Style
Properties for List of Values
Properties for Paper Size
Properties for Role
Properties for Style
Properties for Template

Names for all objects are user-defined.  Enter the desired name for the object.

Net Address

Properties for Datasource - Microsoft SQL Server

The MAC address of the network interface card of the applications connecting to Microsoft SQL Server 2000.  The supplied value appears in the net_address column of the sysprocesses table.  

New

Adding New Block to (entity)/(block)

For Standard Block and Chart Block types, checkbox set to on or off indicates whether this field will be included on the New mode for this block.

New Rows First

Properties for Block

Pop-list containing true or false indicates where new rows will be displayed on editable lists.

If set to true, the new rows will be displayed at the top of the block, before the existing rows are displayed.  

If set to false, the new rows will be displayed at the bottom of the block, after the existing rows are displayed.  This pop-list can only be used with editable lists.

New Window

Properties for Menu

Pop-list set to true or false indicates whether the link will open the entity in a new browser window or the same browser window.  When set to true, the entity will open in a new browser window.  When set to false, the entity will open in the current browser window.

Properties for Menu Link

Pop-list containing true or false indicates whether this entity will be opened in a new window when the menu link is selected.

Non-Editable Field Style

Properties for Automatic Total Block
Properties for Block

Pop-list containing the styles that have been entered.  The selected style will be used for the non-editable (labels and display only) fields on this block on this entity. If set to (from parent), the default non-editable field style for the entity will be used.

Creating Entity
Properties for Entity
Properties for Template

Pop-list containing the styles that have been entered.  The selected style will be used as the default for the non-editable (labels and display only) fields on this entity.

Normal Style

Properties for Link Style

Pop-list containing all existing styles.  Select the name of the style to use for the Normal state. The Normal state is any link that is not the Visited, Active, or Hover state.

Num New Rows

Properties for Block

The number of new rows for editable list entities.

Number of Containers

Adding Block
Properties for Block

The total number of containers that will be displayed in the block, between which records can be moved.

O

On Edit

Properties for Block

Pop-list set to true or false indicates whether this block will be included on the Edit view for this screen.

Properties for Field

Pop-list set to true or false indicates whether this field will be included on the Edit view for this block.

On Got Focus

Properties for Field

Enter any javascript actions that should be taken when the focus is placed on this field.  

On List

Properties for Block

Pop-list set to true or false indicates whether this block will be included on the List view for this screen.

Properties for Field

Pop-list set to true or false indicates whether this field will be included on the List view for this block.

On Load  

Properties for Entity

Enter any javascript code that should be run when the screen is loaded.

On Lost Focus

Properties for Field

Enter any javascript actions that should be taken when the focus leaves this field.  

On Mouse Click

Properties for Field

Enter any javascript actions that should be taken when the mouse clicks on this field.

On New

Properties for Block

Pop-list set to true or false indicates whether this block will be included on the New view for this screen.

Properties for Field

Pop-list set to true or false indicates whether this field will be included on the New view for this block.

On QBE

Properties for Block

Pop-list set to true or false indicates whether this block will be included on the QBE view for this screen.

Properties for Field

Pop-list set to true or false indicates whether this field will be included on the QBE view for this block.

Operator

Properties for Join

The Operator determines how the filter will be formed when determining the data displayed on the child block.  Choices are:
Equal - where a = b
Not Equal - where a != b
Less Than - where a < b
Less Than or Equal - where a <= b
Greater Than - where a > b
Greater Than or Equal - where a >= b
Like - where a like b
Not Like - where a not like b

Ordering and Grouping

Adding Blocks
Properties for Block

Enter any code to be executed after the filters, such as the order by or group by.  Not from Query blocks will not have this property.  This property can be entered for both Simple Query and Complex Query types.

Format: ORDER BY column, column, column
Format: GROUP BY column, column, column
For example: ORDER BY description, stock_um, qty_on_hand desc

Orientation

Creating Reports
Properties for Report
Properties for Template

Select the orientation of the report.  Choices are Portrait or Landscape.  
When creating a new report, this property can only be changed if you are creating a report template that is not based on another report template.

Outgoing Date Function

Properties for Datasource

Enter the database specific code to format a date to pass it back to the datasource.  The values surrounded by the $$ is the java date format to use in the code to format the dates being passed to the database.  The code within this property is used to convert the data in Date fields to be accepted by the datasource.

Outgoing Date/Time Function

Properties for Datasource

Enter the database specific code to format a date and time combined to pass it back to the datasource.  The values surrounded by the $$ is the java date and time format to use in the code to format the dates and times being passed to the database.  The code within this property is used to convert the data in Date and Time fields to be accepted by the datasource.

Outgoing Time Function

Properties for Datasource

Enter the database specific code to format a time to pass it back to the datasource.  The values surrounded by the $$ is the java time format to use in the code to format the time being passed to the database.  The code within this property is used to convert the data in Time fields to be accepted by the datasource.

Owner Password

Properties for Report
Properties for Template

Enter the password necessary to obtain full access to the pdf file.  If no entry is made, a random password will be used to generate the pdf file.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption.  Full access means that the owner's abilities are not restricted by the settings of the Allow flags.

P

Pad Fields

Properties for Data Exchange
Properties for Template

Pop-list set to true or false indicates whether fields in the data exchange will be padded to be equal in length with the longest value in the database column.  For templates, this is the default setting for the data exchange entities created from the template.

Page Break Before

Properties for Block

For report blocks, pop-list indicates whether a page break will be placed in the report before this block is generated.

Paper Size

Creating Reports
Properties for Report
Properties for Template

Pop-list indicating the paper size for this report.  Paper sizes are defined within the Paper Size object in the Explorer Tree.

Param XXXX

Properties for Block

The XXXX stands for the name of the parameter.   

For Xephr Service blocks, parameters are dependent on the Datasource and Table property settings and are used to restrict the values returned from the Xephr service.

For Xephr Interconnect blocks, parameters are dependent on the Interconnect Entity selected and are used to restrict the values returned from the published entity.

Parameter Screen Height

Properties for Data Exchange
Properties for Report
Properties for Spreadsheets
Properties for Template
Properties for XML Documents

For Reports, the height in the report's defined measurement units for the parameter form created for this report.
For Data Exchanges, Spreadsheets, and XML Documents, the height in pixels for the parameter form created for this entity.

Parameter Screen Width

Properties for Data Exchange
Properties for Report
Properties for Spreadsheets
Properties for Template
Properties for XML Documents

For Reports, the width in the report's defined measurement units for the parameter form created for this report.
For Data Exchanges, Spreadsheets, and XML Documents, the width in pixels for the parameter form created for this entity.

Parent

Adding New Block to (entity)/(block)

This property displays the object to which this block is being added.  The name of the object is displayed, followed by the object type in parentheses.  For example, if the block was being added to an entity named STOCK, this property would display STOCK (Entity).  

Properties for Automatic Total Block
Properties for Block

The name of the parent object for this block.

Passthrough Columns

Properties for Datasource

Enter the names of columns to be excluded from selection in tables when the column names query is executed during block creation, but which will be passed through during transactions.  These are columns used for transparent record versioning schemes

Password

Creating New Database Logins
Properties for Database Logins

The password for this user to log into the database associated with this datasource.  

Creating New Users

On the user properties, the password for this user.  This is the password entered when logging into the Xephr Studio or Runtime.

On the database log in properties, the password for this user to log into the database associated with this datasource.  

Log In

Enter the password for this user to connect the server and log into Xephr Studio.

Properties for Datasource

The password used to log into the database for this datasource and user.  The password will be hidden as a series of fourteen asterisks.

Properties for Published Entity
Publishing Entities

The password that must be used to gain access to this entity once it is published.  This is an optional property.

Properties for User

The password for this user.  This is the password entered when logging into the Xephr Studio or Runtime.

Path to File

Properties for Datasource - Microsoft Access Database

The file name for the Microsoft Access Database, including the directory path to access the file from the Xephr server.

Properties for Datasource - Microsoft Excel Database

The file name for the Microsoft Excel file, including the directory path to access the file from the Xephr server.

Policies

Properties for Role

The list of the policies assigned to the role are displayed.  The policies that are assigned to this role via other roles are not displayed here.  These policies are assigned in addition to those already granted by other roles.

Properties for User

The list of the policies assigned to the user are displayed.  The policies that are assigned to this user via roles are not displayed here.  These policies are assigned in addition to those already granted by roles.

Port

Properties for Datasource - IBM DB2 Datasource
Properties for Datasource - Microsoft SQL Server
Properties for Datasource - Oracle 9i
Properties for Datasource - PostgreSQL

The port number on the server to which the driver must connect in order to access this database.

Properties for Datasource - Xephr Interconnect

The port number to use on the host to access the published entities.

Process using Entity

Properties for Field

If the contents of the uploaded file will be processed by an entity during upload, select the entity.

Proxy Port

Properties for Datasource - Xephr Interconnect

The proxy server port through which you will make the connection.

Proxy Server

Properties for Datasource - Xephr Interconnect

If it is necessary to use a proxy server to gain http (web) access for your environment, in the Proxy Server property, enter the proxy server URL through which you are making the connection.

Published Entity

Properties for Published Entity

The name of the XML document that was published.  This value cannot be changed.

Q

QBE

Adding New Block to (entity)/(block)

For Standard Block and Chart Block types, checkbox set to on or off indicates whether this field will be included on the QBE mode for this block.

Query

Properties for List of Values

The SQL query text for this list of values.

Query for New

Properties for Block

Enter the select statement for this block when the entity is in New/QBE mode to set the default value. However, it is recommended in most instances that you set the default values at the field level using the Default Value property of each field instead of setting them here.  Not from Query blocks will not have this property.

Query Type

Properties for Block

Select the type of query that this block will execute against the database.   Choices are Not from Query, Simple Query, Complex Query, Xephr Service, and Xephr Interconnect.

Quote Strings

Properties for Data Exchange
Properties for Templates

Pop-list displaying true or false to indicate whether the character strings in the data exchange template will have quotes surrounding them in the data exchange.  For templates, this is the default setting for the data exchanges created from the template.

R

Read Only

Properties for Datasource

Pop-list containing true or false, indicating whether this datasource is read only.  When set to true, transactions can be read from the database, but not written to the database.  When set to false, transactions can be both read from and written to the database.

Properties for Published Entity

Pop-list set to true indicates that the XML document will be read only when it is published.

Properties for Screen
Properties for Template

Pop-list containing true or false, indicating whether this entity is read only.

Publishing Entities

Checkbox set to on indicates that the XML document will be read only when it is published.

Read Only Containers (comma separated)

Properties for Block

The container numbers that are read only for the Drag Drop block, separated by commas.  Records in read only containers cannot be dragged from the container and dropped into another container.  In addition, records from other containers cannot be dropped into a read only container.  

For example, if you had a five container drag drop block, and containers 1 and 5 were read only, you would enter 1,5 in this property

Record Separator

Properties for Data Exchange
Properties for Template

Pop-list containing the characters that will separate the records in the data exchange.  For templates, this is the default setting for the data exchanges that are created from this template.  Choices are:

Reports Layout Measurements In

Properties for Report
Properties for Template

Pop-list containing the allowed measurement units for this report or report template.  Choices are Inches, Millimeters, or Points.

Requests Focus

Properties for Field

Pop-list containing true or false.  When the pop-list is set to true for a field, the cursor will start in that field when the entity is generated.  Multiple fields can have this property set to true.  If this occurs, then the entity generator determines at random the field that is selected first.

Require SSL

Properties for Published Entity

If this published entity requires an SSL connection in order to be accessed, set this pop-list to true

Required

Properties for Field

Pop-list containing true or false.  When this pop-list is set to true, an entry must be made in this field.

Required Globals

Properties for Entity

List the global variables that are required to be set in order for the entity to run properly, separated by a line break.  If the entity is run, and some or all of these globals are missing, the entity will not be run.  The format is GLOBAL or, if desired, GLOBAL = VALUE.  

For example, if the global variables ORG_UNIT_ID and EMPNO must be set for the entity to run correctly, you would enter
ORG_UNIT_ID
EMPNO

If the global variable ORG_UNIT_ID needed to have the value 100, but it didn't matter what the EMPNO value needed to be, you would enter
ORG_UNIT_ID = 100
EMPNO

Required Roles

Properties for Entity

Select the roles that are required to run the entity.  When running this entity, the user must have at least one of the roles entered here, or the entity will not run, and the user will be returned to the log in screen.

When you click on this field, a pop-up will be displayed with the available roles in the left side of the pop-up and the roles assigned to the entity on the right side.  

To assign a role to the entity, select the desired role on the left side, and then click on the >> button to move it to the right side.  

To unassign a role, select the desired role on the right side and then click on the << button to move it to the left side.  

When all desired roles have been assigned, click on the Apply button.

The Invalid Access Redirects To property will be displayed to allow you to define the entity that should be displayed for the user if the user does not have one of the required roles entered here.  

Results Disposition

Properties for Entity

Select Return to Caller, FTP, EMail, Store as File, or Print.  

When Return to Caller is selected the results to the query will be returned to the calling browser.  

When FTP is selected, the results to the query are sent as a file to a defined FTP server.  Additional properties are displayed when FTP is selected.

When EMail is selected, the results to the query are sent as a file to the defined email addresses.  Additional properties are displayed when EMail is selected.

When Store as File is selected, the results to the query are sent as a file to the defined location.  Additional properties are displayed when Store as File is selected.

When Print is selected, the results to the query will be sent to the default printer.  Additional properties are displayed when Print is selected.  

Right Margin

Properties for Report
Properties for Template

The right margin for this report or report template, in the measurement unit defined by the Reports Layout Measurements In property.

Roles

Properties for Role

The roles assigned to this role.

Properties for User

The roles assigned to this user.

Rollover Count

Properties for Image Field

If you are using action images, this is the number of states that you have in your combined image.  For more information, see the Action Images section.

Rollover Horizontal

Properties for Image Field

If you are using action images, select true or false to indicate the set up of the combined images.  

If they are combined vertically, set this property to false.  
If they are combined horizontally, set this property to true.

For more information, see the Action Images section.

Rows per Page

Properties for List of Values

The number of rows returned in the list of values screen opened from fields on screens and parameter forms.  This value defaults from the Default LOV Page Size property for the Repository.

Run As

Properties for Published Entity

The user that was used to generate the XML document when it was published.

Publishing Entities

The user that will be used to generate the XML document when it is published.

S

Search Characteristics

Properties for Field

For fields on QBE blocks, set the Search Characteristics property to the desired setting.  Choices are:

Secure

Properties for Datasource - Xephr Interconnect

If the host and port must be accessed using a secure connection, set this property to true.  When this flag is set to true, the datasource will connect using https:// protocol.

Secure Document

Properties for Report
Properties for Template

Pop-list indicating the security level for the pdf file for this report.  Choices are:

Select Entity Type

Creating Entity

Set one of these radio buttons to on to indicate which kind of entity you are creating.  Choices are Screen, Report, Data Exchange, Spreadsheet, XML.

Select Method

Properties for Datasource - Microsoft SQL Server

Either cursor or direct.  Direct is the default select method, but Cursor is the recommended method.  For descriptions of the difference between the two, consult your Microsoft SQL Server 2000 Driver for JDBC Users Guide and Reference manual provided with the JDBC driver.  

Select Statement

Adding Blocks
Properties for Block

Enter the select statement for your database query, beginning with the word SELECT.  The select statement lists the columns in the table or view from which the data will be returned.  Not from Query blocks will not have this property.  Simple Query blocks will have the data in this property generated automatically, while Complex Query blocks require that the user enter the select statement.

Format: SELECT column, column, column, column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM item_master_uvw

Select the Mode/s in which the blocks have to be shown

Adding New Block to (entity)/(block)

For Standard Block and Chart Block types, select the mode(s) in which this block will be displayed for this screen.  There are four flags here, one for each mode - QBE, List, Edit, New.  For each mode in which you wish the block to be displayed, set the flag to on.  For each mode in which you do not wish the block to be displayed, set the flag to off. Mode(s) may be grayed out if they are not available to be selected.  

Select the scheme for the new block:

Adding New Block to (entity)/(block)

For Standard Block types, select one of the radio buttons to determine whether the block will be created in form style or list style.  Choices are Form and List.  Form scheme indicates that label fields and database column fields will be created within the same block and listed from the top to the bottom of the screen.  List scheme indicates that label fields and database column fields will be created in different blocks and listed from the left to the right of the screen.  In general, if only one record will be displayed in the block on the screen, select the Form radio button.  If multiple records will be displayed in the block on the screen, select the List radio button.

Selected Tab Style

Properties for Block

If the block is a Tab Block, this pop-list determines the style of the tabs when they are selected.  The pop-list contains all of the styles that have been entered.  

Separator

Adding New Block to (entity)/(block)
Properties for Block

If the block is a Bread Crumb block, and the Separator Type is Image, enter the file path from the Xephr server to the image that will be used as a separator between bread crumb fields.  If the Separator Type is Text, enter the text character(s) that will be used to separate the bread crumb fields.

Separator Type

Adding New Block to (entity)/(block)
Properties for Block

If the block is a Bread Crumb block, this pop-list determines whether the separator between the bread crumb fields is an image or a text character.  Select Image or Text.

Server

Log In

Pop-list containing the available servers.  Select the server to which you are connecting to run Xephr.

Properties for Datasource - IBM DB2 Datasource
Properties for Datasource - Microsoft SQL Server
Properties for Datasource - Oracle 9i

Enter the name of the server on which this database lives.  

Session Timeout (minutes)

Properties for Repository Configuration

Enter the number of minutes for which a runtime session for this repository is active, if there has been no activity in that session, before the user has to log in again.  The number of minutes entered here cannot be greater than 240 (4 hours), which is the server setting for session time outs.

Show If

Properties for Block
Properties for Field

Enter the conditions under which this field or block should be displayed when the entity is shown.  The field or block will be hidden unless these conditions are met.  When an entry is made in this property, the Hide If property will be hidden. When the expression entered in this property evaluates to true, the field will be displayed.  The evaluation of the expression occurs when the entity is generated, and not when the user is making modifications to fields on the block.  (i.e. This does not "watch" user input in a field and dynamically show a field; everything is locked in when the entity is first output).

The code entered in this field can also include and/or expressions:
And is indicated by two ampersands &&
Or is indicated by two vertical lines ||

Show if Empty

Properties for Block

Pop-list set to true or false indicates whether this block should be displayed if there is no data in the block.  

When this pop-list is set to true, the block will be displayed when there is no data within the block.  

When this pop-list is set to false, the block will be suppressed when there is no data within the block.

Show On

Properties for Field
Properties for Block

For Report blocks and fields, this pop-list indicates whether the block or field will be generated on all pages of the report.  Choices are All Pages, First Page Only, and All But First.

SID

Properties for Datasource - Oracle 9i

Enter the service identifier (SID) for the database.  

Size

Properties for Field

The maximum size for data in this field in characters

Standard

Properties for Paper Size

Pop-list set to true or false indicates whether or not this papersize was provided by Xephr.  All user-created papersizes will have this property set to false.  Papersizes with this Standard property set to true cannot have their Width, Height, and Units of Measure properties cannot be changed.

Start Page

Creating New Users

The first entity to be generated for this user after this user logs into the Xephr Runtime.

Starting Page

Properties for User

The first entity to be generated for this user after this user logs into the Xephr Runtime.

Style

Adding Fields to (block name) under Screen: (entity name)

For Standard Block types, this pop-list contains the styles that have been created in this datasource.  The selected style will be used for this field on this block on this screen. If set to (from parent), the default field style for the block will be used.

Support

Adding Fields to (block name) under Screen: (entity name)

For Bread Crumb block creation, set this flag to on for all columns that need to be included on the block to support the link column.  The column selected as the Link column cannot have the Support flag set to on.

Suppress Duplicate Totals

Properties for Report
Properties for Template

Pop-list indicating whether duplicate totals will be suppressed on the automatic totalling blocks of this report.  When set to true, if the report has an automatic totalling block, and multiple totals are defined for the automatic totalling block, if all of the totals are the same, all but the last total will be suppressed.  For example, if the automatic totalling block is for customer and item, and a customer has only ordered one item with a quantity of 10, instead of showing two totals, one for the item quantity of 10 and one for the customer with a quantity of 10, you will only see one total for the customer with a quantity of 10.  When set to false, duplicate totals will not be suppressed.

Suppress on CSO

Properties for Field

Pop-list set to true or false indicates whether the field will be included in the column selector.  When set to true, the field will not be included in the column selector and will be displayed or hidden on the list block according to its property settings.  When set to false, the field will be included in the column selector and will be displayed or hidden on the list block according to whether or not it is selected.

Suppress Totals

Properties for Automatic Total Block

Pop-list indicating whether the total block will be suppressed on this report.  When set to true, the total block will be suppressed.  When set to false, the total block will be displayed.

Swap Rows/Columns

Properties for Block

Pop-list indicating how the rows and columns will be displayed on the chart.  When set to true, the location of the rows and columns displayed on the chart will be switched. The display differs for each chart type.

System Database

Properties for Datasource - Microsoft Access Database

Enter the database name for the datasource.

T

Tab Title

Properties for Block

When the parent of the block is a Tab Block, this is the text that will be displayed in the tab for this block.

Tab Type

Properties for Block

If the block is a Tab Block, this pop-list determines the shape of the tabs created for the block.  Choices are:

Angle
Full Round
Half Round
Notched
Oval
Square

Table

Adding New Block to (entity)/(block)

Available for Standard Block and Chart Block types, this pop-list contains the available tables in the database or Xephr Service.  Set this pop-list to the desired table for the new block.  The values in this field are determined by the Table Query for the datasource.  

Properties for Block

Pop-list containing available tables in the database.  Set this pop-list to the desired table for this block.  If this block is not based on a database table, set this pop-list to (none).  The values in this field are determined by the Table Query for the datasource.  Only Simple Query blocks will have this property when modifying blocks.

Table Selected

Adding Fields to (block name) under Screen: (entity name)

The name of the table or view selected when creating the block, from which the columns for the block will be selected.

Table Query

Properties for Datasource

The SQL statement used to populate the list of tables available when creating a new block.

Target Column

Properties for Field

For fields on parameter forms, select the block and field on the report that will be restricted by the value entered in this field on the parameter form.  For more information, see the Parameter Forms section.  If the block is a QBE block from which a spreadsheet will be generated for the list results, select the block and field on the spreadsheet that will be restricted by the value entered in this field on the QBE block.  For more information, see the Spreadsheet Generation for Query Results section.

Target Entity

Properties for XML Documents

The name of the entity on the target host to which the executable XML output will be passed.

Target Host

Properties for XML Documents

The server to which the XML document output will be sent for executable XML documents.  For example, if you wanted to pass the output of this XML document to another Xephr server.

Target is Secure

Properties for XML Documents

Pop-list set to true or false indicates whether the target host is secure and will need to be connected to using SSL.  When this property is set the true, the target host will be connected to using SSL.  

Target Login

Adding New Block to (entyt)/(block)
Properties for Block

The user ID that will be used to access the published entity.

Target Password

Adding New Block to (entyt)/(block)
Properties for Block

The password that will be used to access the published entity.

Properties for XML Documents

The password for connecting to the target host.  The password will be hidden as a series of fourteen asterisks.

Target User

Properties for XML Documents

The user name for connecting to the target host.

Test on Borrow

Properties for Datasource

Pop-list set to true or false indicates whether connections are tested for validity when they are borrowed from the connection pool.  When set to true, when a connection is borrowed from the connection pool, it is tested to make sure it is a valid connection.  When set to false, it will not be tested.  When set to true, this property may have some impact on performance, but it verifies that the database connections are always valid.

Test on Return

Properties for Datasource

Pop-list set to true or false indicates whether connections are tested for validity when they are returned to the connection pool.  When set to true, when a connection is returned to the connection pool, it is tested to make sure it is a valid connection.  When set to false, it will not be tested.  When set to true, this property may have some impact on performance, but it verifies that the database connections are always valid.

Tests Per Eviction Run

Properties for Datasource

The number of connections that can be tested for eviction each time an eviction run occurs.  This is the maximum number of connections that can be removed from the connection pool each time the eviction run occurs.

Test While Idle

Properties for Datasource

Pop-list set to true or false indicates whether connections are tested for validity while they are idle in the connection pool.  When set to true, when a connection is idle in the connection pool, it is tested to make sure it is a valid connection.  When set to false, it will not be tested.  When set to true, this property may have some impact on performance, but it verifies that the database connections are always valid.

Text Case

Properties for Field

The case for the data displayed in this field can be restricted to None, Uppercase, or Lowercase.

Time Between Eviction Runs

Properties for Datasource

The number of milliseconds between each eviction run.  During an eviction run, the connection pool is tested for idle connections.  The number of connections discarded is up to the number defined in the tests per eviction run property.

Title

Properties for Entity
Properties for List of Values
Properties for Template

The title for this object.  For Lists of Values, Screens, and Reports, this is the text displayed in the explorer bar when the object is generated.

To Block

Adding New Block to (entity)/(block)

When creating a join, this is the parent block for the join.  This is the block from which the data will be obtained for the value comparison with the column on the child block (which you are adding).

Properties for Join

The parent block for the join.  This is the block from which the data will be obtained for the value comparison with the column on the From Block.

To Column

Adding New Block to (entity)/(block)

When creating a join, this is the column on the parent block for the join.  This is the column that will have its value compared with the From Column to determine the data displayed on the child block (which you are adding).

Properties for Join

The column on the parent block for the join.  This is the column that will have its value used to determine the data displayed on the child block.

Tool Tip

Properties for Field

Normally used for images, when an entry is made in this field, and the user hovers over the field in the browser with the mouse, the data entered here is displayed.  Although offered for all field types, the browser on which the user is running the entity on will determine whether the tool tip is displayed for field types other than image.

When a field is required, and not entered, the entry in the tool tip is displayed as the field identifier when the required message is displayed.  For example, if the column name was CUST_NO and the tool top for the column was Customer Number, the required message displayed would be "Customer Number is a required field."  If the tool tip was blank, the required message displayed would be "CUST_NO is a required field".

Top Margin

Properties for Report
Properties for Template

The top margin for this report or report template, in the measurement unit defined by the Reports Layout Measurements In property

Top Margin (in Pixels)

Properties for Block

The number of pixels in the margin between the top of the container and the top of the first record in the container.

Top Title

Properties for Block

The title to be displayed at the top of the chart.

Type

Properties for Automatic Total Block

The type cannot be changed for an automatic total block, and displays Automatic Totals.

Properties for Block

For Converter blocks, the type can be Execute Convert.

For Data Exchange blocks, Spreadsheet blocks, and XML Document blocks, the type can be Standard Block or Parameter Form.

For Report blocks, the type of block can be Standard Block, Parameter Form, or Chart Block.

For Screen blocks, the type of block can be Standard Block, Tab Block, Chart Block, Bread Crumb, or iFrame.

Properties for Datasource

Select the database type for this datasource.  Choices are dependent on the Category:

Database Datasource

IBM DB2
Microsoft SQL Server
Oracle 9i
PostgreSQL
Microsoft Excel (via DSN-less ODBC)
Microsoft Access (via DSN-less ODBC)
Generic ODBC (using DSN)

Xephr Service Datasource

Xephr User Maintenance
Xephr Menus

Xephr Interconnect Datasource

Remote Xephr Entity

Properties for Field

Pop-list containing the type of data displayed in this field.  

For fields on screens and report blocks, choices are: Text, List of Values, HRef Link, Date, Currency, Numeric

For fields on spreadsheet blocks, choices are Currency, Date, Numeric, and Text.

For fields on chart blocks, choices are Text, Database Value, and Database Label.

U - V

Underlined

Properties for Style

Pop-list containing true or false, indicating whether the foreground text for this style is underlined or not.  When this pop-list is set to true, the foreground text will be underlined.  When this pop-list is set to false, the foreground text will be normal.  For styles with parent styles, set this pop-list to (from parent) to have the setting of this property determined by the parent style.

Units of Measure

Properties for Paper Size

Pop-list containing the allowed measurement units for the paper size.  Choices are Inches, Millimeters, or Points.

Unselected Tab Style

Properties for Block

If the block is a Tab Block, this pop-list determines the style of the tabs when they are not selected.  The pop-list contains all of the styles that have been entered.  

Use Common User Javascript

Properties for Repository Configuration

Pop-list containing true or false.  When set to true, the Xephr repository will recognize user-defined javascript functions stored in the _common.js file in the templates/userdefined/javascript folder of your Xephr install.

If you set this property to true, you should verify that this file exists or your logs will show errors about the missing files.

Use Common User Styles

Properties for Repository Configuration

Pop-list containing true or false.  When set to true, the Xephr repository will recognize user-defined styles stored in the _common.css file in the templates/userdefined/styles folder of your Xephr install.

If you set this property to true, you should verify that this file exists or your logs will show errors about the missing files.

Use Image Size

Properties for Field

When set to false, the Image field will be created with the width and height entered on the property sheet.  When set to true, the Image field will be created with the image's width and height.

Use List of Values Filter

Properties for Field

If the list of values was created using the filter List of Values feature, set this pop-list to True.  Otherwise set the pop-list to False.

Use New Window

Properties for Field

Pop-list containing true or false.  If this pop-list is set to true, when the user clicks on the link, the link will open in a new browser window.  If this pop-list is set to false, when the user clicks on the link, the link will open in the current browser window.

Use Repository User Javascript

Properties for Repository Configuration

Pop-list containing true or false.  When set to true, the Xephr repository will recognize user-defined javascript functions stored in the repository_name.js file (where repository_name is the name of your repository) in the templates/userdefined/javascript folder of your Xephr install.

If you set this property to true, you should verify that this file exists or your logs will show errors about the missing files.

Use Repository User Styles

Properties for Repository Configuration

Pop-list containing true or false.  When set to true, the Xephr repository will recognize user-defined styles stored in the repository_name.css file (where repository_name is the name of your repository) in the templates/userdefined/styles folder of your Xephr install.

If you set this property to true, you should verify that this file exists or your logs will show errors about the missing files.

Use Secure Connection

Log In

If you wish to connect using a secure connection, set this flag to on.  The connection will be made using an https:// connection.

Use Verbose Errors

Properties for Repository Configuration

Pop-list set to true or false indicates how errors will be displayed during runtime.  When set to true, when errors occur during runtime, they will be displayed in their entirety.  When set to false, a more simplified error message announcing that an error has occurred will be displayed, but the error will not.

Used As

Adding Fields to (block name) under Screen: (entity name)

For Chart Block types, this pop-list determines how the column will be used when generating the chart.  Choices are:  

For Querying: the values in this column will be used queried from the database, but not be used in the generation of the chart values or labels.

Database Value: used with the database label, these are the measured values that determine the height of the bars, the point on the line, the size of the pie slice, etc.  Depending on the chart, you can have between 1 and 5 database values.

Database Label: only one of these is required per chart.  This is the column that is the key to the chart, for which the values are measured.  The values in this column are used to label each bar, each slice, each point on the line, etc.

User

Properties for Datasource

The user id used to log into the database for this datasource.

User ID

Creating New Database Logins
Creating New Users
Properties for Database Logins

The user ID to log into the database associated with this datasource.

Log In

Enter the User ID to connect to the server and log into Xephr.

User Password

Properties for Report

The password necessary for the pdf file to be opened.  If no entry is made, then no password is necessary to view the pdf file.  This property is only available for reports with the Secure Documents property set to Standard Encryption or Strong Encryption.

Users

Properties for Role

List of users that have been assigned this role.  This list cannot be modified.

V-Align

Properties for Style

Pop-list indicating how the text will be laid out vertically.  For styles with parent styles, set this pop-list to (from parent) to have the setting of this property determined by the parent style.  Choices are:

Top-Aligned: Align along the top

Middle-Aligned: Place in the middle of the element

Bottom Aligned: Align along the bottom.

Value

Creating New Global Variables
Creating New Users
Properties for Global Variables

The value that will be set for this global variable when the user logs into Xephr.

Values From

Properties for List of Values

Pop-list indicating from where the values for this list of values are obtained.  Choices are Query and List.

Vertical Padding (in Pixels)

Properties for Block

The number of pixels in between records vertically within a container.

Visible

Properties for Field

Pop-list set to true or false indicates whether this field is visible on the block.  When set to true, the field will be displayed on the block.  When set to false, the field will not be displayed on the block.

Visited Style

Properties for Link Style

Pop-list containing all existing styles.  Select the name of the style to use for the Visited state.  Any link that the user has already visited will be in the Visited state.

W - Z

Web Service

Properties for Published Entity

Pop-list is set to true if the XML document will be published as a standard SOAP web service complete with WSDL that can be used by other applications to generate program stubs and direct interfaces to the entity.

Publishing Entities

Set this checkbox to on if the XML document will be published as a standard SOAP web service complete with WSDL that can be used by other applications to generate program stubs and direct interfaces to the entity.

Welcome Entity

Properties for Repository Configuration

The name of the entity to display when the user is authenticated, no other authentication is required, and no other entity is specified.  In other words, when users log in, this is the screen displayed if there is no Start Page defined for the user, or if the xephr instance does not require users to log in.

Width

Properties for Block
Properties for Field
Properties for Report
Properties for Screen
Properties for Template

Enter the width for the entity, block, or field.  Screens and their objects have the width entered in pixels.  Reports and their objects have the width entered in the unit of measure determined by the Reports Layout Measurements In property.

Properties for File

The width for the image in pixels.  This value cannot be changed.

Properties for List of Values

The width of the list of values screen in pixels.  This value defaults from the Default LOV Width property for the Repository.

Properties for Paper Size

Enter the width for the paper size in the unit of measure defined in the Units of Measure property.

Wrap at Column

Properties for Block

In the Wrap at Column property, enter the number of records to be returned horizontally on the screen before a line break is inserted and the next set is output on the next row.  This property allows you to have multiple database rows returned horizontally on the screen.

For example, to return only one record per row on the block, enter 1 here and the block will look like this:

record 1
record 2
record 3

To return five records per row on the block, enter 5 here, and the block will look like this:

record 1 record 2 record 3 record 4 record 5
record 6 record 7 record 8

X

Properties for Block
Properties for Field

Enter the location in pixels of the top left corner of this block or field on the X-axis (horizontal) of the layout screen.

X Column

Adding Block
Properties for Block

The column from the table or complex query that is used to store the location in pixels of the top left corner of the record on the X axis (horizontal) of the container to which the record has been assigned.

Xephr Interconnect

Publishing Entities

Checkbox set to on indicates that the XML document will be used for Xephr Interconnect once it is published.

Xephr Service

Properties for Datasource - Xephr Service

The Xephr service selected during creation is displayed and cannot be changed.

Y

Properties for Block
Properties for Field

Enter the location in pixels of the top left corner of this block or field on the Y-axis (vertical) of the layout screen.  This value is used in conjunction with the Y Anchor Type setting.

Y Anchor

Properties for Block

When the Y Anchor Type is Relative to Block, this is the block from which the placement of the block will be determined.

Properties for Field

When the Y Anchor Type is Relative to Field, this is the field from which the placement of the field will be determined.

For Report fields, when the Y Anchor Type is Relative to Field or Relative to Output, this is the field from which the placement of this field will be determined.  

Y Anchor Type

Properties for Block

Pop-list containing Fixed or Relative to Block.

When set to Fixed, the upper left corner of this block will be placed a fixed number of pixels in relation to the upper left corner of the block's container.  The number of pixels is defined in the Y field for the block.

When set to Relative to Block, the upper left corner of this block will be placed a fixed number of pixels from the bottom edge of the specified block defined in the Y Anchor property.  Example:  if you want a particular block to appear immediately after another block which happens to be an Expanding block (and therefore you don't know where it will end on the entity).

On Report blocks, select the anchor for the Y-axis for this block.  Choices are Fixed, Relative to Output, or Relative to Field.

When set to Fixed, the upper left corner of this block will be placed a fixed number of measurement units in relation to the upper left corner of the block's container.  The number of measurement units is defined in the Y property for the block.

When set to Relative to Output, the upper left corner of the block will be placed in relation to the output of the blocks that have Z order values that are less than the Z order for this block.

When set to Relative to Block, the upper left corner of this block will be placed a fixed number of measurement units from the bottom edge of the specified block defined in the Y Anchor property.

Properties for Field

Pop-list containing Fixed or Relative to Field.

When set to Fixed, the upper left corner of this block will be placed a fixed number of pixels in relation to the upper left corner of the field's container.  The number of pixels is defined in the Y field for the block.

When set to Relative to Field, the upper left corner of this field will be placed a fixed number of pixels from the bottom edge of the specified field defined in the Y Anchor property.  

On Report fields, select the anchor for the Y-axis for this field.  Choices are Fixed, Relative to Output, or Relative to Field.

When set to Fixed, the upper left corner of this field will be placed a fixed number of measurement units in relation to the upper left corner of the field's container.  The number of measurement units is defined in the Y property for the field.

When set to Relative to Output, the upper left corner of this field will be placed a fixed number of pixels from the bottom edge of the output of the specified field defined in the Y Anchor property.  This option should be selected if the field in the Y Anchor property is an expandable field and you do not know where the bottom of the field will be when the report is generated.

When set to Relative to Field, the upper left corner of this field will be placed a fixed number of pixels from the bottom edge of the specified field defined in the Y Anchor property.

Y Column

Adding Block
Properties for Block

The column from the table or complex query that is used to store the location in pixels of the top left corner of the record on the Y axis (vertical) of the container to which the record has been assigned.

Z Order

Properties for Block

Determines the order in which the block will be generated on the entity.  The higher the number, the later the block will be generated.

It is very important that for reports this number is set up properly for each block.  The Z order is specific to the indention level in the entity tree, and is affected by the Y Anchor and Anchor Type properties.  For example:

Report entity  

Header block (Z order 1, displayed first on the report)

Standard block (Z order 2, displayed second on the report, beneath the header block.)

standard block header (z order 1, displayed first within the standard block)

standard block database (z order 2, displayed second within the standard block, beneath the header block)

Parameter Form block (z order 1.  Does not affect report generation)

For blocks with Tab Blocks as the parent block, this number determines in which order the tabs will be displayed within the tab block.  

Properties for Field

Determines the order in which the field will be displayed in comparison with the other fields on this block.  

Z order affects fields when they overlap one another.  For example, if you had 2 fields of the same size in the same location on the block, one with a Z order of 10, and the other with a Z order of 20, the one with the Z order of 20 will be displayed because it was generated last.

Z order also affects the order in which the fields are selected when tabbing through fields.  Generally, tabbing through the fields is ordered according to the order in which the fields were output for standard fields such as checkboxes, text fields, links, and might include images and labels depending on the browser .  A Z order of 1 indicates that the cursor should be placed in that field when the page is loaded.  Tabbing from that field will take the cursor to the next highest Z order.  If two fields are assigned the same Z order, their output order in relationship to each other is in effect random.  

Different browsers may use a different tab order.  Depending on the browser, some field types may or may not be able to be accessed by tabbing, including links, images, and labels.

Properties for Menu
Properties for Menu Link

A numeric value that determines the order in which the menu or menu link will appear on the parent menu.  This value is user-defined.

Xephr is a registered trademark of NDS Systems, LC.

Microsoft is a registered trademark of Microsoft Corporation.

Copyright © 2007 NDS Systems LC.