I have a following ZEN report:
Class ZENApp.Report Extends %ZEN.Report.reportPage
{
/// Class name of application this report belongs to.
Parameter APPLICATION = "ZENApp.SampleApp";
/// Specifies the default display mode used for this report if
/// the URL parameter, <var>$MODE</var>, is not present.
Parameter DEFAULTMODE As STRING = "xlsx";
/// This XML defines the logical contents of this report.
XData ReportDefinition [ XMLNamespace = "http://www.intersystems.com/zen/report/definition" ]
{
<report xmlns="http://www.intersystems.com/zen/report/definition"
name="MyReport"
sql="SELECT TOP 10 Name,DOB,Age FROM Sample.Person"
runtimeMode="0">
<group name="Person">
<attribute name="name" field="Name"/>
<attribute name="dob" field="Dob"
expression="..ToExcelDate(%val)"/>
<attribute name="age" field="Age"/>
</group>
</report>
}
/// This XML defines the display for this report.
/// This is used to generate the XSLT stylesheets for both HTML and XSL-FO.
XData ReportDisplay [ XMLNamespace = "http://www.intersystems.com/zen/report/display" ]
{
<report xmlns="http://www.intersystems.com/zen/report/display"
name="MyReport">
<body>
<table group="Person" excelSheetName="Persons"
excelGroupName="Person" oldSummary="false">
<item field="@name" excelName="$$$Name" />
<item field="@dob" isExcelDate="true"
excelName="$$$Date of Birth" />
<item field="@age" isExcelNumber="true"
excelName="$$$Age">
</item>
</table>
</body>
</report>
}
}
