When outputting child records, output in a multi-line layout per record.
*This feature is available in Office File Creator Pro.
Overview
Normally, one line of output is provided for each child record, but block output can be done by block layout with multiple lines of child records in the template file.
Examples of Use
- Output 3 lines per child record.
Required settings
- Merge Fields Settings
Merge Fields Settings
Block Layout Settings (multiple lines per record)
Set multiple lines of merge fields of the child object in the template file. The first to last row of the child object merge field becomes one block of the child record.
To insert blank lines between blocks of child records, use the Blank() function for the merge field.
e.g. {!OpportunityLineItems.Blank()}
Excel Consideration
When outputting to Excel, if the cells in the last row are merged, cell merging is not taken into account in determining the last row. Adjust the last row of the block by setting the Blank() function outside the display range of the last row.
Word/PowerPoint/PDF Consideration
When outputting Word/PowerPoint/PDF, all merge fields of the same child object should be set in a single table.
NG example: The following case will be an error because the child object merge fields "{!OpportunityLineItems.Blank()}"
is outside the table.
Output Sample
Excel
Word
Considerations
- When outputting blocks, Office features such as Excel formulas, data validations, and conditional formatting cannot be used. If they are used, they will be misaligned or cause an error in the output.
Reference
Output Child Records in Block Format Layout