Store procedure.? ResultSet

[muneer]

 Can i call Storeprocedure in iReport 3.0.0 ??

 

also can i pass ResultSet to iReport....?

 

 

[yo1832]

//Recorset from data base ( select * from anuncios ) return list of object anuncio

List listaAnunciosP = this.fachada.obtenerAnunciosPorEstadoParaImpresion(anuncioBean, busqueda);
  
   
    reportFile = new File(getServlet().getServletContext().getRealPath("//WEB-INF//classes//reportes  //busquedaAnunciosImpresionBoletin.jasper"));

    parametros.put("anyo", formulario.getAnyo());
  
   
    listaObjetosReportar = listaAnunciosP;    //list object

    JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile.getPath());
    JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parametros, new JRBeanCollectionDataSource(listaObjetosReportar));
 

[muneer]

would you explain it?

i am new in IReport i make a report and call in java, my code is under 

Code:

Post Edited by Muneer Ahmed at 03/06/09 10:29

Post Edited by Muneer Ahmed at 03/06/09 10:30

[yo1832]

the report you can make with ireport that a grapical jasper report designer.

you can find google tutorial of this program.

 

When you have a report create, you can call this with my lines.

i don`t know  who create report in code.

My lines pass a list of object anuncios from the database to report.

 

 

[muneer]

 thanks

[muneer]

 can you give "/busquedaAnunciosImpresionBoletin.jasper"" source OR any other; which help me to understand.

[yo1832]

this is a complete jasper report, create with ireport 3.0

Have more parameter and variables than i put you in the sample

[yo1832]

open *.jrxml with ireport, compile and you obtain the jasper.