Jackeline161
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by Jackeline161
-
-
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 settingsdynamicReportBuilder.setReportName("Some").setTitle(g_titre);dynamicReportBuilder.setPageSizeAndOrientation(Page.Page_Letter_Landscape());// add id column to reportColumnBuilder 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 reportColumnBuilder 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 reportColumnBuilder 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 reportColumnBuilder 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 aboveJasperPrint jasperPrint = DynamicJasperHelper.generateJasperPrint(dynamicReport,new ClassicLayoutManager(),g_listCla);// export to pdfJasperExportManager.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
Passing a generated list as a datasource
in Products
Posted
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 :
}
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 !!!!