JasperReports 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" class="net.sf.jasperreports.engine.JasperReport" isForPrompting="false"/> <field name="countryName" class="java.lang.String"/> <field name="cityDs" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource"/> <variable name="countryName_1" class="java.lang.Integer" 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"> <font size="24"/> </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> <font isBold="true"/> </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> <font isItalic="true"/> </textElement> <textFieldExpression class="java.lang.String"><![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 class="net.sf.jasperreports.engine.JasperReport"><![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 class="java.lang.Integer"><![CDATA[$V{countryName_1}]]></textFieldExpression> </textField> <staticText> <reportElement x="431" y="0" width="100" height="20"/> <textElement textAlignment="Justified"> <font isBold="true"/> </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> <font isItalic="true"/> </textElement> <text><![CDATA[Good luck!]]></text> </staticText> </band> </pageFooter> </jasperReport>

?

mainreport_subreport2.jrxml (subreport)

<?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_subreport2" language="groovy" pageWidth="802" pageHeight="555" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <field name="cityName" class="java.lang.String"/> <detail> <band height="20" splitType="Stretch"> <textField> <reportElement x="97" y="0" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{cityName}]]></textFieldExpression> </textField> </band> </detail> </jasperReport>

?

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中传参过去。?