Modifying Chart Blocks on Screens

This section includes:

Not from Query Chart Blocks

Xephr Service Chart Blocks

Simple Query Chart Blocks

Complex Query Chart Blocks

Xephr Interconnect Chart Blocks

Not From Query Chart Blocks

In the Explorer Tree, locate the object for which you wish to modify a block.

Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.

Expand the screen and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creation is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent pop-list, if the parent of this block is another block, the parent block is displayed, grayed out. Otherwise, this pop-list is set to (entity root).
In the Type pop-list, the original setting from the block creation will be displayed, and can be changed, if desired. The type can be Standard Block, Tab Block, Chart Block, Bread Crumb, or iFrame. It should be set to Chart Block.
In the Chart Type pop-list, select the type of chart to be displayed on this block. See the Chart Types section for more information.

Area Chart: Needs one or more datapoint values and one datapoint label.
Area Chart 3D: Needs one or more datapoint values and one datapoint label.
Bar Chart: Needs one or more datapoint values and one datapoint label.
Bar Chart 3D: Needs one or more datapoint values and one datapoint label.
Bubble Chart: Needs one or more datapoint values and one datapoint label.
Column Chart: Needs one or more datapoint values and one datapoint label.
Column Chart 3D: Needs one or more datapoint values and one datapoint label.
Heat Map: Needs one or more datapoint values and one datapoint label.
Heat Map 3D: Needs one or more datapoint values and one datapoint label.
Line Chart: Needs one or more datapoint values and one datapoint label.
Line Chart 3D: Needs one or more datapoint values and one datapoint label.
Pie Chart: Needs one datapoint value and one datapoint label.
Pie Chart 3D: Needs one datapoint value and one datapoint label.
Scatter Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart 3D: Needs one or more datapoint value and one datapoint label.
Stacked Column Chart: Needs one or more datapoint values and one datapoint label.
Stacked Column Chart 3D: Needs one or more datapoint values and one datapoint label.

In the Top Title property, enter the title to be displayed at the top of the chart.
In the Bottom Title property, enter the title to be displayed at the bottom of the chart.
In the Left Title property, enter the title to be displayed at the left of the chart.
In the Legend pop-list, 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.
In the Mutability pop-list, select whether this block can be modified on screens that are created from this template. This option is ONLY available for template screens.

When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.

In the Query Type property, 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.

Not from Query indicates that the block is not created from a database table/view. Header blocks that contain only labels should have this pop-list set to Not from Query.
Set the On QBE pop-list to true, if this block should be included in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included in New mode for this screen.
Set the On List pop-list to true, if this block should be included in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included in Edit mode for this screen.
Set the Body Style pop-list to the style to be applied to the body for this block. If set to (from parent), the style used will be the Body Style from the screen properties.
Set the Editable Field Style pop-list to the style to be applied by default to the editable fields for this block. If set to (from parent), the style used will be the Editable Field Style from the screen properties.
Set the Non- Editable Field Style pop-list to the style to be applied by default to the display only and label fields for this block. If set to (from parent), the style used will be the Non- Editable Field Style from the screen properties.
Set the Link Style pop-list to the style to be applied to hyperlinks for this block. If set to (from parent), the style used will be the Link Style from the screen properties.
In the X property, the location in pixels is displayed for the top left corner of this block or field on the X-axis (horizontal) of the layout screen. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y property, the location in pixels is displayed for 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. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y Anchor Type pop-list, select the anchor type for this block. Choices are Fixed and 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 parent. 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 field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).

In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.

When set to Expandable, the block 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 will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block 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.
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.

In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$, 'NDS')
Hide the block only if the customer number starts with NDS.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
Expressions are entered in this field using formulas and are evaluated on the server side.
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 hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$) = 0
Displays the block if the value of the total field on the order block is zero.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show if Empty pop-list, determine whether the block will be displayed when it is empty. When set to true, the block will be displayed on the screen even when it contains no data. When set to false, the block will be hidden when it contains no data.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. 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 blocks with a Tab Block as the parent block, this number determines in which order the tabs will be displayed within the tab block.
Set the Swap Rows/Columns property to the desired setting. 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.
Set the Form is for QBE/NEW property to the desired setting. 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 this to happen.

If this block will be displayed on the screen in QBE or New mode, this property should be set to true.

