sql凭证分张+锐浪报表

select gl_v.inid,
(case when len(gl_v.ino_id)=1 then '000'+convert(varchar,gl_v.ino_id)
when len(gl_v.ino_id)=2 then '00'+convert(varchar,gl_v.ino_id)
when len(gl_v.ino_id)=3 then '0'+convert(varchar,gl_v.ino_id)
else convert(varchar,gl_v.ino_id) end) as ino_ids,
(case when len((gl_v.inid-1)/5+1)=1 then '000'+convert(varchar,((gl_v.inid-1)/5+1))
when len((gl_v.inid-1)/5+1)=2 then '00'+convert(varchar,((gl_v.inid-1)/5+1))
when len((gl_v.inid-1)/5+1)=3 then '0'+convert(varchar,((gl_v.inid-1)/5+1))
else convert(varchar,((gl_v.inid-1)/5+1)) end) as to_ids,
(select (case when len(count(ino_id)/5+1)=1 then '000'+convert(varchar,(count(ino_id)/5+1))
when len(count(ino_id)/5+1)=2 then '00'+ convert(varchar,(count(ino_id)/5+1))
when len(count(ino_id)/5+1)=3 then '00'+ convert(varchar,(count(ino_id)/5+1))
else convert(varchar,(count(ino_id)/5+1)) end) from gl_voucherdetail where csign=gl_v.csign and ino_id=gl_v.ino_id) as sumino_id,

gl_v.ino_id,((gl_v.inid-1)/5+1) as ns,org.orgname,vc.vctext,gl_v.csign,gl_v.cdigest,
gl_v.ccode,gl_c.ccode_name,gl_v.md,
gl_v.mc,gl_v.idoc,gl_v.cbill,gl_v.ccheck,gl_v.cbook,gl_v.ccashier
from gl_voucherdetail gl_v
left join GL_Code gl_c on gl_v.ccode=gl_c.ccode
left join GL_VoucherClass vc on gl_v.csign= vc.vcsign
left join AS_Orgs org on gl_v.OrgCode=org.OrgCode
where 1=1
group by gl_v.orgcode,gl_v.ccode,gl_v.iyear,gl_v.iperiod,gl_v.ino_id,
org.orgname,vc.vctext,gl_v.csign,gl_v.cdigest,gl_v.ccode,gl_c.ccode_name,
gl_v.md,gl_v.mc,gl_v.idoc,gl_v.cbill,gl_v.ccheck,
gl_v.cbook,gl_v.ccashier ,gl_v.inid
order by gl_v.csign,gl_v.ino_id,gl_v.inid