2002 JI Open Discussion

By: Leo Moreira - lmoliveira Scriptlet 2005-10-10 10:44 When / How can I use an Scriptlet ? Could anybody help me? Some example....? please I need to print a field from the database with a mask. I have the methods, but I don't known how to set up it inside the iReport. tks

By: Kostas Michailidis - mkostas_gr JasperPrint serialization 2005-10-07 03:55 Not so important, but sometimes it is usefull for experimentation to have serialized JasperPrint class instance. Can the iReport optionaly do that? (Excuse me for my English.)

By: sanforum - sanforum How to generate JRXML file? 2005-10-06 23:15 I can create jrxml file by hard coding and compile it using my own java file and can produce the report in HTML format by a java file. But using iReport Wizard of iReport 0.5.1 we can produce the JRXML file. Here I want to know how the JRXML file is created...I mean to say that what is/are the java file/s that generate this JRXML file. I have the source code but I cant get it. Please say me where I will get in the source code. Thanks in advance

By: meirab - meirab define datasource with ireport is a nightmare 2005-10-04 15:48 whenever i try to work with ireport + mysql i try to define: datasource with ireport is a nightmare, i am never able to point ireport to use mysql database or use the connection.jar that creats the connection. i allways get the message: "class not found error" this must change before any other "improvment" can be added since this barrier stops me from using the tool from the beginning. it should have filemenu > openwindow > select db directory. filemenu > select connector. and that's all, today i waste a long time in the datasource menu i still can't connect to mysql db on localhost.

By: SandeepRam - sandeepram iReport Variable initialization problem 2005-05-06 07:06 hi, I m using iReport 0.4.1 version. In the report design ' new Double(0) ' is used as Initial Value Expression in several text field variables . It works fine when these text fields have some value retrieved from the SQL query. But when these fields have null or no values it displays nothing (blank). I have ticked the 'Blank When Null' check box at the time of variable creation. I want to display ' 0 ' when there is no values in the variables. but it fails. can any one help me..... sanram By: C-Box - c-box RE: iReport Variable initialization problem 2005-05-08 01:40 Make an if-then-else-expression in your textfield instead of just using the field $F{MyDoubleField} Something like: ($F{MyDoubleField}.equals(null))?new Double(0):$F{MyDoubleField}) so when your field $F{MyDoubleField} contains no value (null) you get a "0" printed instead a blank. hth C-Box By: SandeepRam - sandeepram RE: iReport Variable initialization problem 2005-05-08 10:14 hai C-Box, i m already using the if-else expressing as u told. I will give the variable expression that i m using , given below : Eg: 1 (($F{transaction_type}.equals(new Integer(7))) ? new Double(new Long(java.lang.Math.round($F{amount}.doubleValue())).longValue()) :$V{w} ) In this $V{w} is intializes as--> new Double(0.00) when $F{transaction_type} value not equal to 7 i want to display 0.00 , but nothing (blank )appears. i will give u one more variable that i found problem. Eg: 2 new Double($V{totuseradvance}.doubleValue()+ $V{totuserbill}.doubleValue()+ $V{totuserreg}.doubleValue()- $V{totuserrefund}.doubleValue()) In this is even though these variables have some value nothing is displaying , only blank appears. whats the reason. i m now stuck with this issue. can u find any solution to this? with regards sanram By: C-Box - c-box RE: iReport Variable initialization problem 2005-05-08 22:25 Well you should uncheck all attributes that prevent a field from displaying. So for example the "BlankWhenNull" is not needed in your case.... because you are formatting your field in any case with your if-then-else-expressions. I also don't know what your evaluation-times for the fields and variables are... perhaps that's the reason that your field is displayed at NOW and the variable is calculated at REPORT and at the time NOW the value is NULL and that's why nothing appears!?!? Just some guess' C-Box By: Edward Mann - emann Expression if else "and or" 2005-10-04 13:28 I have a report that is getting some data from a database. The fields that i have are money fields. However some have 0 as a value and some are blank/null and others actually have a value in them. When the field is blank/null or just have a 0 in them i don't want them to print. I have spent a few hours reading through the mailing lists and other sites, but i just cannot figure out how to write an expression that will report what i want. i want something like this if ($value != "") || ($value != "0") { print the field } Any hints? Thanks. By: SandeepRam - sandeepram RE: iReport Variable initialization problem 2005-05-13 12:00 hi C-Box, The problem solved with less change. I put the 'new Double(0.00)' in the Variable Expression of $V{w} , as i have done in the Initial Value Expression. Then the report works !!.. i surprised why it happens. i think that when any variable's value , for eg: $V{totuserbill} is assigned to $V{w} , it doesnt gets '0' value but a null. So any calculation by using $V{totuserbill} after that , the entire result becomes null !!. But it works fine with iReport-0.1 . Is it a bug in iReport-0.4.1 ?? with regards sanram By: C-Box - c-box RE: iReport Variable initialization problem 2005-05-15 00:23 It's no bug of iReport 0.4.1.... I guess you compare iReport 0.1 with a very old JasperReports-Lib in that iReport-Version.... so the 0.4.1 is using 0.6.4 or newer.... so it's probabely more a problem of your JasperReport version that is located in current iReport's lib-directory. C-Box