If the 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.
The Created on property displays the date and time on which this block was created and cannot be changed.
The Modified on property displays the date and time on which this block was last changed and cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.

Xephr Service Chart Blocks

In the Explorer Tree, locate the object for which you wish to modify a block.

Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.

Expand the screen and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creating is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent pop-list, if the parent of this block is another block, the parent block is displayed, grayed out. Otherwise, this pop-list is set to (entity root).
In the Type pop-list, the original setting from the block creation will be displayed, and can be changed, if desired. The type can be Standard Block, Tab Block, Chart Block, Bread Crumb, or iFrame. It should be set to Chart Block.
In the Chart Type pop-list, select the type of chart to be displayed on this block. See the Chart Types section for more information.

Area Chart: Needs one or more datapoint values and one datapoint label.
Area Chart 3D: Needs one or more datapoint values and one datapoint label.
Bar Chart: Needs one or more datapoint values and one datapoint label.
Bar Chart 3D: Needs one or more datapoint values and one datapoint label.
Bubble Chart: Needs one or more datapoint values and one datapoint label.
Column Chart: Needs one or more datapoint values and one datapoint label.
Column Chart 3D: Needs one or more datapoint values and one datapoint label.
Heat Map: Needs one or more datapoint values and one datapoint label.
Heat Map 3D: Needs one or more datapoint values and one datapoint label.
Line Chart: Needs one or more datapoint values and one datapoint label.
Line Chart 3D: Needs one or more datapoint values and one datapoint label.
Pie Chart: Needs one datapoint value and one datapoint label.
Pie Chart 3D: Needs one datapoint value and one datapoint label.
Scatter Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart 3D: Needs one or more datapoint value and one datapoint label.
Stacked Column Chart: Needs one or more datapoint values and one datapoint label.
Stacked Column Chart 3D: Needs one or more datapoint values and one datapoint label.

In the Top Title property, enter the title to be displayed at the top of the chart.
In the Bottom Title property, enter the title to be displayed at the bottom of the chart.
In the Left Title property, enter the title to be displayed at the left of the chart.
In the Legend pop-list, 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.
In the Mutability pop-list, select whether this block can be modified on screens that are created from this template. This option is ONLY available for template screens.

When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.

In the Query Type property, 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.

Xephr Service indicates that the query for this block will be from a xephr service. When Xephr Service is selected, the Datasource and Table properties are displayed. These properties are used to construct the information returned by the Xephr service.
In the Datasource pop-list, the original value from block creation is displayed, but can be changed, if desired.

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
In the Table property, the original value from block creation is displayed, but can be changed if desired. Select the Xephr service method from which the data will be displayed on this block. Choices are determined by the datasource selected.
Depending on the Table selected, one or more parameter (PARAM) properties will be displayed. Enter the appropriate values for the parameters. The parameters assigned to each service type are used to restrict the values returned from the Xephr service.
In the Max Number of Rows property, enter 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.

A block is considered a list if the max number of rows is not set to 1.

Blocks are considered forms when the max number of rows is 1.
Set the On QBE pop-list to true, if this block should be included in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included in New mode for this screen.
Set the On List pop-list to true, if this block should be included in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included in Edit mode for this screen.
Set the Body Style pop-list to the style to be applied to the body for this block. If set to (from parent), the style used will be the Body Style from the screen properties.
Set the Editable Field Style pop-list to the style to be applied by default to the editable fields for this block. If set to (from parent), the style used will be the Editable Field Style from the screen properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the display only and label fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the screen properties.
Set the Link Style pop-list to the style to be applied to hyperlinks for this block. If set to (from parent), the style used will be the Link Style from the screen properties.
In the X property, the location in pixels is displayed for the top left corner of this block or field on the X-axis (horizontal) of the layout screen. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y property, the location in pixels is displayed for 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. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y Anchor Type pop-list, select the anchor type for this block. Choices are Fixed and 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 parent. 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 field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).

In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.

When set to Expandable, the block 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 will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block 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.
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.

In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$, 'NDS')
Hide the block only if the customer number starts with NDS.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$) = 0
Displays the block if the value of the total field on the order block is zero.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show if Empty pop-list, determine whether the block will be displayed when it is empty. When set to true, the block will be displayed on the screen even when it contains no data. When set to false, the block will be hidden when it contains no data.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. 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 blocks with a Tab Block as the parent block, this number determines in which order the tabs will be displayed within the tab block.
Set the Swap Rows/Columns property to the desired setting. 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.
The Created on property displays the date and time on which this block was created and cannot be changed.
The Modified on property displays the date and time on which this block was last changed and cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.

