DO set_menu
= get_pdt('Sales Tax Statement Monthly Summary')
do attention with 'This report is based on Bill Date'
SELECT year(bill_dt),month(bill_dt),sale_typ,pay_mode,st_rt, ;
	sum(tot_spares) as tot_spares, ;
	sum(sdisc_amt) as sdisc_amt ,sum(bill_amt) as bill_amt ,;
	sum(tot_labour) as tot_labour,sum(labourdisc) as labourdisc,;
	sum(tot_oil) as tot_oil,sum(labtaxamt) as labtaxamt,;
	sum(itst_amt) as itst_amt ;
	from job_mast,job_body ;
	where job_body.jobcard_no = job_mast.jobcard_no ;
		and betw(job_mast.bill_dt,date1,date2) ;
	group by 1,2,3,4 ;
	into cursor query

DO cls_menu