By: Giulio Toffoli - gt78 iReport joins JasperSoft 2005-10-03 10:32 JasperSoft, the company that sponsors JasperReports is now also sponsoring iReport Designer. I will be joining JasperSoft as Architect of iReport Designer, and will be able to now work full-time advancing iReport s product roadmap. Teaming up with JasperSoft will allow iReport to become even more tightly integrated with JasperReports, advancing its leadership as the most popular open source report designer. iReport Designer will be open source always, and will continue to be distributed under the GPL. JasperSoft Support and Services for JasperReports are now extended to iReport too, which a number of iReport customers have been requesting. See http://www.jaspersoft.com/services_tech_support.php for more information. JasperSoft is the leader in commercial open source reporting solutions and is one of the most exciting open source companies. It is headquartered in San Francisco and was formed by a combination of open source and commercial reporting domain experts. JasperSoft also has a commercial product line, JasperDecisions that offers advanced functionality to the JasperReports community. You can find out more about JasperSoft at: http://www.jaspersoft.com I am proud of what we have accomplished to date with iReport, and want to thank you for all of your help and support on the project. And I am very excited to be joining JasperSoft and look forward to working more closely with Teodor Danciu and the rest of the JasperSoft team. With their help, and your continued support, we can make iReport better and more successful than ever. Guilio Toffoli

By: Leo Moreira - lmoliveira Page_Number on SubReport 2005-10-03 06:16 Hi, I have a Master report, with two subreport. In the Master report, I have to show the number, of pages the whole report has. The Problem: The page number 1 is the Master Title. Page number two has to be First in the Report1. The page number of Report2, has to start with the Report1 last_page number + 1... Can someone help me how to do this ? By: Daren O - rckrll106 RE: Page_Number on SubReport 2005-10-03 09:53 You can pass the$V{PAGE_NUMBER} as a subreport parameter for instance I did the same thing on a summary page which I made my last page. So I created a subreport parameter prevPageNumber with the value new Integer($V{PAGE_NUMBER}.intValue() - 1). Note the minus one was because I made the summary page a seperate page so the page count increased on me. Then in the subreport all I did was add to the subreport page number. ($V{PAGE_NUMBER}.intValue() + $P{prevPageNumber}.intValue()) Hope this helps. By: Leo Moreira - lmoliveira RE: Page_Number on SubReport 2005-10-04 06:22 Hi Daren, thank you very much !!! Now it's running...!!! Where do you came from ? I'm from Brazil

By: Joseph Noel - j1n0 Printing a subreport on a new page 2005-09-23 10:21 Hello. How do I get a subreport to start printing on a new page instead of just filling the current page? Thanks. By: Leo Moreira - lmoliveira RE: Printing a subreport on a new page 2005-10-03 06:53 Hi, there is another reply to this very question, try it at: By: new_tech - new_tech Printing sub-reports on a new page 2004-07-22 21:31 i hope to have help you

By: jigsh - jignesh_tandel How to fill Subreport ? 2005-09-28 04:45 Hello friennds i generate dynamic report using create .jrxml file,complie it to convert .jasper file and use fillReport(.jasper file name,datasource,paramater) funcion of jasper report to fill report. but i have a problem of filling subreport that i also make dynamically same as above i do't have a idea how to fill subreport please help me soon thanking you