Simple Query Chart Blocks

In the Explorer Tree, locate the object for which you wish to modify a block.

Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.

Expand the screen and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creating is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent pop-list, if the parent of this block is another block, the parent block is displayed, grayed out. Otherwise, this pop-list is set to (entity root).
In the Type pop-list, the original setting from the block creation will be displayed, and can be changed, if desired. The type can be Standard Block, Tab Block, Chart Block, Bread Crumb, or iFrame. It should be set to Chart Block.
In the Chart Type pop-list, select the type of chart to be displayed on this block. See the Chart Types section for more information.

Area Chart: Needs one or more datapoint values and one datapoint label.
Area Chart 3D: Needs one or more datapoint values and one datapoint label.
Bar Chart: Needs one or more datapoint values and one datapoint label.
Bar Chart 3D: Needs one or more datapoint values and one datapoint label.
Bubble Chart: Needs one or more datapoint values and one datapoint label.
Column Chart: Needs one or more datapoint values and one datapoint label.
Column Chart 3D: Needs one or more datapoint values and one datapoint label.
Heat Map: Needs one or more datapoint values and one datapoint label.
Heat Map 3D: Needs one or more datapoint values and one datapoint label.
Line Chart: Needs one or more datapoint values and one datapoint label.
Line Chart 3D: Needs one or more datapoint values and one datapoint label.
Pie Chart: Needs one datapoint value and one datapoint label.
Pie Chart 3D: Needs one datapoint value and one datapoint label.
Scatter Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart 3D: Needs one or more datapoint value and one datapoint label.
Stacked Column Chart: Needs one or more datapoint values and one datapoint label.
Stacked Column Chart 3D: Needs one or more datapoint values and one datapoint label.

In the Top Title property, enter the title to be displayed at the top of the chart.
In the Bottom Title property, enter the title to be displayed at the bottom of the chart.
In the Left Title property, enter the title to be displayed at the left of the chart.
In the Legend pop-list, 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.
In the Mutability pop-list, select whether this block can be modified on screens that are created from this template. This option is ONLY available for template screens.

When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.

In the Query Type property, 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.

Simple Query indicates that the block is taken from a simple query to a database table/view. The Simple Query option will be chosen most often for database blocks. The database query will be constructed from the entries in the additional properties.
In the Datasource pop-list, the original value from block creation is displayed, but can be changed, if desired. Selecting (use default) will allow the screen or template to be used with any datasource, and data brought in will be determined by the screen's or template's datasource.
In the Table property, the original value from block creation is displayed, but can be changed if desired. Select the desired table/view from which the data will be displayed on this block.
In the Select Statement property, 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. Simple Query blocks will have the data in this property generated automatically.

All columns selected from the database need to be explicitly named.

Format: SELECT column, column, column, column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM item_master_uvw
In the Filters property, enter 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.

Format: WHERE column (comparison) value AND column (comparison) value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')

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

In the Ordering and Grouping property, 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
Set the Deletable property to 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.
In the Max Number of Rows property, enter 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.

A block is considered a list if the max number of rows is not set to 1.

Blocks are considered forms when the max number of rows is 1.
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.

In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block. 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.

Set the On QBE pop-list to true, if this block should be included in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included in New mode for this screen.
Set the On List pop-list to true, if this block should be included in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included in Edit mode for this screen.
Set the Body Style pop-list to the style to be applied to the body for this block. If set to (from parent), the style used will be the Body Style from the screen properties.
Set the Editable Field Style pop-list to the style to be applied by default to the editable fields for this block. If set to (from parent), the style used will be the Editable Field Style from the screen properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the display only and label fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the screen properties.
Set the Link Style pop-list to the style to be applied to hyperlinks for this block. If set to (from parent), the style used will be the Link Style from the screen properties.
In the X property, the location in pixels is displayed for the top left corner of this block or field on the X-axis (horizontal) of the layout screen. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y property, the location in pixels is displayed for 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. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y Anchor Type pop-list, select the anchor type for this block. Choices are Fixed and 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 parent. 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 field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).

