报表制作流程.docxVIP

报表统计说明及程序文档 报表制作流程 准备统计语句 目前统计没有采用交叉报表， 只有固定报表中使用子报表， 其他报表部分都是使用的普通报 表，也就是通过 SQL语句查询出数据，然后在 jasperreport中展示出相应字段。 如低保类别统计的 SQL语句： select unit_name, vbed_depart_report.unit_id, result_t.* from vbed_depart_report left outer join ( select result_data.*, round(moneycount / decode(membercount, 0, 1 , membercount), 0) as moneyaverage, round(moneycount1 / decode(membercount1, 0, 1, membercount1), 0) as moneyaverage1, round(moneycount2 / decode(membercount2, 0, 1, membercount2), 0) as moneyaverage2, round(moneycount3 / decode(membercount3, 0, 1, membercount3),  0) as moneyaverage3 from ( select decode(substr(unit_id, 0, to_number( 12 )), 1596 159601, substr(unit_id, 0, to_number( 12))) aunit_id, sum ( 1) as homecount, sum (a.sure population) as membercount, sum (a.money) as moneycount, SUM( CASE A.ensure type WHEN 1 THEN END) as homecount1, SUM( CASE A.ensure_type WHEN 1 THEN A.sure_population ELSE 0 END) as membercount1, SUM( CASE A.ensure_type WHEN 1 THEN A.money ELSE 0 END) as moneycount1, SUM( CASE A.ensure_type WHEN 2 THEN 1 ELSE 0 END) as homecount2, SUM( CASE A.ensure type WHEN 2 THEN A.sure population ELSE0 END) as membercount2, SUM( CASE A.ensure type WHEN 2 THEN A.money ELSE 0 END) as moneycount2, SUM( CASE A.ensure type WHEN 3 THEN 1 ELSE 0 END) as homecount3, SUM( CASE A.ensure type WHEN 3 THEN A.sure population ELSE 0 END) as membercount3, SUM( CASE A.ensure_type WHEN 3 THEN A.money | ELSE 0 END) as moneycount3 from vreport home his new a where a.iscity = 1 and a.unit_id like 150302001001% AND A.PERMIT DATE = to_date( 2010-11-1 , yyyy-mm-dd ) and decode(A.STOP DATE, null , to_date( 2050-5-1 , yyyy-mm-dd ), A.STOP DATE) to date( 2010-11-1 , yyyy-mm-dd ) and a.vp state = 4 group by substr(unit id, 0, to number( 12))) result_data) result_t on vbed_depart_report.unit_id = result_t.aunit_id where upunit id = 150302001 and vbed_depart_report.unit_id like 150302001001% 使用ireport报表设计器设计样式表 a）配置数据连接 在Ireport 在Ireport菜单中数据-数据源连接中新建一个 jdbc连接，如下图 port port眼表设计器 3. 0.