2002 JI Open Discussion

By: kunchito - kunchito Can I use Ireport with db4o ?? 2005-08-05 16:18 Hello to every body: I started to use "db4o" which is a ODBMS, and I want to know if it's possble to use it with ireport??? or have some idea how to do it??. Regards.

By: whattodonow - whattodonow Subreports without parameters, possible? 2005-08-02 17:38 Can someone help by explaining how to create subreports without having to pass parameters?

By: B.J. - jarub polish translation 2005-08-02 14:03 Hi, I've made transations to polish language of property file - I've added missing key values. You can download it from ftp://157.158.188.30:2121 - user anonymous (no password). Zip file iReport.zip resides in /pub directory. Regards, B.J.

By: TesTech - testech How to do Subreport??? 2005-05-30 08:03 I am trying to create subreport through IReport Designer in any version. I downloaded the video-tutorials from site.Even i am unable to create subreport. For the SubReport Field in the Parent report,I set the property "Use connection expression" as $P{REPORT_CONNECTION}. While launching the report,Its throwing the following error : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3150) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:89) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:454) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:411) at java.lang.Thread.run(Thread.java:534) If i didnt set that property ,then the Parent report itself is launching ,but not the subreport.Please help me to launch the sub report. By: Giulio Toffoli - gt78 RE: How to do Subreport??? 2005-05-31 00:46 Use a native JDBC driver. ODBC/JDBC bridge don't permit more than a Statament per Connection: this is the error you catch. Giulio By: TesTech - testech RE: How to do Subreport??? 2005-05-31 03:30 hi giulio , Thanks for ur reply. ya i have used,native driver previously.As u said,it doesnt allow me to execute more than one queries. Now i changed to thin driver. Its working fine when i used different query in main report and subreport. ie.without passing any parameter. When i try to pass parameter from main report to sub report it is throwing the following errror Microsoft][sqlServer 2000 Driver for JDBC]Syntax error at token }, line 0 offset 8. I have given the following sql statement that i used in subreport select city from customers where country=${country} Please telll me the steps on how to pass parameter from main report to sub report. By: whattodonow - whattodonow RE: How to do Subreport??? 2005-08-02 13:26 How did you use subreports without passing parameters?

By: geuslenn - geuslenn Using Combobox To Select Parameter Value 2005-08-01 06:48 Hi everybody, I am designing reports with Ireport. I want to prompt some parameters that their values in combobox to users . Is there any way to use combobox. Thanks.

By: Saravanan - sarmal Resize PageFooter by Scriptlet,Last PageFoote 2004-06-14 01:27 Dear Friends I am Using Jasper Reports in my Application I have Write a Scriptlet to Show the PageFooter in the Last Page . It is executing well , But I got Blank Space of the Page Footer in Each Page & At the Last Page I got Datas at the Last Page - Page Footer . How do I avoide the Page Footer Blank Space at all the n-1 Pages ( i.e Except Last page ) Is it Possible to Resize the Page Footer - Size in Scriptlet So that its Size at Other than Last Page Should be Zero. Is there any Other Solution for it Regards Sarmal By: Giulio Toffoli - gt78 RE: Resize PageFooter by Scriptlet,Last PageFoote 2004-06-18 00:34 You have to use the printWhen Expressions. PageFooter, like ColumnFooter are not resizable bands. Giulio By: Piyush - piyushrules RE: Resize PageFooter by Scriptlet,Last PageFoote 2005-06-16 02:08 Hi, could you throw more light on the PrintWhenExpression. for instance the syntax? I'm trying to show a field in red color only when its value is greater than 100. how should I go about it ? Thanks in advance, Piyush By: kevin - fishbowlkevin RE: Resize PageFooter by Scriptlet,Last PageFoote 2005-07-28 12:03 This would print the field if field1 - field 2 is less than 0. Making it red is a simple matter of changing the font color. new Boolean(new Double($V{Field1}.doubleValue()- $F{Field2}.doubleValue()).doubleValue() < 0)

By: korrrus - korrus jasperreport 1.0 Support 2005-07-28 06:50 When iReport will support jasperreport 1.0 ? The most necessary thing is returning variables from subreport. When I make it manualy and try to run report in iReport then it overwrite my changes and returning variables dont work.

