2002 JI Open Discussion

By: TesTech - testech API to incorporate subreport in mainreport??? 2005-10-25 02:08 Is there any API for incorporating the subreport in main report ? pls tell us about that API and the jar where the API is present.

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: 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: SweetCreek - sweetcreek I need an iReport Programmer! 2005-12-13 17:57 I need two reports created using iReport, and I don't have the time to learn to do it myself. So I need someone to do it for me. Any help in finding someone capable of such a thing would be greatly appreciated. By: zac - zemerli RE: I need an iReport Programmer! 2005-12-30 10:30 You are the most welocome. How can I reach you?

By: Shammi Hettiarachchi - shammif2 New tutorials 2005-12-15 09:50 do any one know about new ireport tutorials regarding to IReport 0.5.0 and above. do any one willing to share a copy of ultimate user manual for free. if you have the manual why dont you make a good tutorial(s) out of it. specially sub-reporting

By: akalehzan - akalehzan MS SQL SERVER jdbc.sqlserver error 2005-12-08 12:25 Hi All, I just installed iReport tool on MAC OSX 10.4 and tried to connect MS SQL server from Connection prosperities, but I'm getting error" ClassNotFoundError:" Check your class path! Which file I need to add the class path and what should I add in that file? Thanks in advance, Abrahim By: Sherman Wood - sgwood RE: MS SQL SERVER jdbc.sqlserver error 2005-12-09 06:37 The drivers can be downloaded here http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&displaylang=en You will need to put the following JARs on your classpath: msbase.jar mssqlserver.jar msutil.jar Also there is the jTDS open source driver that connects to MS SQL Server and Sybase at: http://jtds.sourceforge.net/ Sherman JasperSoft

By: hyzom - hyzom groovy compiler overrides a final method 2005-11-08 01:23 I tried iReport 0.5.2 under jdk 1.5 update 5 on suse 10.0. when I compile reports using groovy as the default exepression language I get an error from the class loader saying that the Groovy compiler overrides a final method. I tried it on WindowsXP and got the same error message. By: jthevenoux - jthevenoux RE: groovy compiler overrides a final method 2005-12-07 06:12 Same Pb with same report, i have three result : iReport 0.5.0 : All is OK iReport 0.5.1 : error : java.lang.NoSuchMethodError: net.sf.jasperreports.engine.JRExpression.getName()Ljava/lang/String; iReport 0.5.2 : error : java.lang.VerifyError: class net.sf.jasperreports.compilers.JRGroovyCompiler overrides final method That's not very cool ...

By: Sandeep - skadyan Generate Multilingual Report 2005-11-29 00:50 Hi, I want to generate the report with mulit-lingual support.My problem is that I want to fill the labels (Static-text) field with the translated text (in other language).My transalted text will come from DataBase .But I can not join the Table,which has the transalted text, with in the ReportQuery.Can any one help me filling the transalted text value for the label which I have used in the report. Thanks Sandeep By: ODIM - odim RE: Generate Multilingual Report 2005-12-06 09:54 Hi, it´s better to use Textfields, because you can work there with fields ($F{..}) or Variables or Parameters ($P{..}). In StaticTextFields you can´t do that. greetz ODIM

By: allfonsaravanan - allfonsaravanan problem with line graph 2005-11-28 03:48 hi folks, i need to mention in line graph x axis as a string in ireport designer tool. it was working those categories(String),series,values in Bar graph.but it is not working on line graph.i m getting the exception Numberformat exception.cause i m giving y axis as a string format.y it cant take as string in line graph ..but it took as in bar graph.i need explanation ....and i need to call a proceduire from Oracle data base...not for SQL Server.

By: Jhonny Bravo - ac48 calling SP containing Temp table in IReport 2005-11-09 06:17 hi folks i m trynig to call a stored procedure using IReport and there is no problem with that and the procedure gets called .... but if that procedure has a temporary table then I cannot get the records in my Report.... So if any one of you have tried the same plz let me know thanx in advance By: TesTech - testech RE: calling SP containing Temp table in IReport 2005-11-10 23:04 hi , Check whether the SP is actually returning any records ? call the procedure with the required parameters. For example if ur using SQL server exec <procedure name> <parameters> if the above stmt returns any record , then it will be reflected to Report wizard. thats all my suggestion abt. Regards Varun Chakravarthi T By: allfonsaravanan - allfonsaravanan RE: calling SP containing Temp table in IReport 2005-11-28 03:39 i m trynig to call a stored procedure using IReport and there is a problem with that and the procedure have to call from oracle database not from sql server...can any one tell me abt that ...how to call procedure with parameter from ireport?.

By: mauricio cordero - maucorpat2 org.apache.xpath.XPathException 2005-07-11 03:47 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> some curious is: If I change the """field description= /GLOBAL/DAY/usrsAuthenAvg."" from the data connection. otherwise if I change the simbol "+" for "/", no apear error when I run the repor from the iReport. But show the report wrong, since it shows the first data (DAY) twice without showing the second DAY. Please help me. I try for two days And I cant found the solution. Oscar from spain. By: Wal Millard - walmillard RE: org.apache.xpath.XPathException 2005-11-23 14:14 Ur xpath statement is incorrect. the + is the probelm i suggest you remove it and set your description to just simply usrsAuthenAvg and your xml datasource expression to /GLOBAL/DAY/ (Note this is all case sensitive) XPath Builds on your Expresion, so at runtime the entire expression (the xml datasource path, and the field description part) should look and point to a valid xml tag or attribute. i.e /GLOBAL/DAY/usrsAuthenAvg luck walmillard

By: acpradeep - acpradeep subreport in main report with xml data source 2005-11-02 22:18 when the subreport is embedded in main report with xml as datasource, the subreport is displayed as a seperate entity. There seem to be no relationship betweeen the subreport and the main report. whereas when the database connection is used, the subreport and main report are displayed correctly. can anyone help us please. if there is any API to link subreport with main report please tell us. thanks in advance acpradeep By: Wal Millard - walmillard RE: subreport in main report with xml data so 2005-11-23 14:06 acpradeep, You need to align the request to the xml datasource with both reports. Can you post the SQL v's the XML Expression you are using. walmillard

By: Giulio Toffoli - gt78 iReport 0.5.2 released! 2005-11-04 07:18 The iReport Team is pleased to announce the new iReport release: 0.5.2. The following changes have been made to software since release 0.5.1 Partial support for JasperReports 1.1.0 (crosstabs, styles and frames are not yet supported) Improved log window Fixed all templates Serveral bug fixes and improvements Thanks for your suggestions and your on going support using iReport! Giulio iReport site: http://ireport.sf.net download: https://sourceforge.net/project/showfiles.php?group_id=64348 By: dex wintergreen - wpmadden RE: iReport 0.5.2 released! 2005-11-04 11:35 I tried iReport 0.5.2 on win2K/sun java1.5.0_05 both the binary and compiled I cannot create either a Variable or Parameter, gives NullPointer exception at it.businesslogic.ireport.gui.ValuesPanel.newParameter(ValuesPanel.java:1989) at it.businesslogic.ireport.gui.ValuesPanel.newVariable(ValuesPanel.java:925) anyone else seeing this? By: C-Box - c-box RE: iReport 0.5.2 released! 2005-11-06 05:55 Can't share.... also has 0.5.2 with winXP and Java 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05) so I can create variables and parameters very well - don't know what version you have... I pulled it directly from CVS at november 1st. and don't have those errors. thanks Guilio for the new release ... have you now more time for developing at IReport like Teodor at JasperReports? I've a lot of improvement suggestions yet. :-) C-Box By: Fabio Patricio - fabio_patricio RE: iReport 0.5.2 released! 2005-11-08 08:52 Hi Has some forecast for support crosstab? Best regards Fabio By: bestfriend37 - bestfriend37 RE: iReport 0.5.2 released! 2005-11-17 06:51 hi, i also need support for crosstabs in ireport, since JasperReport already provide this. is there an intention to support this.

By: acpradeep - acpradeep Group By functionality in Jasper Reports? 2005-11-16 01:22 Hi, In crystal reports we have the Group-By funtionality. Do we have the Group By functionality in Jasper Reports? If Jasper Reports is also having the same functionality then please tell me how to use the Group-By functionality in Jasper Reports. Thanking You in advance thanks and regards A. Christopher Pradeep

By: bluerocket - j_simpson Custom Properties 2005-11-15 01:54 Hi, it appears as though iReport rewrites custom properties from xmlEncoded values to their original values which could break the integrity of the Jasper Report. I've only noticed a problem so far with the > symbol being translated to > and < to < so far but it rewrites all other encoded strings as well.

By: Lal V K - lalnec differentiating Odd and Even row in detail 2005-11-10 05:08 HI, I have to differentiate odd and even rows with different color in details section.I would like to know how it could be done..I have tried with detail band Print When Expression.Its only accepting Boolean value.How I could set the color for alternative rows. Pls help me.Its very urgent. Thanks and regds, V K Lal. lalnec@rediffmail.com By: Daren O - rckrll106 RE: differentiating Odd and Even row in detai 2005-11-10 06:39 I created a rectangle in the background and for the print expression I used: new Boolean( ($P{LineColor}.booleanValue()) && (((int)$P{LineSpace}.intValue() / 2) <= ($V{REPORT_COUNT}.intValue() % $P{LineSpace}.intValue()) ) ) note: I add the option to pass in two parameters. LineColor is a boolean to whether to use the color or not. LineSpace is of a multiple of 2 for how many lines to alternate (meaning the value of 2 will color every other line, 4 will color 2 lines, etc..) Might be other ways but that is how I do it. Hope it helps. By: TesTech - testech RE: differentiating Odd and Even row in detail 2005-11-11 01:05 hi .. The above posted solution can be simplified , without any parameters. just copy all the fields in the detail section and paste it on the same location. Choose one color to one set of fields and choose another color for the other set of fields. Now , select one set fields and give the following expression (print when expression)for one set of fields new Boolean((new Integer(($V{REPORT_COUNT}.intValue()) % (new Integer(2).intValue()))).equals(new Integer(0))) and for the other set of fields and give new Boolean((new Integer(($V{REPORT_COUNT}.intValue()) % (new Integer(2).intValue()))).equals(new Integer(1))) Note : All the fields should be in a "Transparent" mode Test this with only one field on details section.So that you can feel easy to set the property for other fields This worked for me ! You try it !! Regards Varun

By: TesTech - testech Last Page Footer ? 2005-11-09 03:44 Hello , Im using iReport - 0.3.0 (JasperReports-0.5.2.jar).I need to display an image only on the last page footer of the report. Is there any way to do this ? (Higher version of jasper might have this feature , but i cant use it , because our customers generated numerous reports on iReport 0.3.0 , they dont want to switch.) Please any one help me !! Thanks Regards Varun

By: Aparna - aparnaswami Subreport got filled only once ?? 2005-11-05 04:28 Hello , Im using iReport0.4.1 for generating jasper reports. I got a problem on sub report. Im passing the datasource(of subreport) through a parameter from mainreport. But the subreport got filled only once. For Example : If I placed the subreport in the PageHeader of MainReport, the subreport got filled only on the first pageheader of MainReport.Its not filled on the second , third etc., pages of the main report.(A blank sub report is displaying without any data).This problem is repeating on all the bands. How to overcome this .Is there any settings has to done on iReport Editor? Any one please help me ! Its very urgent issue ! Thanks in advance Aparna

By: Kostas Michailidis - mkostas_gr Attn: Mr.Danciu 2005-11-01 07:01 A bookmarks list viewer inside the JRViewer would be very usefull. thank you Kostas Michailidis

By: Peter F. - pe_f JGoodies Looks Update? 2005-10-27 04:26 Hi, Karsten Lentzsch updated his JGoodies looks library to version 1.3.2. Could you update the looks library in iReport, too, since Karsten made a change in the naming of the packages (replaced plaf with looks) with version 1.3.*. This prevents a simple exchange of the jars. TIA! cu Peter

By: jmarandall - jmarandall Adding JDBC drivers 2005-10-18 10:55 I'm new to iReport. The mySql driver is the only one that comes standard with the software. Where can I get the Oracle JDBC driver and how exactly do I make it appear in the JDBC Driver drop-down list? Thanks in advance. By: Kevin - eventronix RE: Adding JDBC drivers 2005-10-26 12:46 Im not sure where you get the driver for orical, try google, but you can just type it into the field

By: casey - fckoffdude Support for JasperReports 1.1.0 2005-10-26 04:58 When will iReport support JasperReports 1.1.0?

By: TesTech - testech API to incorporate subreport in mainreport??? 2005-10-25 02:08 Is there any API for incorporating the subreport in main report ? pls tell us about that API and the jar where the API is present.

By: TesTech - testech SubReport using datasource 2005-10-20 21:44 hi , Thanks for every one for giving this support !!!! I am using xml datasource for launching the reports. and i am comfortable with that. Now , I need to embed a subreport with in the main report using xml data source. Can any one give me any idea about this? Thanks & Regards testech

By: ccatindia - ccatindia need help in Hyperlink 2005-10-12 12:02 Dear Friends, I want to use the hyperlink property in iReport. I gave the property details.I gave the another reports path at the "Hyperlink Reference Expression".When i'm viewing the report in JRViewer i cannot get the referenced report,But i can see the tool tip text as the reference that i entered. Anyone please help me.... Balaji