RowExpand and EndRowExpand Tag Reference
The RowExpand and EndRowExpand tags are extensions of the ForEach/End-Foreach tags that are more use-case specific. The RowExpand tag is equivalent to the ForEach tag with the order property set to row.
RowExpand/EndRowExpand Tag Functionality
The RowExpand Tag tells the template to go find all the rows or nodes in a set from your data source and loop over each item. For each iteration of the RowExpand tag, it will repeat all content that is between the RowExpand tag and the EndRowExpand tag. Each iteration of the loop will use the data for that specific iteration and will stop repeating the data once all rows or nodes in your data set have been iterated through.
The RowExpand and EndRowExpand tags can only be used inside of tables.
Here is a sample template that demonstrates the RowExpand and EndRowExpand tags: RowExpand Sample Template Download
RowExpand Properties
Tag Properties
block (default: false)
If set to 'true', expands the rows in a data set returned by the RowExpand Tag in a contiguous block of cells, while preserving as much as possible the cells around the block. This property also allows you to expand RowExpand Tags side by side in the same table.
nickname (optional)
The nickname will appear in the template rather than the generic "rowExpand:" label. Descriptive nicknames can be very important in designing complex templates.
var (optional; default: varName1)
The name used to access the current node or row in the loop. It can be referenced by other Tags within the loop using the Fluent variable name format "${varName1}". Tags within the loop can also reference an item within the current node or row using the format "${varName1.item}".
varStatus (optional)
The name is used to access the RowExpand Tag status variables. The status variables can be used within the loop to obtain information about the loop such as the index of the current data element (row or node); the number of data elements returned so far; and a condition indicating whether the current data element is the first or last data element in the loop.
- ${name.index} - the zero-based index of the current data element in the data set returned by the RowExpand Tag. This index is relative to the entire data set; it is independent of the 'begin' or 'step' property settings.
- ${name.count} - the number of data elements returned so far. The count begins at one and reflects the data elements actually returned, unlike ${name.index}, which includes the entire data set regardless of which data elements are returned.
- ${name.first} - returns 'true' if the current data element is the first data element in the data set returned by the RowExpand Tag.
- ${name.last} - returns 'true' if the current data element is the last data element in the data set returned by the RowExpand Tag.
Standard Properties
description (optional)
A brief description of this Tag.
enabled (default: on)
Controls whether a Tag is executed when generating output. This can be useful when debugging a template.
- on - this Tag will be executed when output is generated.
- off - this Tag will not be executed when output is generated.
- engine-only - this Tag will be executed only if output is generated using one of the Report Engines.
- autotag-only - this Tag will be executed only if output is generated using Report Designer.
Advanced Properties
begin (optional)
The row or node in the RowExpand Tag data set to return first. This property is zero-based, i.e. the first element of the data set is begin=0, the second is begin=1, etc., and its range is 0 to 4,294,967,295.
break (optional)
Controls how to set a section break at the start of each iteration of the RowExpand Tag. This property has different settings for Word and Excel.
- Word settings
- page - inserts a next-page section break at the start of each iteration
- even - inserts an even-page section break at the start of each iteration
- odd - inserts an odd-page section break at the start of each iteration
- Excel settings
- sheet - inserts a new worksheet into the Excel workbook at the start of each iteration
- page - inserts a page break at the start of each iteration in the appropriate output type (e.g. PDF)
The 'page', 'even', and 'odd' settings create section breaks, not page breaks. This means each section will inherit the header/footer attributes of the previous section, including the previous section's Different First Page. To create a page break instead of a section break, set the Word paragraph formatting of the RowExpand Tag to "Page break before."
end (optional)
The last row or node in the RowExpand Tag data set to return. The default is the total number of rows or nodes in the data set returned by the RowExpand Tag. Its range is 0 to 4,294,967,295.
error-handling (optional)
Selects which types of errors produce warnings rather than exceptions, which allows output to be generated despite the error.
- Ignore type error - these errors occur when a Tag's defined data type is different than the data type of the data returned by the Tag's query
- Ignore formatting error - these errors occur when a Tag's specified format is not compatible with the format of the data returned by the Tag's query
- Ignore select error - these errors occur when a Tag's query fails to find valid data
- Node must exist - these errors occur when a row or node is queried which doesn't exist in the data source. These errors typically return an empty value that is output without warning.
- Node must not return NULL - these errors occur when a query returns an empty or NULL value. These errors typically return an empty value that is output without warning.
- Treat warning as error - forces all of the above error-handling warnings to appear as errors (not exceptions). This is useful when used with Report Designer's Verify feature.
formula-expansion (default: row)
This property is for excel formulas. It defines how formulas inside of a RowExpand will be expanded.
The first (default) option for formula-expansion is row
This entails that the formula range will expand row by row from the RowExpand, and each row will have its own sum
Example: You have a SUM() function expanding across the first row SUM(A1:C1). If there is a RowExpand expanding down 3 rows, the 2nd row should be SUM(A2, C2), and the last row result should be SUM(A3, C3). The functions will be excusive to each row
The other option for formula-expansion is block
This entails that the formula range will expand by row and column from the RowExpand.
Example: You have a SUM() function expanding across the first row SUM(A1:C1). If there is a RowExpand expanding down 3 rows, the 1st, 2nd and 3rd row should be SUM(A1, C3). The functions will encapsulate the block created by the RowExpand
restart (default: false)
If set to 'true', restarts the numbering of a numbered list after each iteration. This is useful for RowExpand Tag loops that contain numbered lists.
step (optional; default: 1)
Returns every stepth data element in the data set. For example, to skip every other data element, set step=2. The range is 0 to 4,294,967,295.
EndRowExpand Properties
Tag Properties
deleteRow (default: false)
By default, all of the content of the row containing the EndRowExpand Tag is output. When this property is set to 'true', nothing in the row containing the EndRowExpand Tag is output.
nickname (optional)
The nickname will appear in the template rather than the generic ":rowExpand" label. Descriptive nicknames can be very important in designing complex templates.
Standard Properties
description (optional)
A brief description of this Tag.
enabled (default: on)
Controls whether a Tag is executed when generating output. This can be useful when debugging a template.
- on - this Tag will be executed when output is generated.
- off - this Tag will not be executed when output is generated.
- engine-only - this Tag will be executed only if output is generated using one of the Report Engines.
- autotag-only - this Tag will be executed only if output is generated using Report Designer.