REPORTFORM;AR_SHOWBILL.frf
TITLE;รายละเอียดลูกค้า แสดงเงื่อนไขวางบิล
SQL;select armst.ACCID,
SQL;armst.XCOMP, 
SQL;if(trim(armst.SHIPTO_1)="", armst.ADD_1,armst.SHIPTO_1) as shipto_1,
SQL;if(trim(armst.SHIPTO_2)="", armst.ADD_2,armst.SHIPTO_2) as shipto_2,
SQL;armst.BILLCOND, armst.CHKCOND
SQL;from armst order by accid
CONDITION;ตั้งแต่รหัสลูกค้า~ARMST.ACCID~Chr~2~SELECT ACCID FROM ARMST~AR
EXCELSQL;select armst.ACCID,
EXCELSQL;armst.XCOMP, 
EXCELSQL;if(trim(armst.SHIPTO_1)="", armst.ADD_1,armst.SHIPTO_1) as shipto_1,
EXCELSQL;if(trim(armst.SHIPTO_2)="", armst.ADD_2,armst.SHIPTO_2) as shipto_2,
EXCELSQL;armst.BILLCOND, armst.CHKCOND
EXCELSQL;from armst order by accid
USECROSSTAB;N
CROSSTABFRF;N
CROSSTABHEAD;
CROSSTABFIELD;