By: vivaspeed - vivaspeed Problem during Database JDBC connection 2005-07-26 02:55 Hi, I am a beginner for iReport and jasperreports. I've mysql in localhost and port 3360 in my pc. I trying to get the database JDBC connection for iReport configure setting. The step I did as below: I entry the Server Address field - "localhost:3306" and my database "mysql"... I click for the Wizard button. And select the JDBC Driver "com.mysql.jdbc.Driver" and I try also "org.gjt.mm.mysql.Driver" However, the windows prompt for some error message: <truncate> SQL problems: Communication link failure: java.io.IOException,underlying cause:Unexpected end of input stream ** BEGIN NESTED EXCEPTION** java.io.IOException MESSAGE:Unexpected end of input stream STACKTRACE: java.io.IOException:Unexpected end of input stream at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java.626) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.<init>(Connection.java:491) at com.mysql.jdbc.NOnRegisteringDriver.connect(NonRegisteringDriver.java:346) </truncate> Additional info, the environment I have here: - iReport-0.5.0 version - jasperreports-1.0.0.jar - mysql-essential-4.1.13-win32 - jdk1.5.0_03 Kindly advise. Thank you very much.

By: jigsh - jignesh_tandel How to generate Dynamic Report 2005-07-23 00:02 Hello i am jignesh tandel.i am a user of your Product of develope reports i.e jasper and ireport. it has effective and user friendly GUI. it very easy to develope static reprots using IREPROT. but,here i have problem of dynamically generate report design i.e. differet report has only one design which is change dynamically. that's why i have probelm of create page header,details foolter sections dynamically and also static and dynamic filed for the solution i thought to generate .jrxml file in JAVA and passed it to jasper compiler for createing .jasper file and use fillreport function to fill it above solution might be right or not this is as per your opnion ? if it is right then how to create .jasper file from .jrxml file ? if it is wrong then please suggest me better solution ? here i request to solve above problems. waiting for your favourable reply. yours' truely j.l.tandel

By: Jesus Marin - jesusapl spanish translations 2004-04-19 09:35 Next I'll attach spanish translations By: Jesus Marin - jesusapl RE: spanish translations 2004-04-19 09:37 I supposed that I was going to get a way to attach my files after initial post but I do not see where... By: Giulio Toffoli - gt78 RE: spanish translations 2004-05-10 06:39 Jesus, post it to me (gt78 at sourceforge.net) or send it as patch By: Jesus Marin - jesusapl RE: spanish translations 2004-05-15 04:29 Ok, sent. By: Jesus Marin - jesusapl RE: spanish translations 2004-05-15 04:32 If someone tells me how to commit or whom to send the changes, I do not mind giving a hand in adapting Mainframe.java to get the pending translations By: mauricio cordero - maucorpat2 iReport ayuda. 2005-07-11 08:11 Hola, Me dirijo a ustedes a los cuales he encontrado q tienen conocimientos sobre ireport. tengo el siguiente problema: When I compiling no error apear, when I execute the following error apear: ------------------------------------------------------------------------------------------------------------------------------- net.sf.jasperreports.engine.JRException: XPath selection failed. Expression: /GLOBAL/DAY+usrsAuthenAvg at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:336) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:872) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:116) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:116) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:428) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:344) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:571) at java.lang.Thread.run(Thread.java:534) Caused by: org.apache.xpath.XPathException: No se puede convertir #NUMBER en una NodeList. at org.apache.xpath.objects.XObject.error(XObject.java:741) at org.apache.xpath.objects.XObject.nodeset(XObject.java:471) at org.apache.xpath.CachedXPathAPI.selectNodeIterator(CachedXPathAPI.java:219) at org.apache.xpath.CachedXPathAPI.selectSingleNode(CachedXPathAPI.java:177) at org.apache.xpath.CachedXPathAPI.selectSingleNode(CachedXPathAPI.java:157) at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:334) ------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------- And for connection/database properties is: xml file = /home/ocordero/documentos/javadoc/JasperReport/reportesAirMonitor/xmlFileGroup.xml select expresion = /GLOBAL/DAY --- And for field is : fieldname = usrsAuthenAvg; class type = java.lang.string; field description= /GLOBAL/DAY+usrsAuthenAvg. --- And my xml file is: <?xml version="1.0" encoding="UTF-8"?> <GLOBAL CreationData="2005-07-07 16:48:12.972" Type="Uso de la red wireless"> <alarmHighTotal>717</alarmHighTotal> <alarmMediumTotal>86</alarmMediumTotal> <alarmLowTotal>2</alarmLowTotal> <DAY Date="2005-05-20 23:59:14.176"> <usrsAsocAvg>2</usrsAuthenAvg> <traficInAvg>3070</traficInAvg> </DAY> <DAY Date="2005-05-22 00:01:01.696"> <usrsAsocAvg>5</usrsAuthenAvg> <traficInAvg>1200</traficInAvg> </DAY> </GLOBAL> Algo curioso es que si yo cambio el """field description= /GLOBAL/DAY/usrsAuthenAvg."" de la coneccion de la base de datos.Es decir si yo cambio el simbolo "+" por "/", no da ningun error cuando corro el reporte desde el iReport. Pero muestra el reporte mal, ya que muestra el primer DAY dos veces, es decir el segundo campo DAY de mi archivo xml no lo muestra. <DAY Date="2005-05-20 23:59:14.176"> <usrsAsocAvg>2</usrsAuthenAvg> <traficInAvg>3070</traficInAvg> </DAY> <DAY Date="2005-05-22 00:01:01.696"> <usrsAsocAvg>5</usrsAuthenAvg> <traficInAvg>1200</traficInAvg> </DAY> Agradezco su ayuda. Pueden responderme personalmente a mi email o poner un post en el forum del iReport, de esta manera ayudaremos otro con el mismo problema: http://sourceforge.net/forum/forum.php?thread_id=1316344&forum_id=217622 -- Oscar Cordero Salda a Ingeniero Telecomunicaciones oscar.cordero@openwired.net (Spain) Tel (+34) 93/440 00 09 - Fax (+34) 93/448 41 44 By: C-Box - c-box RE: spanish translations 2005-07-14 12:32 .. would be better if you post in english... as I (from Germany) also do... I would have helped you... but my spanish is far away from school and even there it was just facultative :-) C-Box Post edited by: tcloonan, at: 2006/09/02 10:19

