DO SET_MENU
=get_pdt('*** JOB CARD REGISTER ****')
SELECT job_mast.jobcard_no,client.client,client.modelcolno,client.vehicle_no, ;
	job_mast.kms,job_mast.servicetyp,job_mast.category,job_mast.serviceseq, ;
	job_mast.coupon_no,mechanic.mechanic,job_mast.status,job_mast.bill_no, ;
	job_mast.bill_dt, ;
	job_mast.tot_spares,job_mast.tot_labour,job_mast.tot_oil, ;
	job_mast.sp_disc,job_mast.OIL_DISC,job_mast.acc_disc,job_mast.sp_discamt,job_mast.accessory, ;
	job_mast.pay_mode,job_mast.bill_amt ;
FROM job_mast JOIN client ON job_mast.client_no = client.client_no ;
	LEFT JOIN mechanic ON job_mast.mechanicno = mechanic.mechanicno ;
WHERE BETWEEN(job_mast.job_dt,date1,date2) ;
	AND job_mast.jobcard_no <> "DS" ;
ORDER BY job_mast.jobcard_no ;
INTO CURSOR QUERY

SELECT QUERY 
GO TOP
IF RECCOUNT() <> 0
  do prinrepo with '','vjobrepo','','',''
ENDIF 
USE IN QUERY

	
DO CLS_MENU