Greetings admin. I am experiencing some problems with implementing dynamicJasper when it comes to subreports. I am trying to create multiple tables into one report using subreport. However I can't figure it out. I keep getting errors. One of the errors I got recently is
Error: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :
Source text : new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource((java.util.Collection)$P{REPORT_PARAMETERS_MAP}.get( "cs" ) )
I alsotried following your how to instructions but I can't seem to figure it out.
Note: I get my Collections/data from 2 tables in my controller class which I use to populate the content of my tables. Please help. Thank you in advance.
This is my report class:
public class CustomersReportPrintReport {
private final Collection<SalesData> customerlist = new ArrayList<>();
private final Collection<SalesData> loanlist = new ArrayList<>();
private final String fromDate;
private final String toDate;
SalesData salesData = new SalesData();
HashMap params = new HashMap();
JRBeanCollectionDataSource ds1 = new JRBeanCollectionDataSource(customerlist);
JRBeanCollectionDataSource ds2 = new JRBeanCollectionDataSource(loanlist);
public CustomersReportPrintReport(Collection<SalesData> customerList, Collection<SalesData> loanList, LocalDate fromDate, LocalDate toDate) {
//change date format
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("MMMM dd, yyyy");
String fromDateString = dtf.format(fromDate);
String toDateString = dtf.format(toDate);
//assign variables
this.customerlist.addAll(customerList);
this.loanlist.addAll(loanList);
this.fromDate = fromDateString;
this.toDate = toDateString;
}
public JasperPrint getReport() throws ColumnBuilderException, JRException, ClassNotFoundException, Exception {
Style headerStyle = createHeaderStyle();
Style detailTextStyle = createDetailTextStyle();
Style detailNumberStyle = createDetailNumberStyle();
DynamicReport dynaReport = getReport(headerStyle, detailTextStyle,detailNumberStyle);
//DynamicReport dynaReport2 = createHeaderSubreport(headerStyle, detailTextStyle,detailNumberStyle);
//JasperPrint jp = DynamicJasperHelper.generateJasperPrint(dynaReport, new ClassicLayoutManager(), new JRBeanCollectionDataSource(customerlist));
JasperReport jr = DynamicJasperHelper.generateJasperReport(dynaReport, new ClassicLayoutManager(), params, "cs");
JasperPrint jp = JasperFillManager.fillReport(jr, params, ds1);
return jp;
}
private Style createHeaderStyle() {
StyleBuilder sb=new StyleBuilder(true);
sb.setFont(Font.VERDANA_MEDIUM_BOLD);
sb.setBorder(Border.THIN());
sb.setBorderBottom(Border.PEN_2_POINT());
sb.setBorderColor(Color.BLACK);
sb.setBackgroundColor(Color.decode("#007cff"));
sb.setTextColor(Color.WHITE);
sb.setHorizontalAlign(HorizontalAlign.CENTER);
sb.setVerticalAlign(VerticalAlign.MIDDLE);
sb.setTransparency(Transparency.OPAQUE);
return sb.build();
}
private Style createDetailTextStyle(){
StyleBuilder sb=new StyleBuilder(true);
sb.setFont(Font.VERDANA_MEDIUM);
sb.setBorder(Border.DOTTED());
sb.setBorderColor(Color.BLACK);
sb.setTextColor(Color.BLACK);
sb.setHorizontalAlign(HorizontalAlign.LEFT);
sb.setVerticalAlign(VerticalAlign.MIDDLE);
sb.setPaddingLeft(5);
return sb.build();
}
private Style createDetailNumberStyle(){
StyleBuilder sb=new StyleBuilder(true);
sb.setFont(Font.VERDANA_MEDIUM);
sb.setBorder(Border.DOTTED());
sb.setBorderColor(Color.BLACK);
sb.setTextColor(Color.BLACK);
sb.setHorizontalAlign(HorizontalAlign.RIGHT);
sb.setVerticalAlign(VerticalAlign.MIDDLE);
sb.setPattern("#,##0.00");
sb.setPaddingRight(5);
return sb.build();
}
private AbstractColumn createColumn(String property, Class type,
String title, int width, Style headerStyle, Style detailStyle)
throws ColumnBuilderException {
AbstractColumn columnState = ColumnBuilder.getNew()
.setColumnProperty(property, type.getName()).setTitle(
title).setWidth(Integer.valueOf(width))
.setStyle(detailStyle).setHeaderStyle(headerStyle).build();
return columnState;
}
private DynamicReport getReport(Style headerStyle, Style detailTextStyle, Style detailNumStyle) throws ColumnBuilderException, ClassNotFoundException, Exception {
DynamicReportBuilder report=new DynamicReportBuilder();
//make sure column name (1st parameter) is the same with variables from model classes
StyleBuilder titleStyle=new StyleBuilder(true);
titleStyle.setHorizontalAlign(HorizontalAlign.CENTER);
titleStyle.setFont(new Font(20, Font._FONT_GEORGIA, true));
StyleBuilder subTitleStyle=new StyleBuilder(true);
subTitleStyle.setHorizontalAlign(HorizontalAlign.CENTER);
subTitleStyle.setFont(new Font(Font.MEDIUM, Font._FONT_GEORGIA, true));
//set header
report.setTitle("Customer Sales Details Report");
report.setTitleStyle(titleStyle.build());
report.setSubtitle("(" + fromDate + " - " + toDate + ")");
report.setSubtitleStyle(subTitleStyle.build());
report.setUseFullPageWidth(true);
//set page number
report.addAutoText(AutoText.AUTOTEXT_PAGE_X_SLASH_Y, AutoText.POSITION_FOOTER, AutoText.ALIGNMENT_RIGHT);
//set created on date
//report.addAutoText(AutoText.AUTOTEXT_CREATED_ON, AutoText.POSITION_FOOTER, AutoText.ALIGNMENT_LEFT,AutoText.PATTERN_DATE_DATE_TIME);
report.addAutoText("Created on " + getDateTime(), AutoText.POSITION_FOOTER, AutoText.ALIGMENT_LEFT, 250);
//page orientation
report.setPageSizeAndOrientation(Page.Page_A4_Landscape());
report.addConcatenatedReport(createSubreport1(headerStyle, detailTextStyle, detailNumStyle), new ClassicLayoutManager(), "cs",
DJConstants.DATA_SOURCE_ORIGIN_PARAMETER, DJConstants.DATA_SOURCE_TYPE_COLLECTION,false);
report.addConcatenatedReport(createSubreport2(headerStyle, detailTextStyle, detailNumStyle), "ll",
DJConstants.DATA_SOURCE_ORIGIN_PARAMETER, DJConstants.DATA_SOURCE_TYPE_COLLECTION,true);
params.put("cs", ds1);
params.put("ll", ds2);
return report.build();
}
private DynamicReport createSubreport1(Style headerStyle, Style detailTextStyle, Style detailNumStyle) throws Exception {
DynamicReportBuilder report=new DynamicReportBuilder();
//make sure column name (1st parameter) is the same with variables from model classes
AbstractColumn columnDate = createColumn("date", String.class,"Date of Orders", 30, headerStyle, detailTextStyle);
AbstractColumn columnInventName = createColumn("inventName", String.class,"Product Ordered", 30, headerStyle, detailTextStyle);
AbstractColumn columnQuantity = createColumn("quantity", Integer.class,"Quantity", 30, headerStyle, detailNumStyle);
AbstractColumn columnAmountPaid = createColumn("amountPaid", Double.class,"Amount Paid", 30, headerStyle, detailNumStyle);
report.addColumn(columnDate)
.addColumn(columnInventName)
.addColumn(columnQuantity)
.addColumn(columnAmountPaid);
report.setUseFullPageWidth(true);
report.setWhenNoDataNoPages();
report.setTitle("Sub Report 1");
return report.build();
}
private JasperReport createSubreport2(Style headerStyle, Style detailTextStyle, Style detailNumStyle) throws Exception {
DynamicReportBuilder report=new DynamicReportBuilder();
DynamicReport dr;
//make sure column name (1st parameter) is the same with variables from model classes
AbstractColumn columnDate = createColumn("date", String.class,"Date", 30, headerStyle, detailTextStyle);
AbstractColumn columnPrice = createColumn("price", Double.class,"Outstanding Balance", 30, headerStyle, detailNumStyle);
report.addColumn(columnDate)
.addColumn(columnPrice);
report.setUseFullPageWidth(true);
report.setWhenNoDataNoPages();
report.setTitle("Sub Report 1");
dr = report.build();
return DynamicJasperHelper.generateJasperReport(dr, new ClassicLayoutManager(), null);
}
private String getYear() {
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy");
LocalDateTime now = LocalDateTime.now();
String date = dtf.format(now);
return date;
}
private String getMonth() {
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("MMMM");
LocalDateTime now = LocalDateTime.now();
String date = dtf.format(now);
return date;
}
private String getDateTime() {
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("EEEE MMMM dd, yyyy (hh:mm)");
LocalDateTime now = LocalDateTime.now();
String date = dtf.format(now);
return date;
}
}
Greetings admin. I am experiencing some problems with implementing dynamicJasper when it comes to subreports. I am trying to create multiple tables into one report using subreport. However I can't figure it out. I keep getting errors. One of the errors I got recently is
I alsotried following your how to instructions but I can't seem to figure it out.
Note: I get my Collections/data from 2 tables in my controller class which I use to populate the content of my tables. Please help. Thank you in advance.
This is my report class:
This is my controller class: