<?xml version="1.0" standalone="yes"?>  <DATAPACKET Version="2.0"><METADATA><FIELDS><FIELD attrname="F_ID" fieldtype="string" required="true" WIDTH="10"/><FIELD attrname="F_NAME" fieldtype="string" required="true" WIDTH="50"/><FIELD attrname="F_SELECTSQL" fieldtype="string" required="true" WIDTH="1000"/><FIELD attrname="F_ISFILTERDATE" fieldtype="string" required="true" WIDTH="2"/><FIELD attrname="F_REMARK" fieldtype="string" WIDTH="250"/><FIELD attrname="F_SUMFIELDNAMES" fieldtype="string" WIDTH="250"/></FIELDS><PARAMS CHANGE_LOG="1 0 4"/></METADATA><ROWDATA><ROW RowState="4" F_ID="01" F_NAME="卡类型消费汇总" F_SELECTSQL="select t_cardtype.f_name as &quot;卡类型&quot;, sum(F_CONSUME) as &quot;总消费&quot;, sum(F_CONSUME - F_REBATEMONEY - F_ODDMENT - F_TICKET) as &quot;应收&quot;, sum(F_GATHERING) as &quot;实收&quot; from T_CHECKOUT  inner join t_client on (t_client.f_id = T_CHECKOUT.f_clientid and cast(T_CHECKOUT.F_DateTime as Date) &gt;= :StartDate and cast(T_CHECKOUT.F_DateTime as Date) &lt;= :EndDate)  inner join t_cardtype on (t_client.f_cardtypeid = T_cardtype.f_id) group by t_cardtype.f_name" F_ISFILTERDATE="是" F_SUMFIELDNAMES="总消费;应收;实收"/></ROWDATA></DATAPACKET>