User Manual

Reports
12 Reports
The report generator allows generating Excel reports based on an Microsoft Excel
made report template.
The generated report can be output to a printer or saved as an Excel file.
12.1 ReportsTemplateSetup
The tag data to be displayed in the report file are set up in the template file using
“placeholders”.
Theplaceholdersactsassubstitutefortheactualtagdatathatistobeinserted
when the report is generated in iX Runtime.
To add a placeholder, enter the following text inside a cell in the Excel report
template:
<#Tag(TagName)>
Replace “TagName” with the actual name of the tag to be displayed.
When the template file is complete it needs to be added to the iX Developer
project.
Note:
Thetagplaceholderscanonlybeusedinthecellsofth
eExceltemplatefile,theycan
notbeusedin,for example,MicrosoftExcelWordArt
texts.
12.1.1 Limitations
• Microsoft Excel xlsx format is not support
ed by the report generator.
• Microsoft Excel xls format only suppo
rts 65536 rows. If more data is stored in
the report, information may be lost.
• Reports containing charts and pict
ures can not be printed from a panel target.
• The report generation is not an ins
tant process. It may elapse a shorter period
of tim e between the first sampled t
ag and the last sampled tag, depending on
the number of tags to process.
12.1.2 DatabaseDrivenReports
To be able to create database driven reports, the report template must be prepared
as described in these instructions:
Note:
Querieshavetobewritteninalanguage supportedbythesel ected database. See
Database formoreinformation.
BeijerElectronics, MAEN831P
281