2002 JI Open Discussion

By: C-Box - c-box "OpenFile" Method of MainFrame returns null 2004-12-02 07:24 Hi Giulio, I'm still developing my database-plugin for iReport... I use the method "openFile" of mainframe to load my reports from database into iReport. But now I need the JReportFrame that actually should get returned by that method. But when I looked at the source I encountered that it returns NULL when I open the report for the first time: could you please change that method to the following: public JReportFrame openFile(File file){ JReportFrame reportFrame; reportFrame = findReportFrameByFile(file); if( reportFrame == null ){ try { Report report = new Report(file.getPath()); report.setUsingMultiLineExpressions( false ); //this.isUsingMultiLineExpressions()); openNewReportWindow( report ); reportFrame = findReportFrameByFile(file); // that's the new line... so the returnvalue isn't null at the first call for the report -> it's just the simplest thing I found within one minute ... perhaps you have another idea that is much better. } catch (Exception e ) { logOnConsole( e.getMessage() + "n" ); } } else { setActiveReportForm(reportFrame); } return reportFrame; } Does it influence any other methods you're using? tia + greetings from quite cold Germany C-Box By: C-Box - c-box RE: "OpenFile" Method of MainFrame returns nu 2004-12-02 07:57 ... just a question yet, i temporarily solved the problem above with calling the "OpenFile" method twice.... so I get the JReportFrame.... but now I stored the JReportFrame-Object within my "DBPluginReport-Object" (has some additional information from database) and want to activate it in iReport (from a JTree within my plugin-form).... therefor I tried the methods _iReportMainFrame.setFileListActivatedFrame(rep.getIReportFrame()); and/or _iReportMainFrame.setActiveReportForm(rep.getIReportFrame()); both methods don't bring the needed Report to the front, just move it in the FileTree to the active one... but how can I set the JReportFrame ACTIVE that I can see the report-layout directly.... (bringToFront also doesn't work).... ??? (I load a kind of set of reports (like your Project that's not yet implemented) and I see the last report that was loaded from database in iReport.) thx in advance again C-Box PS: I'm using 0.4.0 By: Giulio Toffoli - gt78 RE: "OpenFile" Method of MainFrame returns null 2004-12-02 10:01 Hi C-Box 1. call OpenFile twice is bad but safe. Anyway now should works (I fixed and versioned, now OpenFile return the JReportFrame correctly). 2. To activate a report simply: JReportFrame youReportFrame; youReportFrame..setSelected(true); Ciao! Giulio P.S. 0.4.1 in CVS use JR 0.6.3 By: C-Box - c-box RE: "OpenFile" Method of MainFrame returns nu 2004-12-03 05:07 Hi Giulio, thx for your reply. It works fine now. (I still call the method twice yet - because I wait till 0.4.1 is ready). The "setSelected(true)"works also fine. What I would like to introduce in your PluginArchitecture is just an additional boolean attribute in the Plugin.xml that is called for instance. "AutoStartPlugin" and when you load the plugins at the LAST action after iReports start-routine you can call the plugin class it that attribute is set to true. What do you think about it? thx + have a nice weekend C-Box By: C-Box - c-box RE: "OpenFile" Method of MainFrame returns nu 2004-12-13 03:47 Hi Giulio, I'm still building my DataBasePlugin for IReport.... and I now tried to add a Button into your panelToolbar .. but I found out, that it's not as easy as I thought this morning.... :-( You built a vector with all that elements within... so that vector is private.... so I can't add a new Button by myself... so perhaps you could make that vector public or even better... build a simple addMethod to extend the Toolbar... or even yet better allow a plugin to add a own toolbar (that is placed after your formatToolbar).... what do you think... is that manageable? greetings C-Box By: Giulio Toffoli - gt78 RE: "OpenFile" Method of MainFrame returns null 2004-12-13 15:34 It's possible. The best is put a button on the main toolbar with a function like: addToolbarComponent(JComponent component) About plugin: no problem for the autostart. I'll add it. Giulio By: C-Box - c-box RE: "OpenFile" Method of MainFrame returns nu 2005-02-01 08:01 Hi Giulio (once more :-)) thx for the "loadOnStartup" feature and the repaired "openFile" method. Works great since 0.4.1. But I guess you didn't find time to implement the "addToolbarComponent" method we discussed above, to add a Button into the mainToolbar, isn't it?!? Will you "waste" another 10 min. on thinking about that public method? I'd love it! tia + greetings again from quite uncomfortable Germany C-Box

