joethejet

OK, maybe I can explain what I'm looking for a different way. Does anyone know how to set up logging such that the sql statement shows up in the log? What are the steps? thanks, Joe

Hey Guys, OK, I'm moving from Jdev 10 to Jdev 11 and, in 10, I have the logging set up so that I always see the sql statement JR is going to execute displayed in the console log. For some reason in 11, this isn't happening. Does anyone know what hoops I have to jump through to get this to work? Thanks, Joe

Hi All, Ok, I recently decided to move up to the new version of Jasper from V 3.5.2 All was good when I added the JAR to my JDev project and it compiles and runs fine. However, when I compile with Maven and move over to our appserver running linux, I get 10/12/01 13:00:14 net.sf.jasperreports.engine.JRException: Error loading byte data : /opt/oracle/product/10gOC4J2/j2ee/home/caa001rr_1291237214488_88209.class 10/12/01 13:00:14 at net.sf.jasperreports.engine.util.JRLoader.loadBytes(JRLoader.java:290) 10/12/01 13:00:14 at net.sf.jasperreports.engine.design.JRAbstractClassCompiler.compileUnits(JRAbstractClassCompiler.java:69) 10/12/01 13:00:14 at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188) 10/12/01 13:00:14 at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215) What the heck? If I move back to the 3.5.2 JAR it works just fine again. Can someone tell me what changed so I know what I have to change? Thanks, Jet

Hi Carl, Thanks for checking. I know the property wasn't added until version 3.7.5 of JasperReports so I'm guessing that's why you're not seeing it. Of course, I don't see it in version 3.7.6 either! Near as I can tell, it's just something you have to add by adding a property to the report in the properties dialog.

yes, I know they added it to Jasper, I was wondering if iReport had added support via a check box or something like that. I haven't found it in my search. Thanks.

Hi, Does the most current version of iReport allow you to set the net.sf.jasperreports.export.jexcelapi.use.temporary.file property? Thanks.

Really? No one knows what this does?

Ok, I accidently clicked in the the left margin of iReport and now my excel output has extra blank rows. One, what is the click supposed to do? and two how the heck do I get rid of it! Thanks, Jet

Well, once I put it into my version of JExcelApiExporter, I was able to get much bigger files to output. I also had to play with page sizes. If it's not saving memory then I'm not sure what it's for. You're right that you can still manage(unfortunately) to blow out of memory if you really try to, but I experienced an increase in the file size. I ran a 32.3 MB Excel file this morning. Of course, maybe we have a bigger server. I set page height to 250000 and set ignore pagination. For really large files I had to go to a CSV file.

Hmm, I'm using Excel, not PDF. Maybe there's a difference there. I'm also setting "Ignore pagination" Here's a link: http://www.coderanch.com/t/424800/Other-Open-Source-Projects/JXL-Out-memory-error Since it says "workbook" in the method name, and it's in the JExcelApi class I'm guessing it only works on Excel?

Ah, got it. You need http://mirrors.ibiblio.org/pub/mirrors/maven/net.sourceforge.jexcelapi/jars/jxl-2.6.3.jar to go with Japer 3.1.4

I'm having the same problem. Seems worse with large reports. I'm trying to use the JExcelApiExporter work around, but now I'm getting a "java.lang.NoSuchFieldError: AUTOMATIC" error. Apparently the JExcelApiExporter can't find "Colour.AUTOMATIC" Any clue what library I need for it to find this?

Thanks, but I *think* I figured it out. The problem involved database connections. Seems that even if your all text header doesn't need the database, you better put a query in sub query or nothing will show up (or use the no data band). I just put in a 'select * from dual' and it seems to work. Thanks for offering to help! It's much appreciated. Jet

An update. It appears that the problem is only when running in iReport. In other words if I run the report from a java program the subreports will show up. Makes it hard to use iReport as a developmenet tool. :(

I'm very frustrated with ireport. I can't get a subreport to work in any way, shape or form. I have tried the simplest of all sub reports and still no go. Can someone post a simple, simple version of a subreport that I can try? What I'd like to do is have it in my pageHeader band. Maybe I just need to reinstall iReport. Has anyone else had such a baffling problem? Thanks, Jet