By: Aniruddh - aniruddh Internationalizarion in iReport 2005-08-15 11:58 Hii All, I have create all necessary property files required for internationalization. But i dont know the process to view such report. All times it is giving english text only is there any special setting to set Locale to french. Even what to do from Java side while calling such report .. how to specify Locale? By: jane_lim - jane_lim RE: Internationalizarion in iReport 2005-09-26 06:23 Hi, I am now looking into the internationalization in iReport as well, have you got any solution on this issue ?? thanks

By: Joseph Noel - j1n0 Adding a text element below a subreport 2005-09-21 09:42 How can I set an element's position to be a few pixels below another element? Let's say I have a subreport that prints out a variable number of table data, and I want a static text to be placed 10 pixels below the subreport. I can't just set the top coordinate of the text because I do not know what height the subreport will have at the end. Is there a way to do this? Currently the subreport overflows through the text element I put below it. Thanks. Great job everyone, by the way. Jino Noel

By: hugo de la mora - hugodelamora Basic help creating chart on V0.5.1. 2005-09-06 10:29 Hi, i created a lot of charts using v0.5.0. now with this new version, i don't find where to create the report series, can anybody help me ...where is the correct way to set up the chart data on the chart properties window in v 0.5.1? thx By: hugo de la mora - hugodelamora RE: Basic help creating chart on V0.5.1. 2005-09-06 10:36 ....i was trying to create a pie chart, with a bar chart it is the same that v0.5.0. By: nidhi - nidhi_vaid RE: Basic help creating chart on V0.5.1. 2005-09-07 01:20 Hi I am facing the same problem not getting the right track to use the chart tool and set up the chart data. By: GBH - ghenrikb RE: Basic help creating chart on V0.5.1. 2005-09-19 06:10 I have tried to do the exact the same thing. The series I have created as a variable. I'm not sure im on the right way but take a look at this and You might get a clue if U move forward please let me know. SQL Select * where ClientAccount = 1 and Date = "2005-09-01" From this I choose Fields ClientAccount Integer MetalCode String MetalValue Double These are going in a piechart to show the respetive share of metalvalue against total value of the client account. The label of each piece in the chart is the MetalCode. What I try to do is this. I make one report series to the MetalValue and one to the label eg MetalCode. These definitions look like this Name = SERIE_MetalValue Variable classtype = Double Calculation Type = None Variable Expression ((it.businesslogic.ireport.IReportScriptlet)$P{REPORT_SCRIPTLET}).addValueToSerie($V{SERIE_MetalValue},$F{MetalValue}) Name = SERIE_MetalCode Variable classtype = String Calculation Type = Nothing Variable Expression $F{MetalCode} These two go into the piechart in the following way. Under the chartproperties/chartdata/details I put this. Key expression $F{AccountId} Valueexpression $V{SERIE_MetalValue} Labelexpression $V{SERIE_MetalCode} Now done! I try and run it Compiling to file... .graftest.jasper -> C:Program FilesiReport-0.5.1graftest.java Errors compiling .graftest.jasper! it.businesslogic.ireport.ReportClassLoader@1b7aa8 net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Cannot cast from Boolean to Double value = (java.lang.Double)(((it.businesslogic.ireport.IReportScriptlet)((graftestScriptlet)parameter_REPORT_SCRIPTLET.getValue())).addValueToSerie(((java.lang.Double)variable_SERIE_MetalValue.getValue()),((java.lang.Double)field_MetalValue.getValue()))); <----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 2. The method addValueToSerie(String, Object) in the type IReportScriptlet is not applicable for the arguments (Double, Double) value = (java.lang.Double)(((it.businesslogic.ireport.IReportScriptlet)((graftestScriptlet)parameter_REPORT_SCRIPTLET.getValue())).addValueToSerie(((java.lang.Double)variable_SERIE_MetalValue.getValue()),((java.lang.Double)field_MetalValue.getValue()))); <-------------> 3. Cannot cast from Boolean to Double value = (java.lang.Double)(((it.businesslogic.ireport.IReportScriptlet)((graftestScriptlet)parameter_REPORT_SCRIPTLET.getValue())).addValueToSerie(((java.lang.Double)variable_SERIE_MetalValue.getOldValue()),((java.lang.Double)field_MetalValue.getOldValue()))); <----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 4. The method addValueToSerie(String, Object) in the type IReportScriptlet is not applicable for the arguments (Double, Double) value = (java.lang.Double)(((it.businesslogic.ireport.IReportScriptlet)((graftestScriptlet)parameter_REPORT_SCRIPTLET.getValue())).addValueToSerie(((java.lang.Double)variable_SERIE_MetalValue.getOldValue()),((java.lang.Double)field_MetalValue.getOldValue()))); <-------------> 5. Cannot cast from Boolean to Double value = (java.lang.Double)(((it.businesslogic.ireport.IReportScriptlet)((graftestScriptlet)parameter_REPORT_SCRIPTLET.getValue())).addValueToSerie(((java.lang.Double)variable_SERIE_MetalValue.getEstimatedValue()),((java.lang.Double)field_MetalValue.getValue()))); <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 6. The method addValueToSerie(String, Object) in the type IReportScriptlet is not applicable for the arguments (Double, Double) value = (java.lang.Double)(((it.businesslogic.ireport.IReportScriptlet)((graftestScriptlet)parameter_REPORT_SCRIPTLET.getValue())).addValueToSerie(((java.lang.Double)variable_SERIE_MetalValue.getEstimatedValue()),((java.lang.Double)field_MetalValue.getValue()))); <-------------> 6 errors at net.sf.jasperreports.engine.design.JRJdtCompiler.compileReport(JRJdtCompiler.java:178) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:129) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:127) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:109) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:461) at java.lang.Thread.run(Unknown Source) Compilation running time : 531 I cant figue out where I get i wrong..... Could anyone give me a tip? I really sont get why I get a cast error when the field is a double... By: GBH - ghenrikb RE: Basic help creating chart on V0.5.1. 2005-09-20 02:39 hugodelamora, nidhi_vaid I just solved it with charts. What do You want to do?