By: C-Box - c-box IReport 0.4.0 & WebStart & Plugins 2004-10-22 06:31 Hi Guilio, I'm back from holiday and I've just a question again. :-) We want to start IReport with WebStart.... that we got to run... problem now is... that we can't use my new plugin I wrote for IReport, because there isn't any directory structure with webstart. When I start IReport from a directory where a PlugIn-Directory with my XML-File within exists, then it works very well, but we don't have all access to that directory and want to use WebStart instead. So my question to you is, if you could read the pluginsettings (class, name, icon) via startparameter when starting the mainframe so that we could put the plugin for example in a jar. Or perhaps the XML-File that contains the pluginsettings could be given via parameter to iReport. count on you + hoping for your ideas + greetings from sunny Germany C-Box By: Giulio Toffoli - gt78 RE: IReport 0.4.0 & WebStart & Plugins 2004-10-27 02:07 Perfect. C-Box, can you write some guidelines about how to start iReport using JWS? I want add a chapter in the iReport manual about it. Thanks. Giulio By: C-Box - c-box RE: IReport 0.4.0 & WebStart & Plugins 2004-11-04 07:32 Well, at the moment it's not the best solution.... because the plugin-xml-file MUST be located in the plugin-directory of iReports current directory.... that's why we use a trick... we packed the iReport-directory with all needed libs and plugins into a zip and that zip into the webstartarchive... then we build a loader that just unzippes the iReport in the lokal user temp-directory and start the mainframe of iReport that works so far and is necessarry because of the (yet) "missing plugin-via-parameter-architecture". But if you will implement that feature we discussed above, then you get a manual how we do it (and is a cleaner solution than that we did now). :-) greetings from Germany C-Box By: Giulio Toffoli - gt78 RE: IReport 0.4.0 & WebStart & Plugins 2004-10-26 02:17 This is a problem. We must remove the file system dependency. An idea is add a java system property (or a command line option) to list all plugin descriptors to load (plus all plugin descriptors present in plugin directory if accessible). A property (or command line option) like this: ireport.plugins = /it/businesslogic/ireport/pluginA.xml,/com/you/company/pluginB.xml What do you think? Giulio By: C-Box - c-box RE: IReport 0.4.0 & WebStart & Plugins 2004-10-26 22:58 Yes, that would be fine and much more flexible. I guess it's not too much work and the existing plugin-architecture still keep working with filesystem. Good work with you... keep going on. greetings from rainy Germany C-Box BTW: thanks for the "AlignToolbar" ... it's just great and almost 100% like I imagined. :-) By: Kees Kuip - keeskuip RE: IReport 0.4.0 & WebStart & Plugins 2004-11-13 05:57 Hi Giulio, Here's another idea: - The plugin xml should always have the same name! Let's call it : "ireport/plugin.xml" - This file should be included in the jar file which contains the implementation of the plugin. - Multiple jar-files can now include the file "ireport/plugin.xml" (ofcourse with a different content) - You can read all plugin-files from the classpath with the method : object.getClassLoader().getResources("ireport/plugin.xml") This will return an Enumeration of all resources with that name on the classpath. - Now all you have to do to include your own plugin is to put your jar-file on the classpath. You don't have any other configurations. Kees Kuip. By: C-Box - c-box RE: IReport 0.4.0 & WebStart & Plugins 2004-11-15 01:31 Sounds great and is much simpler than going the way via parameter. What do you think Guilio, are there any 10 minutes left to include the Kees's way into 0.4.1? have a nice day C-Box By: Giulio Toffoli - gt78 RE: IReport 0.4.0 & WebStart & Plugins 2004-11-15 08:24 Kees you are the best! Cool cool cool Giulio By: C-Box - c-box RE: IReport 0.4.0 & WebStart & Plugins 2005-01-26 23:08 HI Giulio, I just read that you'll publish 0.4.1 in the next 2 to 3 days. That's great, I'm looking forward to this. I looked at the current version of mainframe.java... can you integrate the plugin loading technique that keeskuip wrote down in this thread to load additional plugins via Webstart also? Would be great. greetings from a very cold Germany C-Box By: Giulio Toffoli - gt78 RE: IReport 0.4.0 & WebStart & Plugins 2005-01-28 01:31 implemented in 0.4.1 :-) Tested using webstart. Giulio By: C-Box - c-box RE: IReport 0.4.0 & WebStart & Plugins 2005-01-28 01:56 Thanks a lot! Great work with you! I'll download and test it right now! :-) Have a nice weekend! Greetings from still very cold and winter Germany C-Box Post edited by: tcloonan, at: 2006/09/02 10:14

By: Giulio Toffoli - gt78 iReport 0.4.1 Released 2005-01-28 01:32 iReport 0.4.1 Released January 28, 2004 ------------------------------------------------ Full support for JasperReports 0.6.4 Support for report localization Support for box tag Support for JDT, BeanShell and Jikes compilers Several bug fixes and improvements It's now available the new commercial manual (English, 180 pages). Download: https://sourceforge.net/project/showfiles.php?group_id=64348 Manual: http://ireport.sourceforge.net/docs.html

By: Kumaran - kumaran_rao My Problem in scriptlet 2005-01-10 04:42 I need a help from you , I am using iReport version 0.4.0 where i cannot use the scriptlet class . How to use the internal iReport scriptlet. when i compile the class i am getting classcastException ... Give me an idea of overriding the methods in the internal ireport scriptlet using the tool iReport version 0.4.0

By: PierreVassal - pierre-vassal Multiple DB request 2005-01-05 01:41 Hello, When it will be possible to have multipe SQL requests for the same report ? It is the only point which missing to make this tool professionnal (from my point of view). Thanks, Pierre

By: BJ Freeman - bjfreeman Tools Jar 2005-01-01 11:27 I notice that Tools jar is included. If you are interested I can provide a routine you an put in the properties to find tools.jar in the sdk, assuming is it installed. I say this becuase on the network different workstation have different versions of the SDK. some tools jars don't work with other versions.