In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.

When set to Expandable, the block 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 will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block 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.
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.

In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$, 'NDS')
Hide the block only if the customer number starts with NDS.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$) = 0
Displays the block if the value of the total field on the order block is zero.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show if Empty pop-list, determine whether the block will be displayed when it is empty. When set to true, the block will be displayed on the screen even when it contains no data. When set to false, the block will be hidden when it contains no data.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. 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 blocks with a Tab Block as the parent block, this number determines in which order the tabs will be displayed within the tab block.
Set the Swap Rows/Columns property to the desired setting. 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.
Set the Form is for QBE/NEW property to the desired setting. 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 this to happen.

If this block will be displayed on the screen in QBE or New mode, this property should be set to true.

If the 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.
The Created on property displays the date and time on which this block was created and cannot be changed.
The Modified on property displays the date and time on which this block was last changed and cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.

Complex Query Chart Blocks

In the Explorer Tree, locate the object for which you wish to modify a block.

Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.

Expand the screen and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creating is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent pop-list, if the parent of this block is another block, the parent block is displayed, grayed out. Otherwise, this pop-list is set to (entity root).
In the Type pop-list, the original setting from the block creation will be displayed, and can be changed, if desired. The type can be Standard Block, Tab Block, Chart Block, Bread Crumb, or iFrame. It should be set to Chart Block.
In the Chart Type pop-list, select the type of chart to be displayed on this block. See the Chart Types section for more information.

Area Chart: Needs one or more datapoint values and one datapoint label.
Area Chart 3D: Needs one or more datapoint values and one datapoint label.
Bar Chart: Needs one or more datapoint values and one datapoint label.
Bar Chart 3D: Needs one or more datapoint values and one datapoint label.
Bubble Chart: Needs one or more datapoint values and one datapoint label.
Column Chart: Needs one or more datapoint values and one datapoint label.
Column Chart 3D: Needs one or more datapoint values and one datapoint label.
Heat Map: Needs one or more datapoint values and one datapoint label.
Heat Map 3D: Needs one or more datapoint values and one datapoint label.
Line Chart: Needs one or more datapoint values and one datapoint label.
Line Chart 3D: Needs one or more datapoint values and one datapoint label.
Pie Chart: Needs one datapoint value and one datapoint label.
Pie Chart 3D: Needs one datapoint value and one datapoint label.
Scatter Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart 3D: Needs one or more datapoint value and one datapoint label.
Stacked Column Chart: Needs one or more datapoint values and one datapoint label.
Stacked Column Chart 3D: Needs one or more datapoint values and one datapoint label.

In the Top Title property, enter the title to be displayed at the top of the chart.
In the Bottom Title property, enter the title to be displayed at the bottom of the chart.
In the Left Title property, enter the title to be displayed at the left of the chart.
In the Legend pop-list, 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.
In the Mutability pop-list, select whether this block can be modified on screens that are created from this template. This option is ONLY available for template screens.

When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.

In the Query Type property, 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.

Complex Query indicates that the database query will be constructed in its entirety by the user, such as when multiple tables must be referenced for the data. The user will construct the database query using these properties. Data on Complex Query blocks cannot be updated to the database from the entity on Xephr Runtime unless the complex query only references one table or view.
In the Datasource pop-list, the original value from block creation is displayed, but can be changed, if desired. Selecting (use default) will allow the screen or template to be used with any datasource, and data brought in will be determined by the screen's or template's datasource.
In the Select Statement property, 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. Complex Query blocks require that the user enter the select statement.

All columns selected from the database need to be explicitly named.

Format: SELECT column, column, column, column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM item_master_uvw
In the Filters property, enter 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.

Format: WHERE column (comparison) value AND column (comparison) value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')

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

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

In the Ordering and Grouping property, enter any code to be executed after the filters, such as the order by or group by.

Format: ORDER BY column, column, column
Format: GROUP BY column, column, column
For example: ORDER BY description, stock_um, qty_on_hand desc
Set the Deletable property to 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.
In the Max Number of Rows property, enter 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.

A block is considered a list if the max number of rows is not set to 1.

Blocks are considered forms when the max number of rows is 1.
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.

In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block. 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.

Set the On QBE pop-list to true, if this block should be included in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included in New mode for this screen.
Set the On List pop-list to true, if this block should be included in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included in Edit mode for this screen.
Set the Body Style pop-list to the style to be applied to the body for this block. If set to (from parent), the style used will be the Body Style from the screen properties.

