Report Output TemplateLast Updated: 09/26/2018 Introduced in Version: 3.2
This tutorial demonstrates how to configure the settings for Report Data to Output information onto an Excel Template.
Note: A Report should already be created in order to upload Report Data onto an Excel Template.
Create an Excel Template to run a Report. Start in designer Folders and navigate to the System > Designers > Report Output > Templates Folder and select Add Excel Template from the Folder Actions Panel.
In the Data section under Name create the Template name. In the Template Properties section under Template Drag or Choose the Excel File Template.
This Excel File can contain any components like Logo’s and columns formatting.
In this Example configure the Report Data to the Start Row and Start Column. The Report Data will populate the specified rows and columns.
In the Data Grouping section select the properties needed for the report. Check the box next to Include Groups so that they display on the Report. Select Save Template to save the Excel Template.
The New Excel Template is saved in the Templates Folder and should be available in the drop down to use when downloading the report to send.
After the Excel Template has been created, Navigate out and back into the designer Folder. Open the Folder with the Data that is going to populate the Excel File Template (My Company Excel Template).
In the Settings section under Format select Excel. Now under the Output Type now choose Default Excel Template (previously uploaded), this is where the Report Data is uploaded onto the Default Excel Template. Select Proceed to continue and download.
Portal prepares printing view and we can click Download Exported Report link to save our Report.
The file was successfully downloaded.
Now open the Accounts Report Excel File in Excel, Google sheets or any other software compatible. The Report will now be completely uploaded to the Excel Template.
Finally, locate the file that was downloaded and open it. This time the report output has been formatted with the custom Template.