By: BOURGOUIN - bourgoui JVM crash 2003-05-16 00:33 hello, I'm using JasperReports 4.5 with windows 2000 SP2 and a jdk4.1 and I'm faced with jvm crash. The message of the crash is the following: Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x6D3CE26A Function=JVM_FindSignal+0x17C1C Library=X:j2sdk1.4.1_01jrebinclientjvm.dll **************** Current Java thread: Another exception has been detected while we were handling last error. at java.lang.Throwable.fillInStackTrace(Native Method) Dumping information about last error: ERROR REPORT FILE = (N/A) PC = 0x6D3CE26A at java.lang.Throwable.<init>(Throwable.java:180) SIGNAL = -1073741819 at java.lang.Exception.<init>(Exception.java:29) FUNCTION NAME = JVM_FindSignal at java.lang.RuntimeException.<init>(RuntimeException.java:32) OFFSET = 0x17C1C LIBRARY NAME = X:j2sdk1.4.1_01jrebinclientjvm.dll at java.lang.NullPointerException.<init>(NullPointerException.java:36) Please check ERROR REPORT FILE for further information, if there is any. Good bye. at dori.jasper.engine.fill.JRCalculator.evaluate(JRCalculator.java:678) Java Result: 1 This problem happens randomly. I've tried others jdk version (1.4.1_01 and 1.4.1_02) but the problem still persist. Is it a bug of JasperReports. If anybody can help me, I will appreciate. thanks, Jeremy By: schroffd - schroffd RE: JVM crash 2003-05-16 00:40 I've posted a similar question to the support mailing list, but without any response. https://sourceforge.net/tracker/index.php?func=detail&aid=702128&group_id=36382&atid=416704 Does anyone has an idea? By: Albert L. - looks RE: JVM crash 2003-05-17 00:28 I've encountered this problem before, but only when I use jdk 1.4.2 beta. As soon as I remove 1.4.2 beta and reinstall 1.4.1_02, there is no such error. To be sure, have tested it time - remove/install between 1.4.2 beta and 1.4.1_02 stable - this problem always occur on 1.4.2 beta jvm. I'm using JasperReports 0.4.6. By: Albert L. - looks RE: JVM crash 2003-05-17 00:31 To be sure, have tested it a few times - remove/install between 1.4.2 beta and 1.4.1_02 stable - this problem always occur on 1.4.2 beta jvm. By: BOURGOUIN - bourgoui RE: JVM crash 2003-05-19 00:14 I 've never installed jdk 1.4.2 beta on my computer, and the problem happens randomly with the jdk 1.4.1_02. If anyone has another suggestion, it would help. thanks, Jeremy By: Chris Green - c_g12 RE: JVM crash 2003-05-28 11:16 Yep I got this too, using jdk 1.4.1_02 Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x6D3DE3FE Function=JVM_FindSignal+0x17BD4 Library=jvm.dll Current Java thread: at java.lang.Throwable.fillInStackTrace(Native Method) at java.lang.Throwable.<init>(Throwable.java:180) at java.lang.Exception.<init>(Exception.java:29) at java.lang.RuntimeException.<init>(RuntimeException.java:32) at java.lang.NullPointerException.<init>(NullPointerException.java:36) at dori.jasper.engine.fill.JRCalculator.evaluate(JRCalculator.java:678) **************** Another exception has been detected while we were handling last error. Dumping information about last error: ERROR REPORT FILE = (N/A) PC = 0x6D3DE3FE SIGNAL = -1073741819 FUNCTION NAME = JVM_FindSignal OFFSET = 0x17BD4 LIBRARY NAME = jvm.dll Please check ERROR REPORT FILE for further information, if there is any. Good bye. By: Dan Dubinsky - dandubinsky RE: JVM crash 2003-07-03 11:22 I got the same error using JDK 1.4.0 and JDK 1.4.1_02. For me, the problem appears when I call: JasperPrint pr = JasperFillManager.fillReport(JasperReport,Map,DataSource); three or four time with the same report object, but a different Datasource. Anybody have any idea what to do? This puppy is a real show stopper. By: Albert L. - looks RE: JVM crash 2003-07-03 13:11 Hi, I've managed to solve my JVM crash issue. However, it may not apply to all related JVM crashes, as mine specifically crashed 1.4.2 (both beta and the official release) but not 1.4.1 (all sub version 02,03 is ok too). In summary, my JVM crashed was due to my code calling System.gc() too often (after printing each report, trying to free resources asap). For my case, when the JVM crashed, it does not show a Library reference on the crash message. But it does show some common messages, such as : .. Good bye. at dori.jasper.engine.fill.JRCalculator.evaluate(JRCalculator.java:678) As soon as I remove the code calling System.gc(), the 1.4.2 JVM performs solidly - without a single JVM crash. But it does show at least one 'out of memory' instance during my stress test, which probably won't happen in real use (I hope). If your code calls System.gc() at all, try removing it and see if it helps. Anyway, 1.4.2 handles gc internally better than 1.4.1, so I don't really need to call it manually, but still funny, calling gc can crash the JVM. Albert By: Dan Dubinsky - dandubinsky RE: JVM crash 2003-07-09 08:52 I think I may have found the solution to the problem. In the methods dori.jasper.engine.fill.JRCalculator: evaluate(JRExpression expression) and evaluateEstimated(JRExpression expression) evaluateOld(JRExpression expression) The code looked like this (with slight variations for each method) try { value = this.evaluate(expression.getId()); } catch (NullPointerException e){} catch (Exception e) { throw new JRException("Error evaluating expression value : " + expression.getName(), e); } I changed it to try { if (expression != null) value = this.evaluate(expression.getId()); } catch (Exception e) { throw new JRException("Error evaluating expression value : " + expression.getName(), e); } and it stopped blowing up. I think it might be that too many exceptions being thrown (expression appears to be null quite a lot of times in each fill) and too many stack traces are causing the VM to wig out. Is it possible to get this fix into the next release of Jasper Reports? By: Teodor Danciu - teodord RE: JVM crash 2004-04-30 03:18 Hi, Try to launch your JVM using the -server command line switch instead of the default which is -client. Thank you, Teodor

By: Theo Heinrichs - theofrombonn Memory leak when filling/printing large rpts? 2003-02-08 00:41 Hello, I am printing multiple large reports (about 43 pages each). My platform is Win XP with JDK 1.4.1, jasperreports 0.4.5. The system gets slower and slower after each printing. When I look at the memory usage, I see that each rpt is keeping its memory, filling up the main mem and finally giving OutOfMemory errors. I am using a large sub-report which can not be replaced by other constructs. I am using custom data sources (no SQL etc). Please advice where to search or what to change. Is there a chance to "reset" the whole printing system (something like unloading all data, like a cleanup function)? Regards, Theo By: Ryan Johnson - delscovich RE: Memory leak when filling/printing large rpts? 2003-06-24 16:38 BTW, Even for a simple report with only one detail row, my memory use rises by ~2MB and never goes back down By: Ryan Johnson - delscovich RE: Memory leak when filling/printing large rpts? 2003-06-24 16:34 I'm getting the same problem. Sometimes the JVM itself actually crashes: Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x6D3CF979 Function=JVM_FindSignal+0x186C6 Library=C:Program FilesJavaj2re1.4.1binclientjvm.dll Current Java thread: at java.lang.Throwable.fillInStackTrace(Native Method) at java.lang.Throwable.<init>(Throwable.java:180) at java.lang.Exception.<init>(Exception.java:29) at java.lang.RuntimeException.<init>(RuntimeException.java:32) at java.lang.NullPointerException.<init>(NullPointerException.java:36) at dori.jasper.engine.fill.JRCalculator.evaluate(JRCalculator.java:678) **************** Another exception has been detected while we were handling last error. Dumping information about last error: ERROR REPORT FILE = (N/A) PC = 0x6D3CF979 SIGNAL = -1073741819 FUNCTION NAME = JVM_FindSignal OFFSET = 0x186C6 LIBRARY NAME = C:Program FilesJavaj2re1.4.1binclientjvm.dll Please check ERROR REPORT FILE for further information, if there is any. Good bye. By: Teodor Danciu - teodord RE: Memory leak when filling/printing large r 2004-04-30 03:16 Hi, Try to launch your JVM using the -server command line switch instead of the default which is -client. Thank you, Teodor

