Jackeline161

Hello everybody I have a problem with passing a list as a datasource for my report, the list has a type not primitif (g_listCla = new ArrayList<Cla>() )so I ask if it's possible to do it because it doesn't work for me :s There is the method that i use : public String ToPdfFormat() throws ColumnBuilderException, ClassNotFoundException { try { System.out.println("g_titre :"+titreEtat);System.out.println("g_listCla:"+g_listCla.size());FastReportBuilder drb = new FastReportBuilder();DynamicReport dr = drb.setTitle(titreEtat).setSubtitle("This report was generated at " + new Date()).setPrintBackgroundOnOddRows(true).setUseFullPageWidth(true).build(); // build JasperPrint instance, filling the report with data from datasource created above JasperPrint jasperPrint = DynamicJasperHelper.generateJasperPrint( dr,new ClassicLayoutManager(),g_listCla); // export to pdf JasperExportManager.exportReportToPdfFile(jasperPrint, "C:\MyReport1.pdf");} The list is already filled in the other method when my dynamic query is generated so i wish to pass the list directly to my report , please help me !!!!

Hello everybody I use the api Dynamic Jasper for generating my dynamic reports but i have a big problem, the code seems correct but it gives me a blank report it doesn't build anything, title columns data... The code that I use is like this : public String ToPdfFormat() throws ColumnBuilderException { try { DynamicReportBuilder dynamicReportBuilder = new DynamicReportBuilder(); // configure report-level settings dynamicReportBuilder.setReportName("Some").setTitle(g_titre); dynamicReportBuilder.setPageSizeAndOrientation(Page.Page_Letter_Landscape()); // add id column to report ColumnBuilder columnBuilderID = ColumnBuilder.getInstance(); columnBuilderID.setTitle("ID"); columnBuilderID.setWidth(180); columnBuilderID.setFixedWidth(true); columnBuilderID.setColumnProperty("ID", Integer.class.getName(), "@id"); dynamicReportBuilder.addColumn(columnBuilderID.build()); // add name column to report ColumnBuilder columnBuilderName = ColumnBuilder.getInstance(); columnBuilderName.setTitle("Name"); columnBuilderName.setWidth(180); columnBuilderName.setFixedWidth(true); columnBuilderName.setColumnProperty("Name", String.class.getName(), "@name"); dynamicReportBuilder.addColumn(columnBuilderName.build()); // add email column to report ColumnBuilder columnBuilderEmail = ColumnBuilder.getInstance(); columnBuilderEmail.setTitle("Email"); columnBuilderEmail.setWidth(180); columnBuilderEmail.setFixedWidth(true); columnBuilderEmail.setColumnProperty("Email", String.class.getName(), "@email"); dynamicReportBuilder.addColumn(columnBuilderEmail.build()); // add salary column to report ColumnBuilder columnBuilderSalary = ColumnBuilder.getInstance(); columnBuilderSalary.setTitle("Salary"); columnBuilderSalary.setWidth(180); columnBuilderSalary.setFixedWidth(true); columnBuilderSalary.setColumnProperty("Salary", Integer.class.getName(), "@salary"); dynamicReportBuilder.addColumn(columnBuilderSalary.build()); // build a datasource representing the XML file //Session session = sessionFactory.getCurrentSession();// List list = session.createQuery("select * from tab_clas_obj").list(); DynamicReport dynamicReport = new ReflectiveReportBuilder (g_listCla).build(); // build JasperPrint instance, filling the report with data from datasource created above JasperPrint jasperPrint = DynamicJasperHelper.generateJasperPrint( dynamicReport,new ClassicLayoutManager(),g_listCla); // export to pdf JasperExportManager.exportReportToPdfFile(jasperPrint, "C:\MyReport1.pdf"); }Please I need ur help !!

It works !! Thak youu very very much rsuddhala :)

It doesn't work , i think that the problem is from the order of tags but I don't know how to resolve it ..

Hello everybody , Please i have a problem with ireport designer, i want to edit my file xml in order to have a parameter with my sql query string, i have to pass the entiere query but it dosen't work . My jasper file is like this: <?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e50b86b1-ec0c-42dd-b31d-f2dedc5e3495"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="3"/><parameter name="dynamicQuery" class="java.lang.String"/> <querystring language="SQL"> <![CDATA[&P{dynamicQuery}]]> </querystring> <field class="java.lang.String" name="DUMMY"></field><variable name="titre" class="java.lang.String"/><background><band splitType="Stretch"/></background><title><band height="79" splitType="Stretch"><textField><reportElement uuid="bfdeca90-6237-40f6-9230-e63fb625786b" x="218" y="23" width="100" height="20"/><textElement/><textFieldExpression><![CDATA[$V{titre}]]></textFieldExpression></textField></band></title><pageHeader><band height="35" splitType="Stretch"><textField pattern="EEEEE dd MMMMM yyyy"><reportElement uuid="e5be40f6-b301-4c68-84ab-d64cf3f73e49" x="0" y="0" width="108" height="35"/><textElement/><textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression></textField></band></pageHeader><columnHeader><band height="61" splitType="Stretch"/></columnHeader><detail><band height="125" splitType="Stretch"/></detail><columnFooter><band height="45" splitType="Stretch"/></columnFooter><pageFooter><band height="54" splitType="Stretch"/></pageFooter><summary><band height="42" splitType="Stretch"><textField><reportElement uuid="33dac024-0bd8-4e6b-9849-4c74839ac0f1" x="438" y="42" width="117" height="20"/><textElement/><textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression></textField></band></summary></jasperReport>It gives me the bellow problem : Error loading the report template: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'querystring'. One of '{"http://jasperreports.sourceforge.net/jasperreports":parameter, "http://jasperreports.sourceforge.net/jasperreports":queryString, "http://jasperreports.sourceforge.net/jasperreports":field, "http://jasperreports.sourceforge.net/jasperreports":sortField, "http://jasperreports.sourceforge.net/jasperreports":variable, "http://jasperreports.sourceforge.net/jasperreports":filterExpression, "http://jasperreports.sourceforge.net/jasperreports":group, "http://jasperreports.sourceforge.net/jasperreports":background, "http://jasperreports.sourceforge.net/jasperreports":title, "http://jasperreports.sourceforge.net/jasperreports":pageHeader, "http://jasperreports.sourceforge.net/jasperreports":columnHeader, "http://jasperreports.sourceforge.net/jasperreports":detail, "http://jasperreports.sourceforge.net/jasperreports":columnFooter, "http://jasperreports.sourceforge.net/jasperreports":pageFooter, "http://jasperreports.sourceforge.net/jasperreports":lastPageFooter, "http://jasperreports.sourceforge.net/jasperreports":summary, "http://jasperreports.sourceforge.net/jasperreports":noData}' is expected. Please i need ur help !! Thank you very much