No data shown on subreport(Subreport using Java beans)

sabmoonie · July 3, 2015

Good day!

I'm new to Jaspersoft and all the articles I've read about using javabeans as datasource for reports with subreports are not working. The main report has data shown but the subreport is blank even if the datasource is not empty and/or AllSectionsNoDetail is selected.

I've tried passing the subreport data as param and as field. Both approaches didnt work. It would always say, "WARN JRJdbcQueryExecuter:129 - The supplied java.sql.Connection object is null."

I know these is TL;DR but for those who wants to share please answer.

Thanks guys!

POJO:

package com.cmsbeta.hibernate.domain;

import java.math.BigDecimal;

...

public class ChargeTypeAndEntries {

private Long id = CptiUtil.generatePrimaryKey();

private DateTime createDate;

private User createdBy;

private String code;

private String description;

private BigDecimal amount;

private Integer vatComputation;

private Integer status = 1;

private Integer isSpecial = 0;

private List<Entry> entries;

public Long getId() {

return id;

}

public void setId(Long id) {

this.id = id;

}

....

public List<Entry> getEntries() {

return entries;

}

public void setEntries(List<Entry> entries) {

this.entries = entries;

}

Report Filter:

package com.cmsbeta.web.function.reportfilter.page;

import java.util.ArrayList;

...

public class ChargeTypeListReportFilterPage extends CptiBasePage {

@SpringBean

private ChargeTypeService chargeTypeService;

@SpringBean

private EntryService entryService;

private String searchCode;

private String searchDescription;

private Boolean searchIncludeInactive;

public ChargeTypeListReportFilterPage() {

setPageTitle("report.title.chargetypelist");

TextField<String> code = new TextField<String>("code", new PropertyModel<String>(this, "searchCode"));

TextField<String> description = new TextField<String>("description", new PropertyModel<String>(this, "searchDescription"));

CheckBox includeInactive = new CheckBox("includeInactive", new PropertyModel<Boolean>(this, "searchIncludeInactive"));

Form<?> form = new Form<Void>("form");

form.add(new AttributeAppender("target", Model.of("_blank")));

SubmitLink submit = new SubmitLink("submit") {

@Override

public void onSubmit() {

List<ChargeType> chargeTypes = chargeTypeService.search(searchCode, searchDescription, null, searchIncludeInactive);

List<ChargeTypeAndEntries> data = new ArrayList<ChargeTypeAndEntries>();

for(ChargeType chargeType : chargeTypes){

ChargeTypeAndEntries cae = new ChargeTypeAndEntries();

cae.setId(chargeType.getId());

cae.setAmount(chargeType.getAmount());

cae.setCode(chargeType.getCode());

cae.setCreateDate(chargeType.getCreateDate());

cae.setCreatedBy(chargeType.getCreatedBy());

cae.setDescription(chargeType.getDescription());

cae.setIsSpecial(chargeType.getIsSpecial());

cae.setStatus(chargeType.getStatus());

cae.setVatComputation(chargeType.getVatComputation());

cae.setEntries(entryService.findBySource(CmsConstants.CHARGE_TYPE_SOURCE , chargeType.getId()));

data.add(cae);

}

Map<String, Object> param = new HashMap<String, Object>();

param.put("Title", getString("report.title.chargetypelist"));

List<KeyValuePair> subreportKvp = new ArrayList<KeyValuePair>();

subreportKvp.add(new KeyValuePair(0, "charge_type_entries.jrxml"));

try {

CmsUtil.showJasperReport(getRequestCycle(), data, "charge_type_list.jrxml", param, subreportKvp);

} catch (JRException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

};

add(form);

form.add(code);

form.add(description);

form.add(includeInactive);

form.add(submit);

}

Show report:

public static void showJasperReport(RequestCycle requestCycle, List<?> data, String jrxmlFileName, Map parameters, List<KeyValuePair> subreports) throws JRException {

JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(data);

CmsJasperReportsResource jr;

//Create an instance of JasperReport of the subreport then pass that instance to the main report as a parameter

if(parameters != null) {

putTitleSubreportInParam(parameters);

if(subreports != null) {

putSubreportsInParam(parameters, subreports);

}

} else {

parameters = new HashMap();

putTitleSubreportInParam(parameters);

}

InputStream jrxmlUrl = CmsJasperReportsResource.class.getResourceAsStream(jrxmlFileName);

JasperDesign jasperDesign = JRXmlLoader.load(jrxmlUrl);

JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign); //produces a .jasper file when compiled using ANT

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, beanColDataSource); //produces a jrprint file when compiled using ANT

jr = new CmsJasperReportsResource(jasperPrint);

requestCycle.scheduleRequestHandlerAfterCurrent(new ResourceRequestHandler(jr, null));

}

Main report:

<?xml version="1.0" encoding="UTF-8"?>

<![CDATA[]]>

</queryString>

<fieldDescription><![CDATA

]></fieldDescription>

</field>

</field>

</field>

</field>

</background>

<title>

</reportElement>

</subreportParameter>

</subreport>

</reportElement>

</textElement>

</textField>

</band>

</title>

</reportElement>

<box>

</box>

</textElement>

</textField>

</reportElement>

</textElement>

</textField>

</graphicElement>

</rectangle>

</reportElement>

<box>

</box>

</textElement>

</textField>

</band>

</columnHeader>

</reportElement>

</textField>

</reportElement>

</textField>

</reportElement>

</textField>

</subreport>

</band>

</detail>

</reportElement>

</textField>

</reportElement>

</line>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

Subreport:

<?xml version="1.0" encoding="UTF-8"?>

<![CDATA[]]>

</queryString>

</field>

</field>

</background>

</textElement>

</staticText>

</reportElement>

</textElement>

</staticText>

</textElement>

</staticText>

</band>

</columnHeader>

</textField>

</textField>

</band>

</detail>

</jasperReport>

sabmoonie · July 3, 2015

just kindly show me in detail how to use java beans as datasource. could be like one datasource per subreport. thanks a lot

sanbez · July 3, 2015

1. Question: (Subreport using java beans)
jrxml: <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> ???
I am don't see expression like 'new JRBeanCollecitionDataSource(collection)' for subreport.
2. Why subreport placed in title of main report? If you want display Entry in subreport then subreport must be placed in detail band whith dataSousrceExpression like new JRBeanCollectionDataSource($F{entries})

sabmoonie · July 4, 2015

Hi Sanbez!

Thanks for the reply.

I have two subreports. One is on the title. It contains the company name and logo. And I dont have any problem with it. The one on the Detail band is the one which is not shown.

</subreport>

sanbez · July 6, 2015

1. Insert static text in title band of Charge_Type_Entries_Report (subreport). Is it will displaing?
2. Show values $P{Logo} and $P{0}. You can display it in main report.

sabmoonie · July 10, 2015

Hi Sanbez!

No but i already found out the answer.

To use a list as subreport/table/list element datasource,

make sure to create a JRBeanCollectionDataSource first out of the list
add on parameters
on the report, select list
go to Dataset properties(Tab)
select Dont use any connection or Data Source
add Parameter (Name: REPORT_DATA_SOURCE and Expression: select the list data source param)

or if the list or set is already a part of the object used as the report's datasource,

on the report, select list
go to Dataset properties(Tab)
select Dont use any connection or Data Source
add Parameter (Name: REPORT_DATA_SOURCE and Expression: "new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource(param)")

hope this helps other jasper report users. ^^

Sign In

No data shown on subreport(Subreport using Java beans)

Recommended Posts

sabmoonie

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

sabmoonie

Link to comment

Share on other sites

sanbez

Link to comment

Share on other sites

sabmoonie

Link to comment

Share on other sites

sanbez

Link to comment

Share on other sites

sabmoonie

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore