iReport画出来的报表可以满足我们大部分的需要,所以采用iReport 编辑jrxml文件是我们的首选啦!当然掌握jrxml文件的结构也是必须的。
采用JDBC数据源必须有数据库支持啊!我们新建一个test表,其中有pid、name、sex、password、department、age字段,为了方便期间我们定义这些字段全部为String类型。
在iReport中新建一报表,报表有title、pageHeader、columnHeader、detail、columnFooter、pageFooter、lastPageFooter、summary等部分,被成为Report section
title:顾名思义是指报表的标题哦,它会显示在报表的最上面,如果有多页只会出现在第一页的最上面。pageHeader:每页的标题,如果有多页每页的开始都会显示此部分内容。
columnHeader:显示报表的列头不经常使用。
detail:这个就不用说了吧!
有header就会出现footer啦!lastPageFooter只会出现在最后一页。summay会出现在每一页数据上,主要是为了展示一些统计信息,比如当前的时间,页数信息啦!
新建一parameter
此参数可作为报表的标题使用,我们在程序中动态的传递给报表。
document structure---》parameter里找到reportTitle参数拖至title区域,右击编辑reportTitle域的属性,在font选项里找到Markup设置为HTML,TextField选项里设置Text Field Expreesion为
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
下来就是设置报表的Field字段了,不需要我们一个个的新建那些字段啦!
选择Data--->Report Query在Report Query选项里选择Query Language为SQL,写入SqL语句
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
这时所有的field会出现在下面(SQL是正确的)
关闭对话框在document structure---》field中就会出现我们需要的field,之后拖到相应的位置,关于怎么美化报表这个本人也不是很懂哦!
如果需要显示一下当前的页数信息也可以自己托动Variables里的PAGE_NUMBER完成页数的显示。完整的jrxml文件如下:
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)
![](http://chunpeng.iteye.com/Images/OutliningIndicators/None.gif)