<HTML>
 <HEAD>
  <TITLE>Customer/Orders Listing</TITLE>
  <link href="Templates/styles.htm" rel="stylesheet" type="text/css">
 </HEAD>
 <BODY>
  <CENTER><H2><B><I>Customer/Orders Listing</I></B></H2></CENTER>
  <TABLE WIDTH=100% CLASS=tablestyle CELLSPACING=0>
   <DBD_DATASET NAME="SimpleList" DATABASE="DBDEMOS" TABLE="customer.db" INDEX="Company">
   <DBD_DATASET NAME="DetailList" DATABASE="DBDEMOS" TABLE="orders.db" MASTER="SimpleList" LINK="CustNo">
    <TR BGCOLOR=#E0E0E0>
     <TD><B>Company</B></TD><TD><B>Contact</B></TD><TD><B>Phone</B></TD><TD><B>Fax</B></TD><TD><B>Cust No</B></TD>
    </TR>
    <DBD_DATA COUNT="MAX" DATASET="SimpleList">
     <TR BGCOLOR=#EFEFEF>
      <TD><DBD_DATAFIELD DATASET="SimpleList" VALUE=_Company CONTENT=VALUE></TD>
      <TD><DBD_DATAFIELD DATASET="SimpleList" VALUE=_Contact CONTENT=VALUE></TD>
      <TD><DBD_DATAFIELD DATASET="SimpleList" VALUE=_Phone CONTENT=VALUE></TD>
      <TD><DBD_DATAFIELD DATASET="SimpleList" VALUE=_Fax CONTENT=VALUE></TD>
      <TD><DBD_DATAFIELD DATASET="SimpleList" VALUE=_CustNo CONTENT=VALUE></TD>
     </TR>
     <DBD_DATA COUNT="MAX" DATASET="DetailList">
      <DBD_DATAGROUP NAME=CUSTOMERNAME DATASET="SimpleList" EXPR="_CustNo">
       <TR>
        <TD> </TD>
        <TD><I><U>Order No</U></I></TD>
        <TD><I><U>Date</U></I></TD>
        <TD ALIGN=right><I><U>Amount</U></I></TD>
       </TR>
      </DBD_DATAGROUP>
      <TR><TD> </TD>
       <TD><DBD_DATAFIELD DATASET="DetailList" VALUE=_OrderNo CONTENT=VALUE></TD>
       <TD><DBD_DATAFIELD DATASET="DetailList" VALUE=_SaleDate CONTENT=VALUE></TD>
       <TD ALIGN=right><DBD_DATAFIELD DATASET="DetailList" VALUE="FORMAT(_ItemsTotal,%.2m)" CONTENT=EXPR>
           <DBD_VARIABLE DATASET="DetailList" NAME=COUNTER VALUE="COUNT(_OrderNo)">
           <DBD_VARIABLE DATASET="DetailList" NAME=TOTAMOUNT VALUE="SUM(_ItemsTotal)">
       </TD>
      </TR>
     </DBD_DATA>
     <TR BGCOLOR=#EFEFEF>
       <TD>Total orders: <DBD_VARIABLE DATASET="DetailList" NAME=COUNTER VALUE=SHOW()></TD>
       <TD COLSPAN=3 ALIGN=right>Total amount: <DBD_VARIABLE DATASET="DetailList" NAME=TOTAMOUNT VALUE=SHOW(%.2m)></TD>
       <TD> </TD>
     </TR>
     <tr><td> </td></tr>
    </DBD_DATA>
   </DBD_DATASET>
   </DBD_DATASET>
  </TABLE>
 </BODY>
</HTML>