<HTML>
 <HEAD>
  <TITLE>Several Grouping Levels</TITLE>
  <link href="Templates/styles.htm" rel="stylesheet" type="text/css">
 </HEAD>
 <BODY>
  <CENTER><H2><B><I>Several Grouping Levels</I></B></H2></CENTER>
  <TABLE WIDTH=100% CLASS=tablestyle CELLSPACING=0>
   <DBD_DATASET 
	NAME="SimpleList" 
	DATABASE="DBDEMOS" 
	QUERY="select * from customer a, orders b, items c, parts d where a.custno = b.custno and b.orderno = c.orderno and c.partno = d.partno order by a.company, orderno" 
	STARTINGPOS="1">
    <DBD_DATA COUNT="MAX" DATASET="SimpleList">

     <DBD_DATAGROUPFOOTER NAME=ORDERGROUP DATASET="SimpleList" EXPR="_OrderNo">
      <TR BGCOLOR=#EFEFEF><TD COLSPAN=3 ALIGN=right>Total this order: <DBD_VARIABLE DATASET="SimpleList" NAME=TOTORDER VALUE=SHOW(%.2m)></TD></TR>
      <TR></TR>
     </DBD_DATAGROUPFOOTER> 

     <DBD_DATAGROUPFOOTER NAME=CUSTOMERGROUP DATASET="SimpleList" EXPR="_Company">
      <TR BGCOLOR=#E0E0E0><TD COLSPAN=3 ALIGN=right>Total this customer: <DBD_VARIABLE DATASET="SimpleList" NAME=CUSORDER VALUE=SHOW(%.2m)></TD></TR>
      <TR><TD> </TD></TR>
     </DBD_DATAGROUPFOOTER>

     <DBD_DATAGROUP NAME=CUSTOMERGROUP DATASET="SimpleList" EXPR="_Company">
      <TR BGCOLOR=#E0E0E0>
       <TD COLSPAN=3><B><DBD_DATAFIELD DATASET="SimpleList" VALUE=_Company CONTENT=VALUE></B>
        <DBD_VARIABLE DATASET="SimpleList" NAME=CUSORDER VALUE=SET(0)>
       </TD>
      </TR>
     </DBD_DATAGROUP> 
     <DBD_DATAGROUP NAME=ORDERGROUP DATASET="SimpleList" EXPR="_OrderNo">
      <TR BGCOLOR=#EFEFEF>
       <TD>Order No: <DBD_DATAFIELD DATASET="SimpleList" VALUE=_OrderNo CONTENT=VALUE></TD>
       <TD COLSPAN=2>Date: <DBD_DATAFIELD DATASET="SimpleList" VALUE=_SaleDate CONTENT=VALUE></TD>
      </TR>
      <TR>
       <TD><I><U>Part No:</U></I></TD><TD><I><U>Description</U></I></TD>
       <TD ALIGN=right><I><U>List Price</U></I>
	<DBD_VARIABLE DATASET="SimpleList" NAME=TOTORDER VALUE=SET(0)>
       </TD>
      </TR>
     </DBD_DATAGROUP> 
     <TR>
      <TD><DBD_DATAFIELD DATASET="SimpleList" VALUE=_PartNo CONTENT=VALUE></TD>
      <TD><DBD_DATAFIELD DATASET="SimpleList" VALUE=_Description CONTENT=VALUE></TD>
      <TD ALIGN=right><DBD_DATAFIELD DATASET="SimpleList" VALUE="FORMAT(_ListPrice,%.2m)" CONTENT=EXPR>
	<DBD_VARIABLE DATASET="SimpleList" NAME=TOTORDER VALUE=SUM(_ListPrice)>
	<DBD_VARIABLE DATASET="SimpleList" NAME=CUSORDER VALUE=SUM(_ListPrice)>
      </TD>
     </TR>
    </DBD_DATA>
    <TR BGCOLOR=#EFEFEF><TD COLSPAN=3 ALIGN=right>Total this order: <DBD_VARIABLE DATASET="SimpleList" NAME=TOTORDER VALUE=SHOW(%.2m)></TD></TR>
    <TR BGCOLOR=#E0E0E0><TD COLSPAN=3 ALIGN=right>Total this customer: <DBD_VARIABLE DATASET="SimpleList" NAME=CUSORDER VALUE=SHOW(%.2m)></TD></TR>
   </DBD_DATASET>
  </TABLE>
 </BODY>
</HTML>