Set the Editable Field Style pop-list to the style to be applied by default to the editable fields for this block. If set to (from parent), the style used will be the Editable Field Style from the screen properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the label and display only fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the screen properties.
Set the Link Style pop-list to the style to be applied to links for this block. If set to (from parent), the style used will be the Link Style from the screen properties.
In the X property, the location in pixels is displayed for the top left corner of this block or field on the X-axis (horizontal) of the layout screen. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y property, the location in pixels is displayed for 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. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y Anchor Type pop-list, select the anchor type for this block. Choices are Fixed and 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 parent. 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 field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).

In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.

When set to Expandable, the block 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 will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block 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.
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.

In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$, 'NDS')
Hide the block only if the customer number starts with NDS.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$) = 0
Displays the block if the value of the total field on the order block is zero.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show if Empty pop-list, determine whether the block will be displayed when it is empty. When set to true, the block will be displayed on the screen even when it contains no data. When set to false, the block will be hidden when it contains no data.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. 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 blocks with a Tab Block as the parent block, this number determines in which order the tabs will be displayed within the tab block.
Set the Swap Rows/Columns property to the desired setting. 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.
Set the Form is for QBE/NEW property to the desired setting. 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 this to happen.

If this block will be displayed on the screen in QBE or New mode, this property should be set to true.

If the 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.
The Created on property displays the date and time on which this block was created and cannot be changed.
The Modified on property displays the date and time on which this block was last changed and cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.

Xephr Interconnect Chart Blocks

In the Explorer Tree, locate the object for which you wish to modify a block.

Expand the Template Information object and select the template screen for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the screen for which you wish to modify a block.

Expand the screen and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creating is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent pop-list, if the parent of this block is another block, the parent block is displayed, grayed out. Otherwise, this pop-list is set to (entity root).
In the Type pop-list, the original setting from the block creation will be displayed, and can be changed, if desired. The type can be Standard Block, Tab Block, Chart Block, Bread Crumb, or iFrame. It should be set to Chart Block.
In the Chart Type pop-list, select the type of chart to be displayed on this block. See the Chart Types section for more information.

Area Chart: Needs one or more datapoint values and one datapoint label.
Area Chart 3D: Needs one or more datapoint values and one datapoint label.
Bar Chart: Needs one or more datapoint values and one datapoint label.
Bar Chart 3D: Needs one or more datapoint values and one datapoint label.
Bubble Chart: Needs one or more datapoint values and one datapoint label.
Column Chart: Needs one or more datapoint values and one datapoint label.
Column Chart 3D: Needs one or more datapoint values and one datapoint label.
Heat Map: Needs one or more datapoint values and one datapoint label.
Heat Map 3D: Needs one or more datapoint values and one datapoint label.
Line Chart: Needs one or more datapoint values and one datapoint label.
Line Chart 3D: Needs one or more datapoint values and one datapoint label.
Pie Chart: Needs one datapoint value and one datapoint label.
Pie Chart 3D: Needs one datapoint value and one datapoint label.
Scatter Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart 3D: Needs one or more datapoint value and one datapoint label.
Stacked Column Chart: Needs one or more datapoint values and one datapoint label.
Stacked Column Chart 3D: Needs one or more datapoint values and one datapoint label.

In the Top Title property, enter the title to be displayed at the top of the chart.
In the Bottom Title property, enter the title to be displayed at the bottom of the chart.
In the Left Title property, enter the title to be displayed at the left of the chart.
In the Legend pop-list, 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.
In the Mutability pop-list, select whether this block can be modified on screens that are created from this template. This option is ONLY available for template screens.

When set to Fully Mutable, the block is placed on all screens that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all screens that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all screens that inherit from this template and cannot be modified in anyway.

In the Query Type property, 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

Xephr Interconnect indicates that the query for this block will be from a published entity on a Xephr host. This option is only available if a Xephr Interconnect datasource exists.
In the Target Login property, the user ID that will be used to access the published entity is displayed and can be changed.
In the Target Password property, e password that will be used to access the published entity is displayed and can be changed.
In the Datasource pop-list, the original value from block creation is displayed, but can be changed, if desired.

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.
In the Interconnect Entity property, the original value from block creation is displayed, but can be changed if desired. Select the published entity from which the data will be displayed on this block. Choices are determined by the datasource selected.
Depending on the Interconnect Entity selected, one or more parameter (PARAM) properties will be displayed. Enter the appropriate values for the parameters. The parameters are used to restrict the values returned from the published entity.
Set the Deletable property to 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.
In the Max Number of Rows property, enter 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.

