标准考场编排:从左上角开始,呈S形,5列,6行,准考证号连续进行。
在VFP报表中没有按S形打印功能,为实现座次表的直观表现,可辅助设置一个位置对照表,如下图
然后在此表和相应的表上建立一个视图,参考sql如下:
SELECT Bmk1.xm AS 姓名, Bmk1.kkh AS 准考证号, SUBSTR(Bmk1.kkh,1,4) AS 县区, SUBSTR(Bmk1.kkh,5,1) AS 文理,;
STR(CEILING(VAL(SUBSTR(ALLTRIM(Bmk1.kkh),6,4))/30)) AS 考场, Js.zc AS 座次;
FROM chaxun!bmk1 ;
INNER JOIN chaxun!js ;
ON MOD(VAL(SUBSTR(ALLTRIM(Bmk1.kkh),6,4)),30) = Js.bh;
ORDER BY 3, 4, 5, Js.zc