By: Juan Carlos Esteve - jesteve Report and Subreport with diferent datasource 2005-09-13 06:05 I have master report with Postgres backend. and I need a subreport with Oracle backend. PLEASE HELP ME!. I don t understand the manual in page 88 ("To specify the datasource") in a subreport. I don t know how manage the parameters $P{REPORT_CONNECTION} or $P{MyDatasource} I don t know how manage the "Connection / Datasource Expresion" in the subreport dialog. AND I USE THE OPENREPORTS FOR EXECUTE THE .JASPER :) Thankyou, sorry by my english By: Juan Carlos Esteve - jesteve RE: Report and Subreport with diferent datasource 2005-09-14 05:07 OK, I found one solution.... First, create a new parameter... Parameter Name: subreportDS (for example..) Parameter class tipe class: java.lang.Object Default value expresion: java.sql.DriverManager.getConnection("jdbc:oracle:thin:@host:1521:dbname", "user", "password") Then... in the subreport dialog ... at "Connection / Datasource expresion" choose "Use connection expresion" and in the texbox... $P{subreportDS} (the parameter name created) Compile and test Bye

By: hugo de la mora - hugodelamora java files v050 vs v051 2005-09-06 14:23 when i compile a simple report without charts IRv050 involves 3 files, a jasper, a bak and a xml file, when i compile the same file whit IRv051 creates also a java file in the ireports home folder, why?

By: adi77 - adi77 Cannot Cast from int to Integer 2005-09-06 14:21 When using Parameters of type java.lang.Integer, the Compiler ggenerates Code like this case 8 : // 8 { value = (java.lang.Integer)(1); break; } But it should read like this case 8 : // 8 { value = (java.lang.Integer)(new Integer(1)); break; }

