s, 201 querys will be executed (once for each custno and the main query).</p>
<p>To enhace performance we will execute 2 querys one for the detail and another 
  for all totals by customer.</p>
<p>1.Create a database connection.<br>
  2.Create a MyBase connection.</p>
<p>DETAIL dataset with database connection with the sql:<br>
  SELECT CUSTNO,ARTNO,QTY,PRICE,AMOUNT FROM SALES ORDER BY CUSTNO</p>
<p>TOTALS dataset with database connectoin with the sql<br>
  SELECT CUSTNO,SUM(AMOUNT) AS AMOUNT FROM SALES GRO