By: Yuriy Stepanyuk - ystep sharing violation on .xls report 2003-03-14 10:30 Hi. After .jrprint converted to .xls I can not delete .xls file because of sharing violation exception. With all other formats including .csv I do not have any problem. Hear is my procedure: public void SaveAsXLS()throws Exception{ File sourceFile = new File (getAbsReportFilePathNoType()+".jrprint"); JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile); File destFile = new File(getAbsReportFilePathNoType()+".xls"); JRXlsExporter exporter = new JRXlsExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString()); exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporter.exportReport(); }; Is it a bug? Or I am doing something worng. Thanks Yuriy By: Teodor Danciu - teodord RE: sharing violation on .xls report 2004-04-30 03:13 Hi, This was probably a bug. Try a newer version of JR. Thank you, Teodor

By: tone zalokar - tonez0 computing variables within groups?bug? 2003-05-26 04:03 Problem description: I have report contains three groups. First variable I calculate (number in detail band, which repeats minus sum of another numeric field in detail band for specified group). This number is calculated correctly (variable name RPT_SALDO). How ever when i try to sum RPT_SALDO in higher group I' ve got wrong results. VRED01 ZNESF 112.233,00 2.311,54 '' 113.265,46 group1 -3.344,00 - RPT_SALDO group2 106577.46 - RPT_VP_SALDO group3 216498.92 - RPT_SM_SALDO RPT_SALDO=VRED01-ZNESF_SUM ZNESF_SUM=SUM of ZNESF RPT_VP_SALDO=SUM of RPT_SALDO RPT_SM_SALDO=SUM of RPT_SALDO I have tried variable posibilities, even with scriptlets and got wrong results. How ever have already make more then hundred reports but until now we haven't have request like this. ps. I've made a solution with subreports but preformance in theat case have been decreased more than we coul except. 2 minutes(wrong results) to 15 minutes. By: tone zalokar - tonez0 RE: computing variables within groups?bug? 2003-05-27 01:33 for better understanding detail VRED01 ZNESF ---------------------------------- 112.233,00 2.311,54 112.233,00 113.265,46 end detail group1 footer: -3.344,00 - RPT_SALDO correct result group2 footer: 106.577,46 - RPT_VP_SALDO wrong group3 footer: 216.498,92 - RPT_SM_SALDO wrong ZNESF_SUM=SUM of ZNESF RPT_SALDO=VRED01 - ZNESF_SUM RPT_VP_SALDO=SUM of RPT_SALDO RPT_SM_SALDO=SUM of RPT_SALDO By: Teodor Danciu - teodord RE: computing variables within groups?bug? 2003-05-27 03:12 Hi, I think this can be achieved using scriptlets, as it seems that you have to add to the sum only on group breaks. Make sure that you have calculation="System" for those report variables that you calculate using the scriptlet class. I hope this helps. Teodor By: Mohamed Kreifeur - moh2100 RE: computing variables within groups?bug? 2004-04-27 11:55 Hi I have the same problem a while age. the problem of summing subgroup fields. I remember have emailed Teodor and he didn't answer me correctly. Did you find a solution for that or is there a new version of jaspereport that fix this lack (or using the running total features as the Crystal report does). Thanks a lot Moh

By: Ryan Fruit - rfruit Multiple page report 2003-11-03 12:44 Is it possible in Jasper Reports to have a multiple page report? I have a report with too many columns to fit on a landscape oriented page, so I need each row of the report to span 2 or more pages. Anyone know a way to do this? I tried simply making a large page but when I print the PDF it either shrinks it and makes it unreadable or it truncates the part that is off the page. thanks. By: sunnf - sunnf RE: Multiple page report 2004-04-27 04:02 i want to know!

By: Betuca Buril - betuca multivalue parameter 2003-03-13 13:22 Hello people! I was trying to use Jasper with Ireport and i?ve got some questions. When i use a database connection with a SQL select it works realy fine. I used a field on the IReport toll ($F{field_name}). In another java class i needed to use a list of parameters, but i cant make it work. Does anyone knows how can i put on the report an Array( collection, list, ...) on a parameter? Thanks for your help By: Teodor Danciu - teodord RE: multivalue parameter 2003-03-13 13:40 Hi, This smells like subreports combined with JRBeanCollectionDataSource. You can pass your collection as a parameter, but you need a subreport to iterate on it and generate some output in the master document. Check the "subreport" and the "datasource" samples. I hope this helps. Teodor By: Enrico Goosen - enricogoosen RE: multivalue parameter 2003-03-13 22:59 Further to what Teodor wrote... Remember to set the parameter class to "java.lang.Object". Then cast it to the appropriate Type. In my report I pass a HashMap as a parameter. I've got a scriptlet that uses the HashMap to display totals in the Summary section of the report. This might be useful in your case...if so, check out the scriptlet example, in the samples section. Regards, Enrico By: Betuca Buril - betuca RE: multivalue parameter 2003-03-17 12:19 Thank you guys! After your help a I made it work! thanks again! Betuca. By: Jonathan - jtoczek RE: multivalue parameter 2004-04-22 07:03 I have the same problem...how you solve? thanks

By: Arun Kumar PG - pgarunkumar Not getting "Summary" at end of a page! Help! 2003-12-30 02:56 Hi all! Can any 1 tell me how to get the summary section at the bottom of a page. Actually, I have a design where I have a detail band and after that I have a summary band. The problem is that when the Detail does not contains anything the summary band rises above the bottom of the page and therefore a gap is created between the botton of the page and summary. It looks awkward! Here is how the page looks: ------START REPORT------ _________________________ Page header _________________________ Group A _________________________ Detail _________________________ GROUP A FOOTER (This a line) _________________________ SUMMARY _________________________ --------END REPORT------ GAP COMES HERE when no detail present (it looks awkward!) _________________________ PAGE FOOTER _________________________ What I want is this: ------START REPORT------ _________________________ Page header _________________________ Group A _________________________ Detail _________________________ GROUP A FOOTER (This a line) _________________________ GAP CAN COME HERE if no detail is present (Itz okie) _________________________ SUMMARY _________________________ PAGE FOOTER _________________________ ------END REPORT------ Can any 1 tell me how to get rid off the first type of Report shown above! Thankz in advance Arun By: Teodor Danciu - teodord RE: Not getting "Summary" at end of a page! Help! 2003-12-31 06:23 Hi, This can only ba achieved using a trick like the following: Place your summary elements in the page footer at a negative Y coordinate so that they actually appear above the top of the page footer. Use their <printWhenExpression> based on a boolean flag to suppress these elements on all pages except the last. To indicate that the report generation reached the last page, use an invisible element (white line) in the actual summary section that would have a dummy <printWhenExpression> of its own whose only purpose is to set your last page flag to true. I hope this helps. Teodor By: rflair - rflair RE: Not getting "Summary" at end of a page! Help! 2004-04-14 05:22 Hi! I don't understand the end of the text : "a dummy <printWhenExpression> of its own whose only purpose is to set your last page flag to true" what is "dummy <printWhenExpression>" and how can it mark the end of report? thanks!

