Data source for subreport

[mackensen]

Hello,

I have a web application with a main report that is ok. All the data comes from the servlet (including datasource) so there' s no SQL query or database connection in the main report.

In the main report there is one subreport (or even two). How can I connect this subreport to a datasource (the same db connection as for the main report) and use some SQL query the same way as for the main report, I mean without SQL code inside the subreport ? The subreport should receive the id field from the main report as a parameter (for every record of the main report there are some records for the subreport).

Thanx,

mackensen

 

[luv2eat]

i face the same problem as you. i read that JRResultSetDataSource cannot handle this kind of problem.

i also posted my question in this forum but are not getting any replies. i'm looking into using javabean as a custom datasource to pass the data. if you have better suggestion please do share it with the rest of us.

[mackensen]

I can now display the main report and subreport, both with datasource supplied from java code but I cannot "connect" the records of main report with those of the subreport, I mean all the records of the subreport come out as soon as the first record of the main record is displayed, instead of having some records of subreport for every record of main report.

So, in the main report and subreport designed with iReport there is no SQL code; the main report has two parameters ("subReport" - type net.sf.jasperreports.engine.JasperReport and "datasource" - type net.sf.jasperreports.engine.data.JRBeanCollectionDataSource).

The main code is:

//for the main report 

parameters_header=generadatipdf.creaMapHeader(request);
dataSource = generadatipdf.createReportDataSource(request, response);
ServletContext context = this.getServletConfig().getServletContext();
File reportFileSubRep = new File(context.getRealPath("/reports/subreport.jasper"));

JasperReport  jasperReportSubRep=null;
jasperReportSubRep = (JasperReport)JRLoader.loadObject(reportFileSubRep.getPath());
 

//for the subreport                                   
dataSourceSubrep=(Collection) generadatipdf.createSubReportDataSource(request, response);     
                                     

//the parameters for the main report

parameters_header.put("subReport", jasperReportSubRep);
parameters_header.put("datasource", new JRBeanCollectionDataSource(dataSourceSubrep));
 

jasperDesign = JRXmlLoader.load(reportFile);

 jasperReport = JasperCompileManager.compileReport(jasperDesign);

...........

 

The problem now is how to "connect" the main report with the subreport. If somebody knows.....

See you,

Mackensen

[mackensen]

I did it !!

I added a parameter to the main report:

parameters_header.put("connection", conn.getConnection());

Then I set this as the connection for the subreport.

Then I wrote the query in the subreport:

It's the only way I found.

See you,

M