You can use reports to dynamically fill out fields in templates and forms.
Template report with repeating data fills a set of form templates
To use a report to fill out a template:
Enter field data in cells on the report. For repeating data:
Repeating cells mapped to static template fields make a new instance of the template for each repeat.
Repeating cells mapped to limited-repeating template fields make a new instance of the template each time the number of values exceeds the limit. This is often undesirable - ensure that there are appropriate constraints on your data and enough fields to fit it all.
Repeating cells mapped to unlimited-repeating template fields never make a new instance of the template. Overflowing data is cut off.
From the Report Options >
Template window, select an existing template or click the Upload Template
icon and add a new one.
For each template field, select either:
A report cell containing text or data. Images, visualizations, and other widgets are not supported.
Leave as is - Any bookmark text shows as-is in the output
Nothing - The field is blank
Click OK.
To remove a template from a report:
From the Template window, select the blank option from the template list.
Click OK.
Tip
Template reports must be exported in the same file type as the template. You may want to limit the export types to only that type using theReport Options > General Options window.
The process for making templates differs between the three supported types: PDF, Word, and Excel; as do the available features.
Caution
Close the template file before running or saving a report that uses it, or you may get an error.
PDF templates support static fields and limited-repeating fields. PDFs are convenient for preexisting and standardized forms, such as for government or businesses.
To make a PDF template:
Open a PDF in a PDF editor program, such as Adobe Acrobat or PDFescape.
Add form fields where you will insert report data. For fields where text may span multiple lines, select the multi-line property.
Give each form field a unique name, as follows:
For static fields, which appear only once per template instance, use any name, with the exception of the format reserved for repeating fields.
For repeating fields, which are mapped to consecutive values in a repeating cell, use the following naming format:
Name.0, Name.1,...
Where Name
is shared by the repeating fields, and 0
maps to the first value, 1
maps to the next value, and so on.
Save the PDF. Then upload it to the report.
Word templates support static fields, limited and unlimited-repeating fields, and conditional suppression.
Tip
Supported file types are .doc, .docx, and .rtf. Report templates exported as "RTF" will save to the original file type.
To make a Word template:
Open a Word file in Microsoft Word or a compatible document editor.
Add text where you will insert report data.
Select the text and add a bookmark.
Give each bookmark a unique name, as follows:
For static fields, which appear only once per template instance, use any name, with the exception of the formats reserved for repeating and conditional fields.
For limited-repeating fields, which are mapped to consecutive values in a repeating cell, use the following naming format:
Name_0, Name_1,...
Where Name
is shared by the repeating fields, and 0
maps to the first value, 1
maps to the next value, and so on.
For unlimited-repeating fields, which are mapped to all the values in a repeating cell, use the following naming format:
RepeatForEach_Name
Where Name
is a unique name.
Optional: To conditionally show or hide text:
Select the text and add a bookmark with the following naming format:
KeepIF_Name
Where Name
is a unique name.
In the report, map this field to a cell with a formula that returns 1 if the text should be shown, and 0 if the text should be hidden.
Example
=If ( {Products.ProductName} = "Chai", 1, 0 )
Save the file. Then upload it to the report.
Excel templates work differently than other types. Templates are used to fill Excel columns with report data. This is useful for passing data to Excel charts, pivot tables, and macros.
To make an Excel template:
Open an Excel file in Microsoft Excel or a compatible spreadsheet editor.
The first worksheet is used for dynamic report data. Repeating cells are mapped to columns in the worksheet. For each column where you will add report data, enter a unique name to the topmost cell in the column. All following cells must be empty.
Formatting an Excel file to be used as a template
Save the file. Then upload it to the report.