By: XiaoQiangYang - fatmole Chinese data from database display incerrect 2003-06-24 01:32 My database is sqlserver2000. I retrived Chinese data from sqlserver database on Winnt,but it display incerrectly. Chinese static text in report display cerrectly. My setting as followed, pdfFontName="STSongStd-Light" pdfEncoding="UniGB-UCS2-H" Pdf,htnl.xls have same errors. How to resolve these errors By: XiaoQiangYang - fatmole RE: Chinese data from database display incerrect 2003-06-26 00:44 Chinese data display correctly after changed jdbc driver . By: mouyuan - muyuan11 RE: Chinese data from database display incerrect 2004-03-30 18:10 what driver are you useing?Microsoft or Sybase?which version?

By: Michel - micheljr Error when generating PDF in Websphere 2003-05-16 06:46 I'm using Websphere/Windows and the log error message is: com.ibm.servlet.engine.srt.WriteBeyondContentLengthException Note: when I run my App using JBoss, everything works well. This is a short piece of my code (printPDFDoc.jsp): byte[] bytes = JasperRunManager.runReportToPdf( reportFile.getPath(), parameters, ); response.setContentType("application/pdf"); response.setContentLength(bytes.length); response.setHeader("Cache-Control", "no-cache"); ServletOutputStream ouputStream = response.getOutputStream(); ouputStream.write(bytes, 0, bytes.length); ouputStream.flush(); ouputStream.close(); Any ideas??? Thanks in advance By: Teodor Danciu - teodord RE: Error when generating PDF in Websphere 2004-03-30 11:35 Hi, I think this is a Websphere related problem. I have searched with Google and found something here: http://www.snug.nl/home/newsletter.nsf/0/dc271ce69590ae08c1256d5e0059ab3a?OpenDocument I hope this helps. Teodor

