How to pass ArrayList to JasperReports?

Question

I am new to JasperReports . I want to pass an ArrayList to a subreport.

I have a main report that contains one subreport1, and this subreport1 encapsulates one
subreport2 inside.

Now how to pass arrayList to subreport2?

Like MasterReport -> SubReport -> SubReport

Note I am using iReport to create a jasper template and pass the datalist to jasper from my Java DAO class.

Below is my form bean Class

 public class CollatReportData extends BaseItem { private List<CusipData> listCusipData = null; private String dealerID = null; private String tripID = null; private String loanNo = null; private String dealerName = null; private String tripDealerLoan = null; public CollatReportData() { super(); } public List<CusipData> getListCusipData() { return listCusipData; } public void setListCusipData(List<CusipData> listCusipData) { this.listCusipData = listCusipData; } public String getDealerID() { return dealerID; } public void setDealerID(String dealerID) { this.dealerID = dealerID; } public String getTripID() { return tripID; } public void setTripID(String tripID) { this.tripID = tripID; } } // and so on for other variables.. 

My DAO java class is below

 public List<Object> getCollatData(String custName, String ctripid, String dealerid, String userID) { final Connection conn = super.getCurrentConnection(); String sqlQueryTrip = null; ResultSet rsCollat = null; String tripID = null; String dealerID = null; String cusSysID = null; String loanNo = null; String txnNo = null; String cusipNo = null; String cusipStatus = null; String parVal = null; String tripDealerLoan = null; String OldtripDealerLoan = ""; String NewtripDealerLoan = ""; CollatReportData reportData = null; CusipData cusipData = null; List listCusip = new ArrayList<Object>(); List CollatList = new ArrayList<Object>(); try { PreparedStatement pstmtTrip; sqlQueryTrip = "SELECT iscl_sys_id, iscl_trip_id, iscl_trip_dealer_id, " + "iscl_cus_sys_id, iscl_bankref_cd, iscl_bdas_db_cd, " + "iscl_loan_no, iscl_txn_no, iscl_cusip_no, iscl_status_cd, " + "iscl_sec_de_tx, iscl_par_val_am, iscl_market_val_am, " + "scl_pri_source_cd, iscl_colla_mar_val_am, iscl_mature_dt, " + "iscl_sec_ty, iscl_sec_rt, iscl_sec_price_am, iscl_sec_factor, " + "iscl_sec_margin, iscl_sec_accrued_am " + "FROM BDS_DBA.INVCONF_SHELL_COLLAT " + "WHERE iscl_cus_sys_id='" + custName + "'"; pstmtTrip = conn.prepareStatement(sqlQueryTrip); rsCollat = pstmtTrip.executeQuery(); if (rsCollat != null) { while (rsCollat.next()) { tripID = rsCollat.getString("iscl_trip_id"); dealerID = rsCollat.getString("iscl_trip_dealer_id"); loanNo = rsCollat.getString("iscl_loan_no"); tripDealerLoan = tripID + dealerID + loanNo; cusipData = new CusipData(); cusipData.setTripID(tripID); cusipData.setCusipNo(cusipNo); cusipData.setTripDealerLoan(tripDealerLoan); listCusip.add(cusipData); } // end rsCollat } // end if CusipData cusipData1 = new CusipData(); List CusipList = new ArrayList<Object>(); for (int io = 0; io < listCusip.size(); io++) { cusipData1 = (CusipData) listCusip.get(io); NewtripDealerLoan = cusipData1.getTripDealerLoan(); tripID = cusipData1.getTripID(); dealerID = cusipData1.getDealerID(); loanNo = cusipData1.getLoanNo(); if (NewtripDealerLoan.equalsIgnoreCase(OldtripDealerLoan) || OldtripDealerLoan.equalsIgnoreCase("")) { CusipList.add(cusipData1); } if (!NewtripDealerLoan.equalsIgnoreCase(OldtripDealerLoan)) { reportData = new CollatReportData(); reportData.setTripID(tripID); reportData.setTripDealerLoan(NewtripDealerLoan); reportData.setListCusipData(CusipList); //and so on //........ CollatList.add(reportData); CusipList = null; } OldtripDealerLoan = NewtripDealerLoan; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("Inside LoanDetailDAO:strTripQuery:Exception" + sqlQueryTrip + e); } return CollatList; } 

the above DAO class returns List and passes this ArrayList template to Jasper via Hashmap Param.

Below is a sample wizard template template, from here I pass an ArrayList to subReport, for example

  <parameter name="list" isForPrompting="false" class="java.util.List"/> <detail> <band height="100" isSplitAllowed="true" > <subreport isUsingCache="true"> <reportElement x="30" y="20" width="170" height="40" key="subreport-1"/> <dataSourceExpression><![CDATA[new JRBeanCollectionDataSource( $P{list})]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "Collateral_SubReport1.jasper"]]></subreportExpression> </subreport> </band> </detail> 

where $p{list} is an ArrayList . and use this list to print in subReport1 asusual

while running the code, I get the following error:

Error retrieving field value from bean : tripID

Thanks for your help in advance.

Answer 1

This is done by passing the collection data source: new BeanCollectionDataSource(yourArrayList);

And then to get the JasperPrint object:

 JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, params, dataSource); 

To go to the subtitle, you have two options:

• If this is a subreporter per line, just assign the array as a bean property. That is, List<Something> where Something has a property of type List<AnotherThing>
• If this is one for the entire report, pass it as a parameter ( params above).

Answer 2

Step: 1 Define the field, for example, the field name = "listCusipData" and class = "java.util.ArrayList"

Step: 2 use this expression inside your auxiliary dataSourceExpression report
new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource ($ F {listCusipData}, false)

Answer 3

You can do this with lists and / or subscriptions, data sources, and JRBeanCollectionDatasource.

Check out this example:

http://siempredesdeelcurro.blogspot.com.es/2013/06/jasper-reports-crear-report-utilizando.html

It is in Spanish, but by your name, I think you can read it;)

For non-trainers, you can still use it, since at the end of the tutorial you can find XML using jrxml templates.