2019.1

// Create the number of rows based on the records in the detail
table
// We start at 1 so the boilerplate row is used too and there is no
need to delete that row
for(var r = 1; r < record.tables['detail'].length; r++) {
results.parent().append(results.clone());
}
// Iterate over the rows and populate them with the data from the
accompanying data row
query("#table_2 > tbody > tr").each(function(i) {
this.find('@ItemNumber@').text( record.tables['detail'][i].fields
["ItemNumber"]);
this.find('@ItemOrdered@').text( record.tables['detail'][i].fields
["ItemOrdered"]);
this.find('@ItemTotal@').text( record.tables['detail'][i].fields
["ItemTotal"]);
this.find('@ItemDesc@').text( record.tables['detail'][i].fields
["ItemDesc"]);
this.find('@nr@').text(i);
});
The following script clones and populates a boilerplate row. Once completed you will need to
hide the boilerplate row.
sheetConfig
Sheet configuration settings are the Master Page, Media and Duplex printing options of
first/middle/last/single or all sheets in a Print section. The sheetConfig object holds these
options and can be used to set (or rather, override) them via a Control Script (see "Control
Scripts" on page390 and "Control Script API" on page811). This is especially useful when you
need identical sections with different sheet configuration settings.
The sheetConfig object can be retrieved via the section object (see "section" on page847);
see the example below.
Fields
The fields of the sheetConfig object correspond to settings in the Sheet Configuration dialog;
see "Sheet Configuration dialog" on page485.
Page 828