REPORTFORM;SA_PO.frf
TITLE;การขายแสดงตาม เลขที่ PO ลูกค้า
SQL;select arcard.DOCNO, arcard.ACCID, armst.XCOMP,
SQL;arcard.CUS_PO, arcard.DATEDOC, arcard.AMOUNT_D,
SQL;arcard.VATAMT,arcard.INVAMT,
SQL;arcard.SALEID, salemst.SNAME
SQL;from arcard inner join armst 
SQL;on arcard.ACCID = armst.ACCID
SQL;left join salemst on arcard.SALEID = salemst.SID
SQL;where left(docno,2) = 'IV'
SQL;order by accid, datedoc, cus_po
CONDITION;รหัสลูกค้า~ARCARD.ACCID~Chr~2~SELECT ACCID FROM ARMST~AR
CONDITION;ตั้งแต่วันที่~ARCARD.DATEDOC~Date~2~~
EXCELSQL;select arcard.DOCNO, arcard.ACCID, armst.XCOMP,
EXCELSQL;arcard.CUS_PO, arcard.DATEDOC, arcard.AMOUNT_D,
EXCELSQL;arcard.VATAMT,arcard.INVAMT,
EXCELSQL;arcard.SALEID, salemst.SNAME
EXCELSQL;from arcard inner join armst 
EXCELSQL;on arcard.ACCID = armst.ACCID
EXCELSQL;left join salemst on arcard.SALEID = salemst.SID
EXCELSQL;where left(docno,2) = 'IV'
EXCELSQL;order by accid, datedoc, cus_po
USECROSSTAB;N
CROSSTABFRF;N
CROSSTABHEAD;
CROSSTABFIELD;