By: TesTech - testech Multi Line Expression 2005-07-03 23:48 Hai All !! Im using ireport 0.3.0.I navigated to "Tools --> options " In that one ,I found a check box named "Use MultiLine Expression" . Is it possible to use multiline textfield expression??.If it is possible ,can any one give me some idea about how to use it. Thanks in advance !! Regards testech

By: TesTech - testech Number Format on GERMAN 2005-07-03 23:43 Hai !! Im using iReport 0.3.0 .Im facing the issue with number format.I need to display numbers in german format ,with exaclty two digits after decimal point . In the textfield expression , i gave like this : NumberFormat.getNumberInstance(Locale.GERMAN).format(<a double value>) and in the pattern I selected (#,##0.00) After executing the report ,German format is displaying but not rounding into two digits after decimal point.That is ,the pattern is not applying. For example : A double value : 1000.3462 For the above expression and pattern ,Im getting 1.000,346 But I need 1.000,35 Please help me !! Thanks in advance !!!

By: TesTech - testech How 2 Print the Report in ClientSide Printer? 2005-06-28 00:18 I am launching the Report which is available in my server. My aim is to print the Report in the printer connected to client. I am having one doubt,When using JasperPrintManager it prints the report in Clientside or Serverside Printer? If it prints the report in Serverside printer,then how can i print the report in Clientside Printer.? Please clarify in detail..... By: alanHardwick - alan314 RE: How 2 Print the Report in ClientSide Prin 2005-06-29 03:24 If the report is generated on the server side you need to transfer the jPrint object back to the Client Side code and print from there,, I would guess... By: Daren O - rckrll106 RE: How 2 Print the Report in ClientSide Prin 2005-06-29 06:06 Alan is correct, pull the JasperPrint object back to the client and print it from there.

By: TesTech - testech Need Support regarding Scriptlet 2005-06-29 03:41 I dont have any idea about where to place the scriplet class file and how to call the class file from the ireport designer. Can anyone help me..?

By: Hiran V R - hiranvr To Display in words 2004-07-22 23:28 hi i want a report with marks displayed both in figures and words. Marks field is having marks in figures. how can i display those marks in words. Kindly suggest some solution. Thanks in advance By: ksm - siromani RE: To Display in words 2005-06-24 04:08 hi i got same problem. i wrote one scriptlet class and pass the number to that.in scriptlet i wrote code for convert number to words.that method returns string thanks & regards ksm Post edited by: tcloonan, at: 2006/09/02 10:18

By: chhaya - chhaya where can I get scriplet example for iReport? 2005-06-20 00:37 HI friends, I am new to JapsperReports as well as iReport. I want to use scriplet in the iReport. I have version 4 as well as 5 with me. Pls guide me where can I get the example for the scriplet ? Thanks in advance, Chhaya

By: Federico Pertile - pertile CheckBox graphics 2005-06-17 16:52 Always it's easier suggesting that working :) but I wanted to let you know that it would be great if iReport implements a "RadioField" and a "CheckBoxField"

By: mks - mksusa Drill Down Feature on Chart 2005-06-13 18:54 Hi, Can we Drill down on a chart using iReport ? I can drill down on Jfreechart, but donot know how to implement the same in Jasper report's. Help in this matter is greately aprreciated. Thanks Mike By: mks - mksusa RE: Drill Down Feature on Chart 2005-06-13 19:19 To be more precise, I want to drill down based on a section in a chart. I can drill down on the whole chart by using Hyper link element, but didnot suceed, in drill down based on a section in the chart. For example, My chart shows how many registered user and non registered users are using my system. Once I click on non-registered users section, I want to see the full details of the users who are not registred. Similarly I should see the details of registered users, when I click on "registred users" section in the chart. How I made it clear what exactly I am looking for. Thanks Mike By: Piyush - piyushrules RE: Drill Down Feature on Chart 2005-06-16 00:56 Hi mksusa, I'm also in need of similar requirement. I'll update on the forum, if i'm able to get any information on that. If you are able to get more details on that, please do post it on the forum. Regards, Piyush

By: Saahil - saahil_parekh Group total in lastpage footer 2005-06-15 00:27 Hello, I am facing the problem with iReport 0.4.0 I grouped by my report with say "Service" column. After displaying group details, I show the sum for that group using report variable. I have already done this and it is working fine. But now in lastPage footer , I want to show all the group names and respective total one more time which are shown in the group and detail part of the footer. That will serve as the summary for the groups shown above. Can I do this with variables ? When I decleared the Report level variables it takes the sum of column for all the groups. I want one specific variable to sum only for the specific one group of the report and want to display it in lastpage footer How can I do that? Is it possile with the report variables? I don't want to do it with Sub report. Please guide me in this regard. Thanks in advance,

By: Saahil - saahil_parekh "Class Not Found" Error creatin connection 2005-06-14 23:56 Hi friends, I have downloaded iReport 0.5.0 from site, I started it by clicking iReport.bat file. Now, when I tried to create a connection using oracle.jdbc.driver.oracledriver, it gives an error that "class not found" and give suggestion as Check ur Classpath !!! I mean I failed to create a connection. I have already been using iReport 0.4.0 as it was already there when I started to work. I also use number of other Java Applications. But I don't know what changes I will need to make in iReport 0.5.0 configuration to make it work. Pls guide me in this issue, that hw to set classpath or to create the connection ?

By: gabyem - gabyem Number format 2005-03-07 11:33 Hello! I am building a report with iReport and Jasper Report. It works fine but I cant change the numbers to use '.' as decimal separator and ',' as thousand separator. I tryed changing the pattern and it did not work. I changed the regional settings on the computer and it did not work either. I will appreciate any help! Thanks By: allie - allie910 RE: Number format 2005-06-13 20:39 Hi There, sorry, but are u sure u are using the right pattern ? I'm using #,##0.00 and it's working fine with me =) The way that i'm showing a bigecimal variable using a textfield and set the value class of the textfield as : java.math.BigDecimal and set the pattern to the textfield as well ;) hope this can help u By: Giulio Toffoli - gt78 RE: Number format 2005-06-14 07:54 Please note that #,##0.00 is Locale indipendent, so in Italy the result of: #,##0.00 will be: 1.234,56 Giulio

