I have an requirement where my datasource contains lists of list,that is, i have created a list containing 3 lists. And each list values must be listed in 3 different sheets(there are about 9000+ records in each list). All the three sheets make use the same jrxml file. Is there a way that i can pass my datasource to JasperFillManager and it creates 3 sheets in one call.
I am presently, iterating the list and calling JasperFillManagert to create 3 JasperPrint Objects. And then merging them into in one report by setting the JRExporterParameter.JASPER_PRINT_LIST parameter.This is taking a lot of memory, and in some instances goes out of memory. I need to avoid creating three jasperprint objects and the filling has to be done in one call so that i have only one jasper print object to export.