fruchtiger

@robccsilva : thanks for your answer. I dont actually use a sql-query in the report-design file. I implemented the JRDataSource Interface, with the methods next() and getFieldValue() to fill the report. But before the filling, I need to check for paramaters within my java-code. Any ideas ? My implementation looks somehting like this : Code:import java.util.Vector;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JRField;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;public class MyDataSource implements net.sf.jasperreports.engine.JRDataSource { private Object[][] data = { {"Berne", new Integer(22), "Bill Ott", "250 - 20th Ave."}, {"Berne", new Integer(9), "James Schneider", "277 Seventh Av."}, {"Boston", new Integer(32), "Michael Ott", "339 College Av."}, {"Boston", new Integer(23), "Julia Heiniger", "358 College Av."}, {"Chicago", new Integer(39), "Mary Karsen", "202 College Av."}, {"Chicago", new Integer(35), "George Karsen", "412 College Av."}, {"Chicago", new Integer(11), "Julia White", "412 Upland Pl."}, {"Dallas", new Integer(47), "Janet Fuller", "445 Upland Pl."}, {"Dallas", new Integer(43), "Susanne Smith", "2 Upland Pl."}, {"Dallas", new Integer(40), "Susanne Miller", "440 - 20th Ave."}, {"Dallas", new Integer(36), "John Steel", "276 Upland Pl."}, {"Dallas", new Integer(37), "Michael Clancy", "19 Seventh Av."}, {"Dallas", new Integer(19), "Susanne Heiniger", "86 - 20th Ave."}, {"Dallas", new Integer(10), "Anne Fuller", "135 Upland Pl."}, {"Dallas", new Integer(4), "Sylvia Ringer", "365 College Av."}, {"Dallas", new Integer(0), "Laura Steel", "429 Seventh Av."}, {"Lyon", new Integer(38), "Andrew Heiniger", "347 College Av."}, {"Lyon", new Integer(28), "Susanne White", "74 - 20th Ave."}, {"Lyon", new Integer(17), "Laura Ott", "443 Seventh Av."}, {"Lyon", new Integer(2), "Anne Miller", "20 Upland Pl."}, {"New York", new Integer(46), "Andrew May", "172 Seventh Av."}, {"New York", new Integer(44), "Sylvia Ott", "361 College Av."}, {"New York", new Integer(41), "Bill King", "546 College Av."}, {"Oslo", new Integer(45), "Janet May", "396 Seventh Av."}, {"Oslo", new Integer(42), "Robert Ott", "503 Seventh Av."}, {"Paris", new Integer(25), "Sylvia Steel", "269 College Av."}, {"Paris", new Integer(18), "Sylvia Fuller", "158 - 20th Ave."}, {"Paris", new Integer(5), "Laura Miller", "294 Seventh Av."}, {"San Francisco", new Integer(48), "Robert White", "549 Seventh Av."}, {"San Francisco", new Integer(7), "James Peterson", "231 Upland Pl."} }; private int index = 0; public boolean next() throws JRException { index++; return (index < data.length); } public Object getFieldValue(JRField field) throws JRException { Object value = null; String fieldName = field.getName(); if ("city".equals(fieldName)) { value = data[index][0]; } else if ("age".equals(fieldName)) { value = data[index][1]; } return value; } public static MyDataSource createDataSource(){ return new MyDataSource(); }}

Hi, I created my own Custum Data Source by implementing JRDataSource. It's all working to my satisfaction, but now I would like to retrieve parameters from my report to make a dynamic query. Any hints how to pass parameters I defined in the report design file ? Thanks in advance !

Hi ! I would like to know if there is a feature in iReport which let's me retrieve report data from a Java Object. Is it possible to add external java classes, instantiate objects and use data in these objects to fill the report ? Besides coding the hole thing in JAVA Thanks in advance !

Hi ! I would like to know if there is a feature in iReport which let's me retrieve report data from a Java Object. Is it possible to add external java classes, instantiate objects and use data in these objects to fill the report ? Besides coding the hole thing in JAVA Thanks in advance ! Edit : Its the wrong forum for iReport related question, sry. Could not delete the post Post Edited by fruchtiger at 12/13/2011 13:23

@ lesstra : thanks for your help :) I now found out with field[@fieldname=ID] the node contain the attribute can directly be addressed. Post Edited by fruchtiger at 11/11/2011 14:42 Post Edited by fruchtiger at 11/11/2011 14:42

Hi there, I would like to use JasperReport and the iReport-Designer for my work, but so far I didn't suceed with the very simple task of mapping my xml data so the report engine can work with it. The structure of xml file is like this : I created a data-source which succesfully connects to the xml file. Then I want to create a data-set which will map the structure to a table like this : | ID | forname | surename | nationality | 007 James Bond Great Britain .... I tried several xPath expressions but still did not manage to map the table as I wish. In fact I don't get any result from the source at all. Could you please have a look at my screenshot and tell what im doing wrong ? Code: Post Edited by fruchtiger at 11/11/2011 09:18 Post Edited by fruchtiger at 11/11/2011 09:30 Post Edited by fruchtiger at 11/11/2011 09:33