By: GBH - ghenrikb Simple guide to get started with chartIreport 2005-08-30 07:53 First things first! Great tool! We have been following this under the last 6 months and are impressed. Now I have tried to get the chart feature work but I really dont now in which end to start. I tried to just put a chart control in the report and run it with the follwing message? Input pleeeease..... java:4: cannot access java.lang.Object bad class file: C:Program FilesJavajre1.5.0_02librt.jar(java/lang/Object.class) class file has wrong version 49.0, should be 48.0 By: GBH - ghenrikb RE: Simple guide to get started with chartIreport 2005-08-31 05:19 Solved. By: nidhi - nidhi_vaid RE: Simple guide to get started with chartIre 2005-08-31 09:36 hi i am using the iReport 0.5.1 version and having one problem in using charts when i include chart even in empty report then it shows me the following error:- it.businesslogic.ireport.ReportClassLoader@b34b1 0 [Thread-10] ERROR digester.Digester - End event threw exception java.lang.NoSuchMethodException: No such accessible method: setBox() on object: net.sf.jasperreports.engine.design.JRDesignChart at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:248) at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:216) at org.apache.commons.digester.Rule.end(Rule.java:230) at org.apache.commons.digester.Digester.endElement(Digester.java:1130) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1666) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:209) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:163) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:147) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:107) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:461) at java.lang.Thread.run(Unknown Source) java.lang.NoSuchMethodException: No such accessible method: setBox() on object: net.sf.jasperreports.engine.design.JRDesignChart at org.apache.commons.digester.Digester.createSAXException(Digester.java:2919) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2945) at org.apache.commons.digester.Digester.endElement(Digester.java:1133) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1666) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:209) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:163) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:147) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:107) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:461) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRException: Error at line 59 char 192: No such accessible method: setBox() on object: net.sf.jasperreports.engine.design.JRDesignChart at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:229) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:209) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:163) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:147) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:107) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:461) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NoSuchMethodException: No such accessible method: setBox() on object: net.sf.jasperreports.engine.design.JRDesignChart at org.apache.commons.digester.Digester.createSAXException(Digester.java:2919) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2945) at org.apache.commons.digester.Digester.endElement(Digester.java:1133) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1666) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) ... 6 more Please if anybody can help me. Its very urgent.

By: kunchito - kunchito i can't compile with ireport 0.5.1.. 2005-08-30 15:27 Hello friends: I downloaded the last version of iR., unzipped, pasted the tools.jar, and it starts but don't compile. I'm using jdk 1.5 and win xp prof. is this a bug???.... The 0.5.0 version compiles but throws me the jdt and classNotFound exceptions. I have no problems using the 0.5.0 version in win98se, but that is not my objective... Any advice???... Regards

By: smm2208 - smmdpi Customize JFreeChart properties 2005-08-30 05:09 I'm invenstigating about JFreechart and looks like that there are few properties that can t be set from iReport. The most common sample is setting leyend colours. Theodord is working on this and soon I hope this will improve. I thing it would be interesting feature for iReport. Thanks, I'm really grateful with your project.

By: AlperULUSOY - taramakalemi Multiple use of a JRdatasource 2005-08-22 07:01 We can pass datasources to subreports as parameters.. But for instance a JRdatasource is never usable in master report in detail band for all records but the first (for once) ! I use JRTablemodeldatasource, no groups. Do Reset methods implemented with only variables? How can we reset datasources or how can this problem be solved? By: C-Box - c-box RE: Multiple use of a JRdatasource 2005-08-22 07:09 Well, I do use CustomDataSources as well... I (re)use them in nested SubReports for logical separating the output via PrintWhenExpressions... so therefore I needed also to reuse a custom datasource... as the nextmethod scrolls through all records you can use it just once by default... so either try to make your datasource "cloneable" (so I do, because I must use the same datasource in a nested subreport and then again in it's parent level subreport). Or just call the "moveFirst" method when passing the datasource to SubReport (make an expression for a helper class where you first call "moveFirst" and then return the datasource. But I would prefer the cloneable variant. hth C-Box By: AlperULUSOY - taramakalemi RE: Multiple use of a JRdatasource 2005-08-23 01:39 C-Box, I searched about your suggestions, i think i undersand the theory but in practice. "moveFirst" method seems more easier to me. But i didn't understand how i will make it. Must i write an expression of datasource in subreport tool? If it is more complex than a piece of code, could you tell me what documents i should read lo learn? Regards Alper By: C-Box - c-box RE: Multiple use of a JRdatasource 2005-08-23 01:59 Well I don't know any document where you could read that... in my case it was a process of Trial&Error! :-) As you want to try it via the "moveFirst" method I would do the following. Make a helper class like "MyJasperHelper" there you make an attribute for your SubReportDataSource make a public Set- and a GetMethod for it. before you fill your Report you create an instance of your "MyJasperHelper" and set the SubReportDataSource via the setMethod.... Pass your helper-object to the parameter-map when filling. (e.g. paraMap.put("MyHelper",myHelperObject);) in the getMethod you make something like this: public JRDataSource getMySubReportDataSource(){ this.privateAttributeForMySubReportDataSource.moveFirst(); return this.privateAttributeForMySubReportDataSource; } in your SubReport-Element in your MasterReport you put as DataSourceExpression this one: $P{MyHelper}.getMySubReportDataSource() make sure that your class is within the class-path. and voil that's all. So (a bit more complex and structered) I do also. :-) hth C-Box By: AlperULUSOY - taramakalemi RE: Multiple use of a JRdatasource 2005-08-29 23:55 C-Box, It worked! We are all happy my boss, my colleagues, our customer ans so... :-) thank you very much. Alper

By: Giulio Toffoli - gt78 iReport 0.5.1 released! 2005-08-26 17:44 iReport 0.5.1 released! iReport is an Open Source visual designer for JasperReports. In this version: - Full support for JasperReports 1.0.1 (Charts included) - New charting support - New TXT export f - New RTF exporter - Support for the new Report Virtualizer - Serveral bug fixes and improvements http://ireport.sf.net Thanks for your suggestions and your ongoing support using iReports! Giulio

By: TesTech - testech How to create Report with XML as DataSource? 2005-06-01 22:35 Till now,we created the report by connecting to database. Please tell me how to create the jasper file without connecting to database using Ireport Designer. My data will be available in XML file.I have given the sample XML file below: Three fields are there in the XML : "name" , "phonenumber" and "email" <RC-BOD> <preppodtl RecordCount="45"> <I name=" A" phonenumber=" 988435419" email=" " /> <I name=" S(mobile)" phonenumber=" 984108491" email=" " /> <I name=" V" phonenumber=" 988416832" email=" " /> </preppodtl> <errordetails RecordCount="0"/> </RC-BOD> I have created jasper XML file with field names "name" , "phonenumber" and "email" on <detail> section, through iReport designer. By: sadsd - micasa RE: How to create Report with XML as DataSource? 2005-06-07 08:53 What problem do you have? maybe if you tell us we can help you. By: TesTech - testech RE: How to create Report with XML as DataSource? 2005-06-28 00:30 I already mentioned the problem i am facing. (Please tell me how to create the jasper file without connecting to database using Ireport Designer. ) Anyhow,i will tell again, How to bind the data from xml to the Report? By: mauricio cordero - maucorpat2 RE: How to create Report with XML as DataSour 2005-07-11 03:06 build/buil all. that its. he make the file *.jsper By: Wal Millard - walmillard RE: How to create Report with XML as DataSour 2005-08-24 17:26 i suggest you have a look at the XML Datasource example that is included in the jasper report lib. here is a previous post on getting it working https://sourceforge.net/forum/message.php?msg_id=2838171 luck walmillard

By: even - yingyi8989 Create report with custom JRDataSource ? 2005-08-22 20:47 I want to create a report with custom JRDataSource datasource,but i don't konw how to do that? The example show in iReport guide (Chapter 4) are not clear for me?

By: Pedro Zenon - pzenon VERY IMPORTANT: Error Compiling a Report 2005-08-19 13:19 This is my error. What i have to do..... I am running SuSE 9.3, jdk1.5.0_04, MySQL 4.1.10a-3.2. What I have to do........................... it.businesslogic.ireport.ReportClassLoader@11e1813 1263830 [Thread-33] ERROR digester.Digester - End event threw exception java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:250) at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:260) at org.apache.commons.digester.Digester.endElement(Digester.java:1036) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:356) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:340) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:294) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:278) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:107) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:420) at java.lang.Thread.run(Thread.java:595) Caused by: net.sf.jasperreports.engine.JRException: Duplicate declaration of field : name at net.sf.jasperreports.engine.design.JasperDesign.addField(JasperDesign.java:1010) ... 25 more java.lang.reflect.InvocationTargetException at org.apache.commons.digester.Digester.createSAXException(Digester.java:2312) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2332) at org.apache.commons.digester.Digester.endElement(Digester.java:1039) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:356) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:340) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:294) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:278) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:107) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:420) at java.lang.Thread.run(Thread.java:595) NESTED BY : net.sf.jasperreports.engine.JRException: Error at (36, 47: null at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:360) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:340) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:294) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:278) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:107) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:420) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.reflect.InvocationTargetException at org.apache.commons.digester.Digester.createSAXException(Digester.java:2312) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2332) at org.apache.commons.digester.Digester.endElement(Digester.java:1039) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1514) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:356) ... 6 more

By: query - query Page break while displaying the reports 2004-06-25 00:35 I am using ireports 0.3.1 as GUI tool for Jasper Reports. Reports are to be displayed on a web layout(HTML). The pages of the report are being displayed continuously without a break. How can I display the report pagewise. Any information regarding this would be greatly appreciated. By: Giulio Toffoli - gt78 RE: Page break while displaying the reports 2004-06-29 03:16 On your app, you can tell to the filled to create only pages from x to y. Now, if you add two links at the end of your page, one that points to the previos page, the second to the next, you can simulate a paged visualization. I hope that this can answer to your question. Giulio By: query - query RE: Page break while displaying the reports 2004-06-29 23:44 Hi Toffoli Thx for the response but Can u be more clear with the answer given by U "you can tell to the filled to create only pages from x to y." In the sentence above "filled" refers to some option in ireports or related to fillreport method in Jasper. By: Piyush - piyushrules RE: Page break while displaying the reports 2005-06-16 02:13 Hi query, Have you figured out a solution to this problem ? If so, could you please forward a sample code snippet. Hoping a response from you. Thanks in advance. Piyush By: query - query RE: Page break while displaying the reports 2005-06-21 00:45 Hi Piyush, As of now I hav got no solution. Long time I used ireports. I started using them again. If I get any solution I wud forward it. Are U using ireports 0.5.0???// I hav created reports using 0.3.0 earlier. are there any features in 0.5.0 that we can use to improve the look and feel of the report and also in the process of creation of the report. like reports being displayed in the form of a table etc. There is no free documentation available for ireports 0.5.0 :( query By: kevin - fishbowlkevin RE: Page break while displaying the reports 2005-07-28 11:47 open the xml for the report and look for a line that says <I ATTLIST group isStartNewPage (true|false) "false" and set it to true By: ravanini_m - ravanini_m RE: Page break while displaying the reports 2005-08-10 07:22 Hi. I'm having the same problem with my EXCEL reports, but but there is no such thing as "isStartNewPage" in it's xml file. Is there anything else I can do? Thanks a lot. By: arvind - ar_win RE: Page break while displaying the reports 2005-08-15 10:53 I have used this fetaure and it only looks good for a single report where you havemany sections and there is no subreport. A report i currently made was just using subreports. So i had used a (fresh/new) band for the subreport. And for the band/report group i said start from new page .....but it was still continuing from the same page and the next row from where the last finished up. So can we a have new page when we want to start with the subreport, so that assertion made by me is wrong (first two line). -Rgds Arvind

By: arvind - ar_win Page Footer, only on first page 2005-08-15 10:43 Hello All, I am preparing an invoice and want to put in a Page Stub nly on the first page and not on the rest of the pages. What i have done till now is..i have prepared the page stub and it is ocming on first page also and not coming on the other pages ...but to my amzament it is dispalying the unused space at the bottom of all the pages..which it should not as for just printing the footer band i have used the expression as "new java.lang.Boolean ($V{PAGE_NUMBER}.shortValue()==1)".... So is there solution to this problem...if yes please let me know as where i am going wrong. I have read the iReport manual and not able to figure out as if the footer bands (column/page) are not resizable so will the invoice always use up the space that i have defined for the page in all pages ...(but there shud be a solution to this problem??)... Please let me know if you have any know how on what i am trying to day if you need more details..please let me know. -Arvind