Sections of Excel Template defined as name ranges can be automatically inserted into the generated Word report.
Step 1
Insert a bookmark called “PreRender_Name” in any part of the word template. Note that “Name” can be any word of your choosing i.e. PreRender_Excel. This acts as a placeholder to allow you to link multiple excel template to the one Word report.
Step 2
After inserting the main bookmark “PreRender_Name”, you will now need to insert the name range bookmark called “PreRender_Name_NameRange” on the section of the word template where the excel report section is to be displayed. Note that the “NameRange” should be the same as the name range used on the excel template to encapsulate the section you wanted to show.For example “PreRender_Excel_Warehouse”.
Name Range on Excel template
Save all the changes on the word and excel templates then upload it back into the system.
Step 3
After uploading the templates, go to the “Report Templates” on the Report Template card. Under the “Report Dependencies” list, you will see the main bookmark/s inserted on the word template (PreRender_Name). On the second column of the list, you now need to select the excel template that you want to link to the word template. Finally, set the “Insert Type” to “Convert to Word” then press Save Changes.
Step 4
When the report is generate from the job card, the system will first generate the linked excel template and then generate the word report. The linked name ranges will then be inserted into the appropriate areas of the word report.
Excel Report:
Word Report:
