JasperReports Subreport 实例_语言综合

概述公司的项目需要将数据导出为excel和pdf，之前用过vba和poi，这次要使用jasper reports，期间遇到一个关于subreport的问题，现已解决，放出给大家参考。首先说明一下，subreport是iReport template编辑器中的一个概念，相当于主从关系，比如有主列表里面是国家名称，在每个国家名称下，会有不同的城市名称，这个城市列表就是subreport，是作为另一

公司的项目需要将数据导出为excel和pdf，之前用过vba和poi，这次要使用jasper reports，期间遇到一个关于subreport的问题，现已解决，放出给大家参考。

首先说明一下，subreport是iReport template编辑器中的一个概念，相当于主从关系，比如有主列表里面是国家名称，在每个国家名称下，会有不同的城市名称，这个城市列表就是subreport，是作为另一个独立的report被引用的。这里仅演示二级从属关系，按需求可以再使用subreport扩展为多层关系。

这是效果图:

开始贴代码：

mainreport.jrxml(主表)

<?xml version="1.0" enCoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="mainreport" language="groovy" pageWIDth="842" pageHeight="595" orIEntation="Landscape" columnWIDth="802" leftmargin="20" rightmargin="20" topmargin="20" bottommargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="subReportObject" isForPrompting="false"/> <fIEld name="countryname" /> <fIEld name="cityDs" /> <variable name="countryname_1" resetType="Column" calculation="distinctCount"> <variableExpression><![cdaTA[$F{countryname}]]></variableExpression> </variable> <Title> <band height="71" splitType="Stretch"> <frame> <reportElement mode="Opaque" x="85" y="0" wIDth="546" height="24" backcolor="#66FF33"/> </frame> <staticText> <reportElement x="85" y="24" wIDth="546" height="47"/> <textElement textAlignment="Center"> </textElement> <text><![cdaTA[JasperReports subreport Demo (V3.7.4)]]></text> </staticText> </band> </Title> <pageheader> <band height="38" splitType="Stretch"> <staticText> <reportElement x="85" y="0" wIDth="546" height="38"/> <textElement verticalAlignment="top"/> <text><![cdaTA[this demo shows how to compose a classic master-detail report. Master level is a country List,the detail level is the related citIEs List.]]></text> </staticText> </band> </pageheader> <columnheader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="85" y="0" wIDth="100" height="20"/> <textElement> </textElement> <text><![cdaTA[Country name]]></text> </staticText> </band> </columnheader> <detail> <band height="94" splitType="Stretch"> <textFIEld> <reportElement x="85" y="0" wIDth="100" height="20"/> <textElement> </textElement> <textFIEldExpression ><![cdaTA[$F{countryname}]]></textFIEldExpression> </textFIEld> <elementGroup> <subreport isUsingCache="true"> <reportElement positionType="float" x="185" y="20" wIDth="446" height="74"/> <dataSourceExpression><![cdaTA[$F{cityDs}]]></dataSourceExpression> <subreportExpression ><![cdaTA[$P{subReportObject}]]></subreportExpression> </subreport> </elementGroup> </band> </detail> <columnFooter> <band height="20" splitType="Stretch"> <textFIEld> <reportElement x="531" y="0" wIDth="100" height="20"/> <textElement/> <textFIEldExpression ><![cdaTA[$V{countryname_1}]]></textFIEldExpression> </textFIEld> <staticText> <reportElement x="431" y="0" wIDth="100" height="20"/> <textElement textAlignment="JustifIEd"> </textElement> <text><![cdaTA[TOTAL Country : ]]></text> </staticText> </band> </columnFooter> <pageFooter> <band height="20" splitType="Stretch"> <staticText> <reportElement x="350" y="0" wIDth="100" height="20"/> <textElement> </textElement> <text><![cdaTA[Good luck!]]></text> </staticText> </band> </pageFooter></jasperReport>

mainreport_subreport2.jrxml (subreport)

Country.java (主表对象)

package com.test;import java.util.List;import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;public class Country { private int ID; private String countryname; private JRBeanCollectionDataSource cityDs; public Country() { // Todo auto-generated constructor stub } public Country(int ID,String countryname,JRBeanCollectionDataSource cityDs) { super(); this.ID = ID; this.countryname = countryname; this.cityDs = cityDs; } public int getID() { return ID; } public voID setID(int ID) { this.ID = ID; } public String getCountryname() { return countryname; } public voID setCountryname(String countryname) { this.countryname = countryname; } public JRBeanCollectionDataSource getCityDs() { return cityDs; } public voID setCityDs(JRBeanCollectionDataSource cityDs) { this.cityDs = cityDs; } }

City.java(从表对象)

package com.test;public class City { private int ID; private String cityname; public City() { // Todo auto-generated constructor stub } public City(int ID,String cityname) { super(); this.ID = ID; this.cityname = cityname; } public int getID() { return ID; } public voID setID(int ID) { this.ID = ID; } public String getCityname() { return cityname; } public voID setCityname(String cityname) { this.cityname = cityname; }}

TestSubReport.java (main方法)

package com.test;/* * jasper report v3.7.4 */import java.io.file;import java.util.ArrayList;import java.util.Calendar;import java.util.HashMap;import java.util.List;import java.util.Map;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JRExporter;import net.sf.jasperreports.engine.JRExporterParameter;import net.sf.jasperreports.engine.JasperCompileManager;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.JasperReport;import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;import net.sf.jasperreports.engine.design.JasperDesign;import net.sf.jasperreports.engine.export.JRpdfExporter;import net.sf.jasperreports.engine.export.JRXlsExporter;import net.sf.jasperreports.engine.xml.JRXmlLoader;public class TestSubReport { public TestSubReport() { // Todo auto-generated constructor stub } @SuppressWarnings("unchecked") public static voID main(String[] args) throws JRException { System.out.println("start"); //get *.jrxml JasperDesign jDesign = JRXmlLoader.load(new file("/test2/mainreport.jrxml")); JasperDesign jDesign2 = JRXmlLoader.load(new file("/test2/mainreport_subreport2.jrxml")); //export filename String filename = "subReport-on"+Calendar.getInstance().getTimeInMillis(); //get *.jasper JasperReport jReport = JasperCompileManager.compileReport(jDesign); JasperReport jReport2 = JasperCompileManager.compileReport(jDesign2); //fill data List data = new ArrayList(); List List1 = new ArrayList(); List1.add(new City(1,"suzhou")); List1.add(new City(2,"shanghai")); List1.add(new City(3,"beijing")); List List2 = new ArrayList(); List2.add(new City(4,"New York")); List2.add(new City(5,"San Francisco")); List List3 = new ArrayList(); List3.add(new City(6,"London")); List3.add(new City(7,"Nottinghamshire")); JRBeanCollectionDataSource ds1 = new JRBeanCollectionDataSource(List1); JRBeanCollectionDataSource ds2 = new JRBeanCollectionDataSource(List2); JRBeanCollectionDataSource ds3 = new JRBeanCollectionDataSource(List3); data.add(new Country(1,"China",ds1)); data.add(new Country(2,"USA",ds2)); data.add(new Country(3,"UK",ds3)); Map map = new HashMap(); map.put("subReportObject",jReport2);//subReport put here. JasperPrint jPrint = JasperFillManager.fillReport(jReport,map,new JRBeanCollectionDataSource(data)); //export with pdf JRExporter jExporter = new JRpdfExporter(); jExporter.setParameter(JRExporterParameter.OUTPUT_file_name,filename+".pdf"); jExporter.setParameter(JRExporterParameter.JASPER_PRINT,jPrint); jExporter.exportReport(); //export with xls JRXlsExporter jXlsExporter = new JRXlsExporter(); jXlsExporter.setParameter(JRExporterParameter.OUTPUT_file_name,filename+".xls"); jXlsExporter.setParameter(JRExporterParameter.JASPER_PRINT,jPrint); jXlsExporter.exportReport(); System.out.println(filename); System.out.println("end"); }}

总结：

其实subreport是和主表一起在后台被预编译，然后作为parameter 设置给主表，在主表的subreport标签中被引用，同时subreport的datasource同样是从主表的fIEld中传参过去。

总结

以上是内存溢出为你收集整理的JasperReports Subreport 实例全部内容，希望文章能够帮你解决JasperReports Subreport 实例所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

欢迎分享，转载请注明来源：内存溢出

原文地址: http://outofmemory.cn/langs/1270129.html