凭证查询预览界面,设置固定行数之后,页次不正确问题的解决办法
psr的sql语句 里面增加如下两个栏位: ROW_NUMBER() OVER (partition by t.sheet_no ORDER BY t.sheet_lot ) as seq, (select count(1) from oacc_voucher2 as a where a.sheet_no=t.sheet_no) as countrow 页次的计算列改为: '第' + ceiling(seq/sum( 1 for group 1) )+ ' 页,共 ' + ceiling( countrow /sum( 1 for group 1) )+'页'