Modifying Blocks on Reports

This section includes:

Not from Query Blocks

Xephr Service Blocks

Simple Query Blocks

Complex Query Blocks

Xephr Interconnect Blocks

Not from Query 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 report for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the report for which you wish to modify a block.

Expand the report 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, or Chart Block.
If the block is a 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.

If the block is a Chart Block, in the Top Title property, enter the title to be displayed at the top of the chart.
If the block is a Chart Block, in the Bottom Title property, enter the title to be displayed at the bottom of the chart.
If the block is a Chart Block, in the Left Title property, enter the title to be displayed at the left of the chart.
If the block is a Chart Block, 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 reports that are created from this template. This option is ONLY available for template reports.

When set to Fully Mutable, the block is placed on all reports that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all reports that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all reports 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 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 report 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 report properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the labels and display only fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the report 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 report properties.
In the X property, the location in the report's defined measurement units 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 the report's defined measurement units 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 for this block. Choices are Fixed, Relative to Output, and Relative to Block.

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.

In the Y Anchor property, select the block 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 Relative to Block.
In the Width property, enter the width for the block in the report's defined measurement units.
In the Height property, enter the height for the block in the report's defined measurement units.
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 Variable, 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.
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 entity 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 entity 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 report 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 the number that indicates the order in which this block will be displayed on the report. 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 report entity tree. 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)

In the Show On property, select on which pages of the report the block will be generated. Choices are All Pages, First Page Only, and All But First.
Set the Page Break Before property to the desired setting. When set to true, a page break will be inserted before this block is generated on this report. When set to false, no page break will be inserted before this block is generated.
For Chart Blocks, 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.

Xephr Service 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 report for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the report for which you wish to modify a block.

Expand the report 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, or Chart Block.
If the block is a 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.

If the block is a Chart Block, in the Top Title property, enter the title to be displayed at the top of the chart.
If the block is a Chart Block, in the Bottom Title property, enter the title to be displayed at the bottom of the chart.
If the block is a Chart Block, in the Left Title property, enter the title to be displayed at the left of the chart.
If the block is a Chart Block, 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 reports that are created from this template. This option is ONLY available for template reports.

When set to Fully Mutable, the block is placed on all reports that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all reports that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all reports 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.
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 report 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 report properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the labels and display only fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the report 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 report properties.
In the X property, the location in the report's defined measurement units 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 the report's defined measurement units 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 for this block. Choices are Fixed, Relative to Output, and Relative to Block.

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. This option should be selected if the blocks with lower Z orders are expandable and you do not know where the bottom of the blocks will be when the report is generated.
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.

In the Y Anchor property, select the block 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 Relative to Block.
In the Width property, enter the width for the block in the report's defined measurement units.
In the Height property, enter the height for the block in the report's defined measurement units.
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 Variable, 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.
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 entity 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 entity 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 report 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 the number that indicates the order in which this block will be displayed on the report. 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 report entity tree. 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)

In the Show On property, select on which pages of the report the block will be generated. Choices are All Pages, First Page Only, and All But First.
Set the Page Break Before property to the desired setting. When set to true, a page break will be inserted before this block is generated on this report. When set to false, no page break will be inserted before this block is generated.
For Chart Blocks, 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 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 report for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the report for which you wish to modify a block.

Expand the report 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, or Chart Block.
If the block is a 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.

If the block is a Chart Block, in the Top Title property, enter the title to be displayed at the top of the chart.
If the block is a Chart Block, in the Bottom Title property, enter the title to be displayed at the bottom of the chart.
If the block is a Chart Block, in the Left Title property, enter the title to be displayed at the left of the chart.
If the block is a Chart Block, 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 reports that are created from this template. This option is ONLY available for template reports.

When set to Fully Mutable, the block is placed on all reports that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all reports that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all reports 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 report or template to be used with any datasource, and data brought in will be determined by the report'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.

If you have column breaks in your report block or if you are using automatic total blocks, this property will not be available because the ordering and grouping is determined internally by the report generator. The Z order for the totaling columns determines the ordering and grouping for the report.

Format: ORDER BY column, column, column
Format: GROUP BY column, column, column
For example: ORDER BY description, stock_um, qty_on_hand desc
In the Wrap at Column property, enter the number of records to be returned horizontally on the report 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 report.

For example, to return only one record per row on the block, enter 1 here and the report 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 report block will look like this:
record 1 record 2 record 3 record 4 record 5
record 6 record 7 record 8
In the Execute Before property, enter any SQL statements that should be executed before the query for this block is executed.

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 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 report 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 report properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the labels and display only fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the report 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 report properties.
In the X property, the location in the report's defined measurement units 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 the report's defined measurement units 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 for this block. Choices are Fixed, Relative to Output, and Relative to Block.

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.

