70 | VSTAT (Custom Report)

This article demonstrates an example of a Custom VSTAT Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.

This article demonstrates an example of a Custom VSTAT Report.

Disclaimer:

This report may need modifications or alterations base on each system setup and configuration.

Report Query:

<?xml version="1.0" encoding="utf-8"?>

<cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<iListType>25</iListType>

<dtDateUpdated>2013-07-19T12:22:58</dtDateUpdated>

<iOperatorID>0</iOperatorID>

<sName>VSTAT</sName>

<sViewXML><?xml version="1.0" encoding="utf-16"?><cCustomReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><sReportName>Voucher Statistics</sReportName><sSQL>SELECT VoucherSetup.Name, SUM(Voucher.UsedCount) AS Used, SUM(1) AS Issued, CONVERT(decimal(10, 2), SUM(Voucher.UsedCount)) / SUM(1)

* 10000 AS Expr1

FROM Voucher INNER JOIN

VoucherSetup ON Voucher.VoucherSetupID = VoucherSetup.VoucherSetupID

where Voucher.IssuedShiftID &gt;= {ShiftFrom} and Voucher.IssuedShiftID &lt;= {ShiftTo}

GROUP BY VoucherSetup.Name</sSQL><oColumnDefs><dictionary><item><key>0</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;0&lt;/sKey&gt;&lt;sText&gt;Voucher Name&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>1</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;1&lt;/sKey&gt;&lt;sText&gt;Used Count&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>2</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;2&lt;/sKey&gt;&lt;sText&gt;Issued Count&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>3</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;3&lt;/sKey&gt;&lt;sText&gt;Redemption Rate&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Perc2Int&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item></dictionary></oColumnDefs></cCustomReport></sViewXML>

70 | VSTAT (Custom Report)

This article demonstrates an example of a Custom VSTAT Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.

Disclaimer:

Report Query:

<?xml version="1.0" encoding="utf-8"?>

<cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<iListType>25</iListType>

<dtDateUpdated>2013-07-19T12:22:58</dtDateUpdated>

<iOperatorID>0</iOperatorID>

<sName>VSTAT</sName>

* 10000 AS Expr1

FROM Voucher INNER JOIN

VoucherSetup ON Voucher.VoucherSetupID = VoucherSetup.VoucherSetupID

where Voucher.IssuedShiftID &gt;= {ShiftFrom} and Voucher.IssuedShiftID &lt;= {ShiftTo}

</cViews>

Other Parameter Settings:

This file needs to be saved as a *.REP file using a document editor

70 | VSTAT (Custom Report)

This article demonstrates an example of a Custom VSTAT Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.

Disclaimer:

Report Query:

<?xml version="1.0" encoding="utf-8"?>

<cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<iListType>25</iListType>

<dtDateUpdated>2013-07-19T12:22:58</dtDateUpdated>

<iOperatorID>0</iOperatorID>

<sName>VSTAT</sName>

* 10000 AS Expr1

FROM Voucher INNER JOIN

VoucherSetup ON Voucher.VoucherSetupID = VoucherSetup.VoucherSetupID

where Voucher.IssuedShiftID &amp;gt;= {ShiftFrom} and Voucher.IssuedShiftID &amp;lt;= {ShiftTo}

</cViews>

Other Parameter Settings:

This file needs to be saved as a *.REP file using a document editor

where Voucher.IssuedShiftID >= {ShiftFrom} and Voucher.IssuedShiftID <= {ShiftTo}