sub total

Hi, Have been working out on this form with this script below:

DECLARE   
  CURSOR C1 IS
  Select count(*)TOT_COUNT
  from banks2 b, bayadcenter m
  where b.brstn=m.chk_rtno
  and m.cust_code='CUST03'
  and m.dep_date=:cgtemp.depdate
  order by m.coll_date,m.drn_no;

  CURSOR C IS
  Select m.dep_date, m.clearing, b.description, b.branch, m.drn_no, m.chk_no,
  m.chk_date, m.chk_amt,m.chk_rtno,m.coll_date
  from banks2 b,bayadcenter m
  where b.brstn=m.chk_rtno
  and m.cust_code='CUSTL03'
  and m.dep_date=:cgtemp.depdate