By: mike w - mwans Closed Statement Error 2003-05-27 12:41 Hello, I am getting the following error and do not know how to solve the problem. 05/27 12:39:05 DEBUG [web-10] DOJ Exception in StatewideCounts: dori.jasper.engine.JRException: Error executing report query : SELECT * FROM (SELECT SUM(ARRC_TOTAL) AS AGENCY_ARRC_SUM FROM VW_STATEWIDE_COUNT_ARRC), (SELECT SUM(MACR_TOTAL) AS AGENCY_MACR_SUM FROM VW_STATEWIDE_COUNT_MACR), (SELECT SUM(RETURNA_TOTAL) AS AGENCY_CC_SUM FROM VW_STATEWIDE_COUNT_CC) java.sql.SQLException: Closed Statement at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6390) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at jrun.sql.JRunPreparedStatement.executeQuery(JRunPreparedStatement.java:68) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:395) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:391) at java.lang.Thread.run(Thread.java:536) NESTED BY : dori.jasper.engine.JRException: Error executing report query : SELECT * FROM (SELECT SUM(ARRC_TOTAL) AS AGENCY_ARRC_SUM FROM VW_STATEWIDE_COUNT_ARRC), (SELECT SUM(MACR_TOTAL) AS AGENCY_MACR_SUM FROM VW_STATEWIDE_COUNT_MACR), (SELECT SUM(RETURNA_TOTAL) AS AGENCY_CC_SUM FROM VW_STATEWIDE_COUNT_CC) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:379) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:395) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:391) at java.lang.Thread.run(Thread.java:536) Caused by: java.sql.SQLException: Closed Statement at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6390) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at jrun.sql.JRunPreparedStatement.executeQuery(JRunPreparedStatement.java:68) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375) ... 4 more By: mike w - mwans RE: Closed Statement Error 2003-05-28 08:54 It turns out I was having issues using the JRUN Statement pool, In case anyone has a similar problem. By: Allan Kos - theincongruent RE: Closed Statement Error 2003-12-18 10:57 Well what was the problem you were having? I now have the same problem. It only occurs after I have tried to view the same report twice. A different report will load properly though even after the first fails. By: Teodor Danciu - teodord RE: Closed Statement Error 2003-12-18 14:32 Hi, The SQL query execution code has been revised in JasperReports. The new version is available on CVS and I suggest you try it to see if your problem persist. Thank you, Teodor By: Allan Kos - theincongruent RE: Closed Statement Error 2003-12-18 15:18 So I have to download each individual file in the src directory and compile myself to get the newest version? (I'm not complaining... i'm just ensuring there isn't an easier way before I continue with this). By: Teodor Danciu - teodord RE: Closed Statement Error 2003-12-18 15:24 Hi, Use a CVS client to get all the project source tree from the CVS repository. http://sourceforge.net/cvs/?group_id=36382 Then all you have to do is to run the available ANT tasks and compile the source files. You can build your own JasperReports jars immediatly. I hope this helps. Teodor By: Allan Kos - theincongruent RE: Closed Statement Error 2004-03-29 10:03 I have upgraded to v0.5.2 with all supporting libs and now get a similar error to what I was getting in December. Was this bug fixed for v0.5.2 or should I go back to my CVS build? After a few days of usage, the JR engine cannot prepare a statement. My WINNT based machine says something about closed statement (forgot to get logs), and my UNIX machine spits the following: ----------------------------------------- java.sql.SQLException: Io exception: Broken pipe at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:182) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:165) at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:604) at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:485) at weblogic.jdbc.pool.Connection.prepareStatement(Connection.java:303) at weblogic.jdbc.rmi.internal.ConnectionImpl.prepareStatement(ConnectionImpl.java:135) at weblogic.jdbc.rmi.SerialConnection.prepareStatement(SerialConnection.java:78) at dori.jasper.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:208) at dori.jasper.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:141) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:444) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:159) at xxx.xxx.xxx.webapp.TpmtReports.ReportGenerator.generate(ReportGenerator.java:146) at xxx.xxx.xxx.webapp.TpmtReports.GetReportServlet.doPost(GetReportServlet.java:145) at xxx.xxx.xxx.webapp.TpmtReports.GetReportServlet.doGet(GetReportServlet.java:47) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) NESTED BY : dori.jasper.engine.JRException: Error preparing statement for executing the report query : SELECT <XXXX> FROM <XXXX> ORDER BY<XXX> at dori.jasper.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:376) at dori.jasper.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:141) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:444) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:159) at xxx.xxx.xxx.webapp.TpmtReports.ReportGenerator.generate(ReportGenerator.java:146) at xxx.xxx.xxx.webapp.TpmtReports.GetReportServlet.doPost(GetReportServlet.java:145) at xxx.xxx.xxx.webapp.TpmtReports.GetReportServlet.doGet(GetReportServlet.java:47) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) By: Allan Kos - theincongruent RE: Closed Statement Error 2004-03-29 10:28 --UPDATE: Looking over my NT machine logs, it appears that it couldn't access the oracle database on the webapp tier. After restarting today I haven't received anymore problems, yet. I got the following exception a number of times... Odd thing was that it happend to both my machines. So in the next couple of days I guess i'll see if the problem was caused by server, db, or JR. --- A connection from pool xxxDataSource was tested with a select count(*) from dual and failed: Fri Mar 26 22:21:55 EST 2004:<I> <JDBC Pool xxxxDataSource> java.sql.SQLException: No more data to read from socket Fri Mar 26 22:21:55 EST 2004:<I> <JDBC Pool xxxxDataSource> This connection will now be refreshed. Fri Mar 26 22:22:04 EST 2004:<I> <JDBC Pool xxxxDataSource> Refreshing a bad pool connection failed: Fri Mar 26 22:22:04 EST 2004:<I> <JDBC Pool xxxxDataSource> weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325) at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:146) at weblogic.jdbc.common.internal.ConnectionEnvFactory.refreshResource(ConnectionEnvFactory.java:175) at weblogic.common.internal.ResourceAllocator.resetThisOne(ResourceAllocator.java:951) at weblogic.common.internal.ResourceAllocator.trigger(ResourceAllocator.java:1493) at weblogic.time.common.internal.ScheduledTrigger.executeLocally(ScheduledTrigger.java:205) at weblogic.time.common.internal.ScheduledTrigger.execute(ScheduledTrigger.java:199) at weblogic.time.server.ScheduledTrigger.execute(ScheduledTrigger.java:60) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129) Fri Mar 26 22:22:04 EST 2004:<I> <JDBC Pool xxxxDataSource> further refreshing postponed. By: Allan Kos - theincongruent RE: Closed Statement Error 2003-12-18 15:44 is there anyway I can replace only the bare minimum classes? (ie: - JRQueryExecuter - JRBaseFill - JRFiller ...etc? I want to keep as much of the sturdy release as possible. If I were to go this route, which files would I need to replace to satisfy the statement issue? Or should I just forget it and take the full new version? By: Allan Kos - theincongruent RE: Closed Statement Error 2003-12-19 08:42 Nevermind, The version from CVS was great. no more statement problems.... seems like the overall process from jasperprint to pdf is speedier too. great work. -Allan

By: Adriana Mestrinelli Paranhos - jasperdri java.io.InvalidClassException??? 2003-04-03 03:57 Hello everyone... when I tried to run my report in the Web, I got this error: java.io.InvalidClassException: dori.jasper.engine.base.JRBaseReport; Local class not compatible: stream classdesc serialVersionUID=405 local class serialVersionUID=402 at java.io.ObjectStreamClass.validateLocalClass(Unknown Source) at java.io.ObjectStreamClass.setClass(Unknown Source) at java.io.ObjectInputStream.inputClassDescriptor(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.inputClassDescriptor(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.inputObject(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at dori.jasper.engine.util.JRLoader.loadObject(JRLoader.java:120) at dori.jasper.engine.JasperRunManager.runReportToHtmlFile(JasperRunManager.java:333) at servlets.teste.service(teste.java:33) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:446) at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:180) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106) at java.lang.Thread.run(Unknown Source) can anyone help me with this error, please?? what does it mean?? thanx a lot By: Allan Kos - theincongruent RE: java.io.InvalidClassException??? 2004-03-29 10:14 you probably need to rebuild the report file using the original report.xml file. If you have upgraded to a newer version of jasperreports but built all your report files using the previous version, this is definately the case. -Allan

By: Barrie Selack - selack setFieldValue in JRAbstractScriptlet 2003-08-11 09:02 I needed access to the data on the report in order to do some field level localization, so I added a setFieldValue. If this would be useful to anyone else, could it be rolled into a future release? Barrie Selack By: bob2000 - bob2000 RE: setFieldValue in JRAbstractScriptlet 2004-03-22 16:49 I'm looking at doing something similar and this would be helpful. By: David Lim - aberrant80 RE: setFieldValue in JRAbstractScriptlet 2004-03-22 18:01 Wouldn't using the expressions directly seem more appropriate and remove the need for a scriptlet? The expression could simply call some class to perform the needed processing.

By: Ricardo Trindade - rjst images in html reports 2003-02-07 04:21 Hi, I'm using the new HTML exporter to generate HTML from a servlet, and it works fine. However, I don't know how to include an image my report has (generated with jfreecharts). thanks Ricardo By: Jerry Shao - shaogang RE: images in html reports 2004-03-17 20:09 Have you found solutions?

By: Krishna S - krishna_s JVM crash -- pls help 2003-01-29 14:40 Hi, Some times JVM crashes w/ the following error dump when running jasper reports. Pls help Thanks Krishna Unexpected Signal : 11 occurred at PC=0x402DDE6D Function=is_native_method__C7nmethod+0x9 Library=/usr/java/j2sdk1.4.1_01/jre/lib/i386/client/libjvm.so Current Java thread: at java.lang.Throwable.fillInStackTrace(Native Method) at java.lang.Throwable.<init>(Throwable.java:180) at java.lang.Exception.<init>(Exception.java:29) at java.lang.RuntimeException.<init>(RuntimeException.java:32) at java.lang.NullPointerException.<init>(NullPointerException.java:36) at dori.jasper.engine.fill.JRCalculator.evaluate(JRCalculator.java:656) **************** Another exception has been detected while we were handling last error. Dumping information about last error: ERROR REPORT FILE = (N/A) PC = 0x0x402dde6d SIGNAL = 11 FUNCTION NAME = is_native_method__C7nmethod OFFSET = 0x9 LIBRARY NAME = /usr/java/j2sdk1.4.1_01/jre/lib/i386/client/libjvm.so Please check ERROR REPORT FILE for further information, if there is any. Good bye. By: Krishna S - krishna_s RE: JVM crash -- pls help 2003-01-29 14:47 I am using Jasper 0.4.3 version Thanks By: Mark Engstrom - me2kme RE: JVM crash -- pls help 2004-03-16 02:45 Hi, Did anyone ever get a solution to this issue ?. Thanks, Mark

By: Umar Khatab - intercitra connect to MySQL database 2003-10-30 19:08 I'm currently trying to run Jasper Report and integrate it with the rest of my Tomcat webapp which has already been working. I've run the JasperReport samples, and they work. Now the problem is that it seem difficult for me to integrate it with the webapp. I have a few questions here. [1] File reportFile = new File(application.getRealPath("/frontpage/report/reports/WebappReport.jasper")); String nama = request.getParameter("name"); String komentar = request.getParameter("comment"); Map parameters = new HashMap(); parameters.put("ReportTitle", "Backend User List"); parameters.put("BaseDir", reportFile.getParentFile()); parameters.put("Name", nama); parameters.put("Comment", komentar); ................ I put two new parameters ("Name" and "Comment") in the sample to test whether they could show up in the report. If I enter the values like I show above, they won't show up in the pdf. parameters.put("ReportTitle", "Backend User List"); parameters.put("BaseDir", reportFile.getParentFile()); parameters.put("Name", "MyName"); parameters.put("Comment", "MyComment"); ................ But If I hardcode the values that way, they'll show up. I've tested that the values are already stored in variables 'nama' and 'komentar'. I've also tested, after putting the values in the Hashmap, to get the values back, and they show up. I use the WebappReport.xml (also from samples). I've put this following lines in the parameters section: <parameter name="Name" class="java.lang.Object"/> <parameter name="Comment" class="java.lang.Object"/> and the textfields as well. Briefly speaking, the values of the parameters can only show up If they're hardcoded. Anyone please point me out and correct my mistake. [2] Please show me how to make a connection to MySQL database. By: supportsib - supportsib RE: connect to MySQL database 2004-03-11 01:30 how did u connect with mysql

By: Julie Bé²µbé­ orlibou IMAGES_MAP 2003-01-31 10:51 In the web app example, Map imagesMap = new HashMap(); exporter.setParameter(JRHtmlExporterParameter.IMAGES_MAP, imagesMap); I would like to put my images in my images folder and name them like logo or graph.... In the example the images are img_1, img_2, etc... thank you! By: sishen - sishen RE: IMAGES_MAP 2004-03-08 11:32 exporter.setParameter(JRHtmlExporterParameter.IMAGES_MAP, "images\"); 'images' being our directory where we store the files. I have no idea why this works but it does !

By: ajay kumar - ajaykumar browser problem with xls output 2003-02-19 20:40 hi friends! iam redirecting to an xls file generated from my jasper servlet..but browser is showing some junk characters.its not invoking excel application in broswer..suggestions are invited in this regard.. ajay ajay@firstgensystems.com By: Thomas Richter - hornet_f4c RE: browser problem with xls output 2003-02-21 07:02 Another point - For the XLS output looks kind of weird. Layout seems not to correct and all lines and images are missing. Pdf was fine ... so instead of running the report to a PdfStream I filled it into a JasperPrint Object to generate the xls from... what's wrong ? By: Manu Karunta - karunta RE: browser problem with xls output 2004-03-03 21:22 Hi, I also got a problem with this, the browser show only junk characters I'm using: JRXlsExporter exporter = new JRXlsExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, sc.getRealPath("/view/report.xls")); exporter.exportReport(); nb: the report.xls file exist and it can be showed in excel application the problem is: the browser can't view the excel report by invoking the excel applocation installed in the OS Any comment or solution? thanks Manu Karunta By: David Lim - aberrant80 RE: browser problem with xls output 2004-03-03 22:18 Well, i don't know about xls not appearing but i do know why there's no images. If you've actually bothered to read the FAQ, you'll see this line: "The Jakarta POI library that we use when exporting the report to XLS format does not currently supports images." By: Manu Karunta - karunta RE: browser problem with xls output 2004-03-03 23:21 The browser only show this: Ðࡱể?;J?;?????????????????????????????????????????????????????????????????????????????????????????????????????????????Ó̇Aá‚°?✰Manu Karunta B?a>=>??>?>=h>>:?#8>X@?">?>Ú‚1È¿?>>Arial1È¿?>>Arial1È¿?>>Arial1È¿?>>Arial1" >?> >SansSerif1"äˆ> >SansSerif1"䈼 >SansSerif1"??> >sansserif"$"#,##0_);("$"#,##0)!"$"#,##0_);[Red]("$"#,##0)""$"#,##0.00_);("$"#,##0.00)'""$"#,##0.00_);[Red]("$"#,##0.00)7*2_("$"* #,##0_);_("$"* (#,##0);_("$"* "-"_);_(@_).))_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)???gt;???gt;?????????? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?gt; ??gt;+???gt;)???gt;,???gt;*???gt; ???gt; ? ?> ? ?> ? ?> ? ?> ? ?> ? ?> ? ?> ? ?> ? ?????????????t;? Sheet1?>>?>PT.Excelcomindo Pratama>Date :>4/3/2004>Time :>14:11:19>Page : >Detail Transaction per-Micro Report>1/3/2000 - 1/3/2007>CA : > Microsuck>>NO. >DATE TIME >SETTLE DATE>TRX TYPE>MSISDN>NAME>AMOUNT>B.CYCLE>CHANNEL>TERM.ID>APP.CODE>PROC.FEE>TRX.FEE>16/01/2004 12:05:42 >19-12-2003>Bill Payment Using Cash >JAUW ERWIN >1,951,124.00>EDC/POS>3,500.00>16/01/2004 12:33:23>19/01/2004 18:42:43>19/01/2004 18:47:24>19/01/2004 18:47:32>19/01/2004 18:49:32>19/01/2004 18:52:02>11/02/2004 16:03:47>12/02/2004 15:28:45>13/02/2004 09:39:08>13/02/2004 10:16:02 >SUB TOTAL >21,462,364.00 >38,500.00>TOTAL>?? ̇? > d>?P?_>*+?>?%????">d>>>,>,>à¿?U} } >>3} ?} V} ×} ? } 3} ?} ?} d} ^} } ?} ?} V} } á…} Û‚} `} } 7} +} 7} } X>} ?} Ù¦gt;} /} ?} G} ×} ×} ?} !!= } ""?} ##×} $$? } %%?} &&l } ''?} (( } ))×} **ë} ++?} ,,?} --?} ..?} //×} 00? } 11 E1>>>>>>>>>>> > > > > ................ Can someone help me?

By: cyril - cyrilgus Problem with Weblogic 7.0 to export Report. 2003-04-03 01:04 Hi everybody, I try to use jasperReport with Bea Weblogic 7.0 to export report to PDF. The line: return JasperExportManager.exportReportToPdf(jasperPrint) doesn't work, it return nothing whereas jasperPrint in not null. Could anyone help me ? Thanks. Cyril By: dturiso - dturiso RE: Problem with Weblogic 7.0 to export Report. 2004-02-17 02:17 I've the same problem, but couldn't find the solution by now. After debugging on Weblogic and a bit more investigation I've found at that the problem is due to the ClassLoaders Bea uses. The problem is that the PDF fonts (iText.jar/com/lowagie/text/pdf/fonts/**) are not loaded by the JRPdfExporter.exportTest(JRPrintText text) method that invokes the JRLoader.loadBytesFromLocation(fontName) method. If you see the code of this latest methos you'll see that different tries of loading the fonts are tries (as a File and with different ClassLoaders). No of them with success. I'm still investigating. If someone finds out the solution, please report the solution By: dturiso - dturiso RE: Problem with Weblogic 7.0 to export Report. 2004-02-17 03:37 Finally, I've found out the problem. In my case it was iReport and its CP1252 vs. Cp1252 pdf font encoding. Try to see if in your *.jasper or *.xml there is a String like "CP1252" (with capital P). In this case replace all the appearences by "Cp1252". See: https://sourceforge.net/forum/forum.php?thread_id=954508&forum_id=113530 Hope it helps

By: Vital - vitalsim Change font size of fields at run-time? 2003-01-07 03:52 I have a report design specified in a XML file. I would like to change the font size of all the fields on my report design at run-time. User would choose the font size that is to be set for the fields. I am using JRXmlLoader class to get the JasperDesign object, but am not sure of how to change the field properties ... Can anybody help me in this regard? Thanks in advance. Vital By: Teodor Danciu - teodord RE: Change font size of fields at run-time? 2003-01-07 04:50 Hi, The best approach would be to not specify the font size for the text elements that required dynamic font size. Instead, you point these text elements to use a report level font definition using the "reportFont" attribute. This will allow you to change the font size by retrieveing the report font definition from the JasperDesign object by calling the getFontsMap() method and using the report font name as key. Then, if you affect the font size in the report font object, all the text elements that make reference to this report font will use the new font size value, but only if they do not override the size as mentioned above. Modifying the font size in the JasperDesign object does not require you to recompile the report design. I hope this helps. Teodor By: Vital - vitalsim RE: Change font size of fields at run-time? 2003-01-07 05:03 Sounds a better approach ... Shall try and let you know the result. Thanks Teodor By: Vital - vitalsim RE: Change font size of fields at run-time? 2003-01-07 06:23 Ok Teodor. Even i shall try for other alternatives and update you if i find one. Thanks, Vital By: Teodor Danciu - teodord RE: Change font size of fields at run-time? 2003-01-07 06:32 Hi, I think in the future we shall introduce the possibility to name the report elements so that you can easily access them by their name when wanting to modify their settings at runtime. Thank you, Teodor By: Vital - vitalsim RE: Change font size of fields at run-time? 2003-01-07 07:16 That should solve most of the issues...i had this question at the back of mind from a long time. Anyhow, thanks for your constant support. Vital By: Vital - vitalsim RE: Change font size of fields at run-time? 2003-01-07 05:46 Teodor, I tried the option suggested by you.. Defined a new report font and applied it to the desired textfields on the report. Though i'm successfull in changing the font size by getting the JRDesignReportFont from the fonts Map, the new font size is not applied to the textfields having this report font. Do I need to set any additional attributes either to the defined report font or the text fields using this font... Following is the reportFont definition: <reportFont name="runtimeFont" isDefault="false" fontName="sansserif" size="5" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="CP1252" isPdfEmbedded="false"/> Static Text using the above report font: <staticText> <reportElement mode="Transparent" x="184" y="75" width="159" height="31" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" lineSpacing="Single"> <font fontName="sansserif" reportFont="runtimeFont" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Runtime Font]]></text> </staticText> Java code to change the font size dynamically, JasperDesign jasperDesign = JRXmlLoader.load(fileName); Map fontMap = jasperDesign.getFontsMap(); JRDesignReportFont reportFont = (JRDesignReportFont) fontMap.get("runtimeFont"); reportFont.setSize(25); JasperCompileManager.compileReportToFile(jasperDesign,"RuntimeReport.jasper"); Thanks Vital By: Teodor Danciu - teodord RE: Change font size of fields at run-time? 2003-01-07 06:04 Hi, On a second thought, you might be right. Apparently I have misled you. Sorry ... In fact, the <reportFont> tag acts like an XML simplifier than a real font subclassing mechanism. I forgot about that... I'll study this in detail before jumping into conclusions. Thank you, Teodor By: protifar ipo - protifar RE: Change font size of fields at run-time? 2004-02-11 23:43 hi, how should I do if I want to set the font position dynamically(actually in the run time)? By: protifar ipo - protifar RE: Change font size of fields at run-time? 2004-02-12 00:22 I'm sorry... I mean "text" position rather than "font" position By: Teodor Danciu - teodord RE: Change font size of fields at run-time? 2004-02-14 03:15 Hi, You can change some of the element settings at runtime. Check the "alterdesign" sample and the API documentation to see what settings can be altered without need for report design recompilation. But the modifications you make for an element can be made only prior to launching the report filling process and will affect all the document. In other words, you cannot change a setting with each row in the data source. If you want this, you can only achieve it with this trick here: http://jasperreports.sourceforge.net/tips.tricks.html#formatting I hope this helps. Teodor