By: lsbouffard - lsbouffard Check for iReport updates... 2005-06-08 17:30 Hi, I installed iReport at work behind a proxy server and it takes forever to start. It wait for a Connection timed out related to the checkupdate plugin before it could start. Is the function it.businesslogic.ireport.plugin.checkupdate.UpgradeSearch.run launched at every start. If so, it would be great to have an option that turn off this function and an other one to enter the proxy server address. Thanks By: Giulio Toffoli - gt78 RE: Check for iReport updates... 2005-06-13 08:04 You can turn off it from tools -> plugin options -> Update checker Giulio

By: SandeepRam - sandeepram Date Parameter Problem 2005-06-10 01:31 hi, I m using iReport0.4.1 for designing reports in Open Reports. I want to use a query that hase a date field. My requirement is that, if date parameter is entered through the OpenReports then only it appears in the sql query . Other wise an empty string. So in iReport i declared a variable CheckDate and its expression is give below: (!($P{FromDate}.equals(""))) ? $P{FromDate}:" " but when compiling error occured because the if part returns Date and else part String. Then i tried out (!($P{FromDate}.equals(""))) ? $P{FromDate}.toString():"" Now the error gone and i compiled successfully. but while i m running the report sql Exception occurs. Its because the the value of the iReport parameter CheckDate becomes 'Fri Jun 10 00:00:00 GMT+05:30 2005' and its a class java.lang.String type. How to solve this issue? and how the the date parameter is to use correctly in this context. can anybody help, with regards sanram By: alanHardwick - alan314 RE: Date Parameter Problem 2005-06-10 03:48 Have you tried building your SQL query dynamically within code and passing it as a parameter.. By: SandeepRam - sandeepram RE: Date Parameter Problem 2005-06-10 05:42 hi alan, Ya, the SQL query is not working because the type of the parameter $P{CheckDate} becomes string. So my doubt is how set a date value in this param as : CheckDate= (!($P{FromDate}.equals(""))) ? $P{FromDate}:" " This will not work since $P{FromDate} is a date datatype and " " is a String type. So how to set the date datatype on both side of the if-else. did u got? with regads sanram By: C-Box - c-box RE: Date Parameter Problem 2005-06-10 05:54 I guess Alan meant to build up the WHOLE query string OUTSIDE the report and pass it completely inside the JasperReport when calling the fillmethod... so you could easily prepare the query depending your needs... so if your FromDate is null you could let drop your part with the date in the where-clause otherwise you could use it as it is... something like that (not valid java - just pseudo-code) String myquery = new String(); if (fromDate.equals(null)){ myquery = "SELECT * FROM TABLEXYZ WHERE FieldOne = "ABC*")} else{ myquery = "SELECT * FROM TABLEXYZ WHERE FieldOne = "ABC*" AND FieldDate > fromDate) } HashMap paraMap = new HashMap(); paraMap.put("QueryString",myquery); JasperPrint jp = JasperManager.fill(jasperReportObject,paraMap,connectionObject); hth C-Box BTW: I guess you should be careful using java.util.data and java.sql.date... I remember having read some trouble .. but don't remember good.

By: sadsd - micasa Help with JavaBeans datasource 2005-06-07 08:48 I'm trying to use a Javabeans datasource but i'm completly lost. Does someone no where to download a sample of this kind of reports , or how to start using it?. Thank you

By: antobuccia - antobuccia returning parameter from subreport bug? 2005-06-01 01:27 I have (A) master report and (B) subreport. In B I search a value that I using in A in a calculation. When B found a value in A all ok. When B reutrn null in A i view a last value of B. It's seems a latch effect. I have try with reste group ext but nothing! My work around is that query in B take ever 1 record using a UNION ALL and refining with rowcount = 1 when records are 2. It is a possible BUG? By: Giulio Toffoli - gt78 RE: returning parameter from subreport bug? 2005-06-01 16:41 subreport values return are performed as a trick, hard to say this is a bug or simply if the trick don't work in this case. Gilio By: kootjekip - kootjekip RE: returning parameter from subreport bug? 2005-06-06 02:55 It's kind of a bug but not in iReport but in Jasperreports. I don't know why we need to use a workaround, this feature had to be implemented in JasperReports long ago. But Gulio can't help it, he also has to wait before jasperreports has implemented this feature (Which must be done soon)