REPORTFORM;is6_E.frf
TITLE;ISSUE STOCK BY ID,DATE REPORT
SQL;select invcard.DOCNO, isshead.DPTID, depart.DDESC, isshead.JOBNO,
SQL;invcard.DATEDOC, invcard.ID, invmst.XDESC, invcard.QUAN, invcard.UNIT,
SQL;invcard.COST, invcard.COSTAMT, invcard.LOCID, isshead.REFNO,
SQL;isshead.XREMARK,isshead.FID, isshead.FQUAN, isshead.FUNIT
SQL;from invcard 
SQL;left join invmst on invcard.ID = invmst.ID
SQL;left join isshead on invcard.DOCNO = isshead.DOCNO
SQL;left join jobmst on isshead.JOBNO = jobmst.JOBNO
SQL;left join depart on isshead.DPTID = depart.DID
SQL;where left(invcard.DOCNO,2)= "IS"
SQL;order by invcard.ID, invmst.XDESC,invcard.DATEDOC, invcard.DOCNO 
CONDITION;FROM STOCK ID~INVCARD.ID~Chr~2~SELECT ID FROM INVMST ~INV
CONDITION;FROM DATE~INVCARD.DATEDOC~Date~2~~