In the Y Anchor property, select the block 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 Relative to Block.
In the Width property, enter the width for the block in the report's defined measurement units.
In the Height property, enter the height for the block in the report's defined measurement units.
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 Variable, 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.
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 entity 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 entity 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 report 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 the number that indicates the order in which this block will be displayed on the report. 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 report entity tree. 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)

In the Show On property, select on which pages of the report the block will be generated. Choices are All Pages, First Page Only, and All But First.
Set the Page Break Before property to the desired setting. When set to true, a page break will be inserted before this block is generated on this report. When set to false, no page break will be inserted before this block is generated.
For Chart Blocks, 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.

Complex Query 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 report for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the report for which you wish to modify a block.

Expand the report 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, or Chart Block.
If the block is a 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.

If the block is a Chart Block, in the Top Title property, enter the title to be displayed at the top of the chart.
If the block is a Chart Block, in the Bottom Title property, enter the title to be displayed at the bottom of the chart.
If the block is a Chart Block, in the Left Title property, enter the title to be displayed at the left of the chart.
If the block is a Chart Block, 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 reports that are created from this template. This option is ONLY available for template reports.

When set to Fully Mutable, the block is placed on all reports that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all reports that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all reports 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 report or template to be used with any datasource, and data brought in will be determined by the report'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, this is where the filters for your complex query are entered

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.

If you have column breaks in your report block or if you are using automatic total blocks, this property will not be available because the ordering and grouping is determined internally by the report generator. The Z order for the totaling columns determines the ordering and grouping for the report.

Format: ORDER BY column, column, column
Format: GROUP BY column, column, column
For example: ORDER BY description, stock_um, qty_on_hand desc
In the Wrap at Column property, enter the number of records to be returned horizontally on the report 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 report.

For example, to return only one record per row on the block, enter 1 here and the report 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 report block will look like this:
record 1 record 2 record 3 record 4 record 5
record 6 record 7 record 8
In the Execute Before property, enter any SQL statements that should be executed before the query for this block is executed.

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.

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 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 report 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 report properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the labels and display only fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the report 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 report properties.
In the X property, the location in the report's defined measurement units 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 the report's defined measurement units 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 for this block. Choices are Fixed, Relative to Output, and Relative to Block.

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, including non-mutable blocks on the report's template.
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.

In the Y Anchor property, select the block 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 Relative to Block.
In the Width property, enter the width for the block in the report's defined measurement units.
In the Height property, enter the height for the block in the report's defined measurement units.
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 Variable, 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.
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 entity 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 entity 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 report 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 the number that indicates the order in which this block will be displayed on the report. 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 report entity tree. 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)

In the Show On property, select on which pages of the report the block will be generated. Choices are All Pages, First Page Only, and All But First.
Set the Page Break Before property to the desired setting. When set to true, a page break will be inserted before this block is generated on this report. When set to false, no page break will be inserted before this block is generated.
For Chart Blocks, 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.

Xephr Interconnect 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 report for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the report for which you wish to modify a block.

Expand the report 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, or Chart Block.
If the block is a 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.

If the block is a Chart Block, in the Top Title property, enter the title to be displayed at the top of the chart.
If the block is a Chart Block, in the Bottom Title property, enter the title to be displayed at the bottom of the chart.
If the block is a Chart Block, in the Left Title property, enter the title to be displayed at the left of the chart.
If the block is a Chart Block, 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 reports that are created from this template. This option is ONLY available for template reports.

When set to Fully Mutable, the block is placed on all reports that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all reports that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all reports 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.
In the Wrap at Column property, enter the number of records to be returned horizontally on the report 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 report.

For example, to return only one record per row on the block, enter 1 here and the report 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 report block will look like this:
record 1 record 2 record 3 record 4 record 5
record 6 record 7 record 8
In the Execute Before property, enter any SQL statements that should be executed before the query for this block is executed.

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 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 report 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 report properties.
Set the Non-Editable Field Style pop-list to the style to be applied by default to the labels and display only fields for this block. If set to (from parent), the style used will be the Non-Editable Field Style from the report 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 report properties.
In the X property, the location in the report's defined measurement units 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 the report's defined measurement units 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 for this block. Choices are Fixed, Relative to Output, and Relative to Block.

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.

In the Y Anchor property, select the block 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 Relative to Block.
In the Width property, enter the width for the block in the report's defined measurement units.
In the Height property, enter the height for the block in the report's defined measurement units.
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 Variable, 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.
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 entity 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 entity 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 report 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 the number that indicates the order in which this block will be displayed on the report. 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 report entity tree. 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)

In the Show On property, select on which pages of the report the block will be generated. Choices are All Pages, First Page Only, and All But First.
Set the Page Break Before property to the desired setting. When set to true, a page break will be inserted before this block is generated on this report. When set to false, no page break will be inserted before this block is generated.
For Chart Blocks, 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.

Xephr is a registered trademark of NDS Systems, LC.