No data shown on subreport(Subreport using Java beans)

Posted on July 3, 2015 at 3:17am

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>

</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>

Jaspersoft® Studio

sabmoonie

Joined: Jul 3 2015 - 3:02am

Last seen: 5 years 1 week ago

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

sabmoonie - 8 years 2 months ago

add comment

4 Answers:

Posted on July 3, 2015 at 6:11am

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})

sanbez

7132

Joined: Jan 11 2011 - 2:06am

Last seen: 2 years 11 months ago

Posted on July 4, 2015 at 5:11am

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>

sabmoonie

Joined: Jul 3 2015 - 3:02am

Last seen: 5 years 1 week ago

Posted on July 6, 2015 at 12:48am

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.

sanbez

7132

Joined: Jan 11 2011 - 2:06am

Last seen: 2 years 11 months ago

Posted on July 10, 2015 at 2:34am

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. ^^

sabmoonie

Joined: Jul 3 2015 - 3:02am

Last seen: 5 years 1 week ago

Main menu

No data shown on subreport(Subreport using Java beans)

4 Answers:

Tags

Main menu

You are here

No data shown on subreport(Subreport using Java beans)

4 Answers:

Tags