问题：
子报表中的多个图
居乐池
在主报表中打印子报表时。
我使用Jasper API创建主报告，并在主报告中添加编译好的子报告。主报告编译良好。但是图表是重复数据源中数据的数量。
如果数据源(我的数据源是JRBeanCollectionDataSource)有6个，那么它打印2组2个重叠的图形和下面的2个图形
我从报告类的组部分调用子报告来设计主报告
public class JasperDesignForTemplate {
public JasperDesign design() throws Exception {
// set basic design for main report
JasperDesign jasperDesign = new JasperDesign();
jasperDesign.setName("simpleReport");
jasperDesign.setPageWidth(595);
jasperDesign.setPageHeight(842);
jasperDesign.setColumnWidth(270);
jasperDesign.setColumnSpacing(15);
jasperDesign.setLeftMargin(20);
jasperDesign.setRightMargin(20);
jasperDesign.setTopMargin(30);
jasperDesign.setBottomMargin(30);
//Parameters
// field
JRDesignField bar = new JRDesignField();
bar.setName("bar");
bar.setValueClass(java.util.List.class);
jasperDesign.addField(bar);
JRDesignField time = new JRDesignField();
time.setName("time");
time.setValueClass(java.util.List.class);
jasperDesign.addField(time);
JRDesignBand band = new JRDesignBand();
//Group
JRDesignGroup group = new JRDesignGroup();
group.setName("Chart group");
band = new JRDesignBand();
band.setHeight(250);
band.setSplitType(SplitTypeEnum.STRETCH);
JRDesignSubreport jSubreport = new JRDesignSubreport(jasperDesign);
jSubreport.setUsingCache(false);
jSubreport.setRemoveLineWhenBlank(true);
jSubreport.setPrintRepeatedValues(false);
JRDesignExpression expression = new JRDesignExpression();
expression.setText("new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{time})");
jSubreport.setDataSourceExpression(expression);
expression = new JRDesignExpression();
expression.setText("\"/path/to/TimeSeriesChartSubReport.jasper\"");
jSubreport.setExpression(expression);
band.addElement(jSubreport);
((JRDesignSection)group.getGroupHeaderSection()).addBand(band);
jasperDesign.addGroup(group);
JRDesignGroup Chartgroup = new JRDesignGroup();
Chartgroup.setName("Chart group Chart");
JRDesignBand chartband = new JRDesignBand();
chartband.setHeight(250);
chartband.setSplitType(SplitTypeEnum.STRETCH);
JRDesignSubreport jSubreportChart = new JRDesignSubreport(jasperDesign);
jSubreportChart.setUsingCache(false);
jSubreportChart.setRemoveLineWhenBlank(true);
JRDesignExpression expressionChart = new JRDesignExpression();
expressionChart.setText("new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{bar})");
jSubreportChart.setDataSourceExpression(expressionChart);
expressionChart = new JRDesignExpression();
expressionChart.setText("\"/path/to/BarCharSubReport.jasper\"");
jSubreportChart.setExpression(expressionChart);
chartband.addElement(jSubreportChart);
((JRDesignSection)Chartgroup.getGroupHeaderSection()).addBand(chartband);
jasperDesign.addGroup(Chartgroup);
// title band
band = new JRDesignBand();
band.setHeight(20);
band.setSplitType(SplitTypeEnum.STRETCH);
JRDesignStaticText staticText = new JRDesignStaticText();
staticText.setX(0);
staticText.setY(0);
staticText.setHeight(20);
staticText.setWidth(550);
staticText.setText("Report Name");
staticText.setHorizontalAlignment(HorizontalAlignEnum.CENTER);
staticText.setFontSize(15);
band.addElement(staticText);
jasperDesign.setTitle(band);
// end of title band
// page header band
band = new JRDesignBand();
band.setHeight(50);
band.setSplitType(SplitTypeEnum.STRETCH);
jasperDesign.setPageHeader(band);
// end of page header band
// column header band
band = new JRDesignBand();
band.setHeight(50);
band.setSplitType(SplitTypeEnum.STRETCH);
jasperDesign.setColumnHeader(band);
// end of column header band
//detail band
band = new JRDesignBand();
band.setHeight(20);
((JRDesignSection) jasperDesign.getDetailSection()).addBand(band);
// end of detail band
// column footer band
band = new JRDesignBand();
band.setHeight(20);
jasperDesign.setColumnFooter(band);
// end of column footer band
// page footer band
band = new JRDesignBand();
band.setHeight(20);
jasperDesign.setPageFooter(band);
// end of page footer band
// summary band
band = new JRDesignBand();
band.setHeight(20);
jasperDesign.setSummary(band);
// end of summary band
return jasperDesign;
}
}
用于编译子报表和填充和生成 PDF 的类
public class DynamicJasper {
protected JasperPrint jp;
protected JasperReport jr;
protected Map params = new HashMap();
private static String inputjrxml = "/path/to/Report.jrxml";
private static String outputjasper = "/path/to/Report.jasper";
private static String pdffile = "/path/to/Report.pdf";
public static void main(String args[]) throws Exception{
String inputTimeSubreport = "/path/to/TimeSeriesChartSubReport.jrxml";
String outputTimeSubreport = "/path/to/TimeSeriesChartSubReport.jasper";
String inputBarSubreport = "/path/to/BarCharSubReport.jrxml";
String outputBarSubreport = "/path/to/BarCharSubReport.jasper";
JasperCompileManager.compileReportToFile(inputTimeSubreport, outputTimeSubreport);
JasperCompileManager.compileReportToFile(inputBarSubreport, outputBarSubreport);
JasperDesignForTemplate templace = new JasperDesignForTemplate();
JasperDesign design = templace.design();
Collection<JRValidationFault> faults = JasperCompileManager.verifyDesign(design);
JasperCompileManager.compileReportToFile(design, outputjasper);
HashMap<String, Object> params = new HashMap<String, Object>();
EventData data = new EventData();
JRBeanCollectionDataSource beanList = new JRBeanCollectionDataSource(data.getEventData());
JasperPrint jasperPrint = JasperFillManager.fillReport(outputjasper, params, beanList);
JasperExportManager.exportReportToPdfStream(jasperPrint, new FileOutputStream(pdffile));
}
}
列出数据提供程序 Beans
public class EventBean {
private String field;
private String count;
private String pastcount;
private List<TimeSeriesBean> time = new ArrayList<TimeSeriesBean>();
public EventBean(){
}
public EventBean(String name, String count, String pastCount, List<TimeSeriesBean> time){
this.field = name;
this.count = count;
this.time = time;
this.pastcount = pastCount;
}
public String getField() {
return field;
}
public void setName(String name) {
this.field = name;
}
public String getCount() {
return count;
}
public void setCount(String count) {
this.count = count;
}
public List<TimeSeriesBean> getTime() {
return time;
}
public void setTime(List<TimeSeriesBean> time) {
this.time = time;
}
public void setField(String field) {
this.field = field;
}
public String getPastcount() {
return pastcount;
}
public void setPastcount(String pastcount) {
this.pastcount = pastcount;
}
}
public class TimeSeriesBean {
private String count;
private String timeStamp;
public TimeSeriesBean(String count, String timeStamp) {
this.count = count;
this.timeStamp = timeStamp;
}
public TimeSeriesBean() {
}
public String getCount() {
return count;
}
public void setCount(String count) {
this.count = count;
}
public String getTimeStamp() {
return timeStamp;
}
public void setTimeStamp(String timeStamp) {
this.timeStamp = timeStamp;
}
}
public class EventData {
private List<EventBean> bar;
private List<TimeSeriesBean> time;
public List<EventBean> getBar() {
return bar;
}
public void setBar(List<EventBean> bar) {
this.bar = bar;
}
public List<TimeSeriesBean> getTime() {
return time;
}
public void setTime(List<TimeSeriesBean> time) {
this.time = time;
}
public List<EventData> getEventData(){
ArrayList<EventData> dataArr = new ArrayList<EventData>();
EventData data = new EventData();
EventNameList dataList = new EventNameList();
data.setBar(dataList.getDataBeanList());
data.setTime(dataList.getSingleDataBeanList().get(0).getTime());
dataArr.add(data);
return dataArr;
}
}
public class EventNameList {
public ArrayList<EventBean> getSingleDataBeanList() {
ArrayList<EventBean> list = new ArrayList<EventBean>();
ArrayList<TimeSeriesBean> listTime = new ArrayList<TimeSeriesBean>();
TimeSeriesBean tbean = new TimeSeriesBean("413","1375951800");
TimeSeriesBean tbean1 = new TimeSeriesBean("425","1375952100");
TimeSeriesBean tbean2 = new TimeSeriesBean("396","1375952820");
TimeSeriesBean tbean3 = new TimeSeriesBean("400","1375953540");
TimeSeriesBean tbean4 = new TimeSeriesBean("200","1375953440");
TimeSeriesBean tbean5 = new TimeSeriesBean("1400","1375953999");
listTime.add(tbean);
listTime.add(tbean1);
listTime.add(tbean2);
listTime.add(tbean3);
listTime.add(tbean4);
listTime.add(tbean5);
list.add(generate("Flow", "100", "800", listTime));
return list;
}
public ArrayList<EventBean> getDataBeanList() {
ArrayList<EventBean> list = new ArrayList<EventBean>();
ArrayList<TimeSeriesBean> listTime = new ArrayList<TimeSeriesBean>();
TimeSeriesBean tbean = new TimeSeriesBean("413","1375951800");
TimeSeriesBean tbean1 = new TimeSeriesBean("425","1375952100");
TimeSeriesBean tbean2 = new TimeSeriesBean("396","1375952820");
TimeSeriesBean tbean3 = new TimeSeriesBean("400","1375953540");
TimeSeriesBean tbean4 = new TimeSeriesBean("400","1375953440");
TimeSeriesBean tbean5 = new TimeSeriesBean("400","1375953999");
listTime.add(tbean);
listTime.add(tbean1);
listTime.add(tbean2);
listTime.add(tbean3);
listTime.add(tbean4);
listTime.add(tbean5);
list.add(generate("Flow", "100", "800", null));
list.add(generate("Non flow", "200", "50", null));
list.add(generate("Allow", "600", "400", null));
list.add(generate("Deny", "50", "200", null));
list.add(generate("Block", "150", "1200", null));
list.add(generate("Access", "10", "0", null));
return list;
}
private EventBean generate(String name, String country, String pastCount, List<TimeSeriesBean> time) {
EventBean bean = new EventBean();
bean.setName(name);
bean.setCount(country);
bean.setPastcount(pastCount);
bean.setTime(time);
return bean;
}
}
子报表 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="ProductReport" columnCount="2" pageWidth="325" pageHeight="842" whenNoDataType="NoDataSection" columnWidth="160" columnSpacing="5" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
<field name="count" class="java.lang.String"/>
<field name="timeStamp" class="java.lang.String"/>
<group name="TimeSeriesGroup">
<groupExpression><![CDATA[$F{count}]]></groupExpression>
<groupHeader>
<band height="250">
<timeSeriesChart>
<chart evaluationTime="Report">
<reportElement x="0" y="25" width="550" height="175"/>
<chartTitle/>
<chartSubtitle/>
<chartLegend/>
</chart>
<timeSeriesDataset timePeriod="Minute">
<dataset incrementType="None"/>
<timeSeries>
<seriesExpression><![CDATA["Count"]]></seriesExpression>
<timePeriodExpression><![CDATA[new Date(Long.valueOf($F{timeStamp})*1000)]]></timePeriodExpression>
<valueExpression><![CDATA[Integer.valueOf($F{count})]]></valueExpression>
</timeSeries>
</timeSeriesDataset>
<timeSeriesPlot isShowLines="true" isShowShapes="false">
<plot/>
<timeAxisFormat>
<axisFormat>
<labelFont/>
<tickLabelFont/>
</axisFormat>
</timeAxisFormat>
<valueAxisFormat>
<axisFormat>
<labelFont/>
<tickLabelFont/>
</axisFormat>
</valueAxisFormat>
</timeSeriesPlot>
</timeSeriesChart>
</band>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
</jasperReport>
条形图的子报告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="ProductReport" columnCount="2" pageWidth="325" pageHeight="842" whenNoDataType="NoDataSection" columnWidth="160" columnSpacing="5" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
<field name="count" class="java.lang.String"/>
<field name="field" class="java.lang.String"/>
<field name="pastcount" class="java.lang.String"/>
<group name="BarChartGroup">
<groupExpression><![CDATA[$F{count}]]></groupExpression>
<groupHeader>
<band height="250">
<bar3DChart>
<chart evaluationTime="Report">
<reportElement x="0" y="0" width="555" height="233" isRemoveLineWhenBlank="true"/>
<chartTitle/>
<chartSubtitle/>
<chartLegend position="Right"/>
</chart>
<categoryDataset>
<dataset incrementType="None"/>
<categorySeries>
<seriesExpression><![CDATA["This month"]]></seriesExpression>
<categoryExpression><![CDATA[$F{field}]]></categoryExpression>
<valueExpression><![CDATA[Integer.valueOf($F{count})]]></valueExpression>
</categorySeries>
<categorySeries>
<seriesExpression><![CDATA["Last month"]]></seriesExpression>
<categoryExpression><![CDATA[$F{field}]]></categoryExpression>
<valueExpression><![CDATA[Integer.valueOf($F{pastcount})]]></valueExpression>
</categorySeries>
</categoryDataset>
<bar3DPlot>
<plot/>
<itemLabel/>
<categoryAxisFormat>
<axisFormat/>
</categoryAxisFormat>
<valueAxisFormat>
<axisFormat/>
</valueAxisFormat>
</bar3DPlot>
</bar3DChart>
</band>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
</jasperReport>
共有1个答案
廉高邈
从中删除组表达式$F{Count}
<groupExpression><![CDATA[$F{count}]]></groupExpression>
如果这不起作用，则从主报表和子报表中删除整个组表达式行。
类似资料：
-
我目前的技能只能通过使用JRBeanCollectionDataSource（list）作为数据源，在不使用子报表的情况下制作pdf。（数据打印成功） 谁能告诉我如何制作包含多个子报表的pdf报表，主jrxml文件和子报表jrxml文件中应该包含哪些内容，以及java代码中应该包含哪些内容？以及如何使用多个JRBeanCollectionDataSource（列表）？我唯一知道的是使用Map pa
-
我有一个主报告和两个子报告。我正在使用自定义数据源来获取报表内容。但是在jasper studio中预览主报表时，只显示一个子报表（无论哪个子报表先出现）。 为（如）。只显示report1.jrxml，如果删除子报表，则显示report2.jrxml。 我已经试用了以下方法： 将子报告放置在不同的详细信息带中。 将“位置类型”设置为“浮动”。 将“运行到底部”属性设置为“true”。
-
我可以为我的Java项目的一个报告提供多个子报告吗？ 我有一个生成主报表的类，根据用户选择的报表，子报表将在主报表中生成。但是我在Java类上这样做，在iReport上我只放参数。因此，我只有一个主报表和许多子报表，这些报表将根据用户的选择而插入。这可能吗？
-
我正在尝试使用带有子报表的主报表，而这个也带有子报表。我有一个Object列表，我将其作为JAVA的参数传递。当我打印Jasper时，只打印列表中的第一项，我不知道为什么（如果我只使用Master和一个子报表，它将打印所有对象并正确显示所有数据）。 代码是：JAVA（最相关的部分） JRXML大师 子报告 子子报表 请忽略jrxml的简单设计，我只是删除了不相关的信息。知道吗？
-
在主报表的细节部分，我创建了两个非常相同的子报表。我在主报表上指定了这两个子报表的高度为300像素，因此它们占据相等的空间，并在设计中一个接一个地显示为两个框。 子报表的设计如下所示。它的高度保持在300px。详细信息带根据从数据库返回的行数进行迭代。这可能返回3到8行。 现在，我希望在预览子报表时，如下图所示逐个显示子报表，其间没有任何空白。现在，当第一行只返回3行时，我看到它们之间有空白。如何
-
我已经创建了一个Jasper报告，我正试图将报告集成到主报告中。我可以按原样填充子报表中的数据，但如果我将其集成到主报表中，我就不能呈现我在子报表中呈现的数据。事实上，我在集成子报表的地方得到了空白。