A block is considered a list if the max number of rows is not set to 1.

Blocks are considered forms when the max number of rows is 1.
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.

In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block. 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.

Set the On QBE pop-list to true, if this block should be included in QBE mode for this screen.
Set the On New pop-list to true, if this block should be included in New mode for this screen.
Set the On List pop-list to true, if this block should be included in List mode for this screen.
Set the On Edit pop-list to true, if this block should be included in Edit mode for this screen.
Set the Body Style pop-list to the style to be applied to the body for this block. If set to (from parent), the style used will be the Body Style from the screen properties.
Set the Editable Field Style pop-list to the style to be applied by default to the editable fields for this block. If set to (from parent), the style used will be the Editable Field Style from the screen properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the display only and label fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the screen properties.
Set the Link Style pop-list to the style to be applied to hyperlinks for this block. If set to (from parent), the style used will be the Link Style from the screen properties.
In the X property, the location in pixels is displayed for the top left corner of this block or field on the X-axis (horizontal) of the layout screen. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y property, the location in pixels is displayed for 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. You can change this number manually, or it will be changed when you are altering the layout with the Designer Tool.
In the Y Anchor Type pop-list, select the anchor type for this block. Choices are Fixed and 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 parent. 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 field. Example: if you want a particular block to appear immediately after another block which happens to be an Expandable block (and therefore you don't know where it will end on the entity).

In the Y Anchor property, select the block or field that will be used to determine the location of the block on the Y-axis. The property is only displayed when the Y Anchor Type pop-list is set to Block or Field.
In the Width property, enter the width for the block in pixels.
In the Height property, enter the height for the block in pixels.
In the Expand Type pop-list, define the size of the block. Choices are Expandable, Fixed No Scroll Bars, and Fixed with Scroll Bars.

When set to Expandable, the block 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 will be the exact size defined using the Width and Height values.
When set to Fixed with Scroll Bars, the block 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.
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.

In the Hide If property, enter the conditions under which this block will be hidden. The field will be visible on the block when the conditions are met. When an entry is made in this property, the Show If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 show a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'Y'
Hide the block if the value of the active field on the vendor block is set to Y when the block is generated.
Example: starts-with( $$CUST_NO$$, 'NDS')
Hide the block only if the customer number starts with NDS.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Hide this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Hide this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show If property, enter the conditions under which this block will be displayed. The block will be hidden when the conditions are met. When an entry is made in this property, the Hide If property will be hidden.

Expressions are entered in this field using formulas and are evaluated on the server side.
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 hide a block; everything is locked in when the block is first output).
Example: $$VENDOR.ACTIVE$$ = 'N'
The block will be displayed when the value of the active field on the vendor block is N when the entity is generated.
Example: number( $$ORDER.TOTAL$$) = 0
Displays the block if the value of the total field on the order block is zero.
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 ||

Example: ($$XEPHR_ENTITY_NAME$$='MENU')&&($$NEXTMENU$$='MM')
Show this block if the current entity is the MENU entity and the NEXTMENU global value is set to MM.

Example: ($$CUST_NO$$='NDS')||($$CUST_NO$$='')
Show this block if the customer number global is set to NDS, or the customer number global is null or doesn't exist.

In the Show if Empty pop-list, determine whether the block will be displayed when it is empty. When set to true, the block will be displayed on the screen even when it contains no data. When set to false, the block will be hidden when it contains no data.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. 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 blocks with a Tab Block as the parent block, this number determines in which order the tabs will be displayed within the tab block.
Set the Swap Rows/Columns property to the desired setting. 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.
Set the Form is for QBE/NEW property to the desired setting. 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 this to happen.

If this block will be displayed on the screen in QBE or New mode, this property should be set to true.

If the 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.
The Created on property displays the date and time on which this block was created and cannot be changed.
The Modified on property displays the date and time on which this block was last changed and cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.

Xephr is a registered trademark of NDS Systems, LC.