markorocko

I don't know if you have the same identical issue. In my case my jasper files were not compiling and I received the same java.lang.IllegalAccessError above. So, I removed jaxen.jar and then my jasper files compiled properly. Jaxen is an xpath parser. So my suspicion is it was taking over as the designated parser but exceptioning out. Once it was out of the way jasper parsing went back to proper parsing. Hope that helps.

I don't know if you have the same identical issue. In my case my jasper files were not compiling and I received the same java.lang.IllegalAccessError above. So, I removed jaxen.jar and then my jasper files compiled properly. Jaxen is an xpath parser. So my suspicion is it was taking over as the designated parser but exceptioning out. Once it was out of the way jasper parsing went back to proper parsing.

Is it possible to do a dynamic query in iReport so that the SQL is passed in at runtime instead of saving it in a jrxml file? If so please demonstrate how. So, I'm using iReport and trying to pass in a query dynamically at runtime as a parameter. Rationale: The rationale in my case is that this query is used somewhere else in my java application so instead of hardcoding the same query I would rather just get it from java and pass it in as a parameter so I don't have to maintain two synced up copies. However, even trying to pass in a simple query like "select dummy from dual" chokes. JRXML looks like this [/code]But when I do it I get an errror below. Even when I do a simple test like select Caused by: java.sql.SQLException: Invalid SQL type at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:76) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:972) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137) ... 11 more Print not filled. Try to use an EmptyDataSource...

Does iReport/Jasper Reports support a way to inject jrxml so I can hand code jrxml and then render it? In the same way you might use html to make a webpage? Or does all the jrxml/jasper files have to be built in the jxrml>compiled>then filled with data? I'm running into a situation where my reports needs are more complex than the generic structure iReports is capable of generating.

Currently, I'm dealing with a FOP application that I wish to use Jasper/iReport for its ease of use and useful GUI to create reports over FOP which strictly uses XML. The current app I wish to convert makes use of DAO(Date Access Objects) which I believe is a good design pattern in this case! So for me to convert to Jasper is not that big of a deal as I would merely direct the data objects to Jasper instead of directing to FOP. However, iReport lends itself to doing SQL inside the JXRML. Which strikes me as a bad design pattern to use the Embedded SQL as it would not be portable. For if the backend tool changes to something else it will be nasty for my predecessor to have to extract all the embedded SQL and have to rework it for the next generation PDF tool. So I am resisting the urge to put SQL inside the JRXML files. Does anyone have any thoughts on this matter? Now, the downside of using the Objects over embedded SQL is iReports would not be permitted to do all it's fancy footwork e.g. create complex reports. iReports is built with the assumption that you will embed SQL and use the Fields to iterate over rows etc. which I don't think would work well with plain java objects. I have always used the embedded SQL capabilities. So now, I'm thinking the opposite that you really should break the good design practice of a data layer and just embed your SQL in the jrxml when you are dealing with Jasper Reports and iReport. Any thoughts or clarity appreciated! Post Edited by markorocko at 09/12/2012 18:10

So, the latest version of iReports rocks but I'm on a project that runs on JBoss 4 which uses JDK 5. Not so awesome sauce. I couldn't find one stinking page indicating which version of Jasper works with which JDK5 Through much trial and error I discovered 3.5.3 runs on JDK5 and the latest version 4.7.0 does NOT(you will get a 49.0 should be 50.0 runtime error). Does anyone what know or can point me to which versions of jasperreports runs on which JDK? My second cause of grief... iReport 4.7.0 rocks and connects great to my companies Oracle instance. However, with the same exact config I could not get iReports 3.5.3 to connect(wonder if JDK comes into play here as well). But anyway I found a way to use the latest iReport and point to GeneralCompatibility and set it to the old version. However, there was some issues with trying to cast Dates and TimeStamps to String that would not allow me to use the latest iReport tool and target it to the older instance so I ripped out some of the casting in the jrxml and was able to get it to work. Version question again... does anyone know when that Date TimeStamp casting stuff was permitted what version? Bottom line- I want to use the latest version of jasper I can that runs on JDK5. Any insight is appreciated!!! Thanks Post Edited by markorocko at 09/11/2012 14:35

Challenge - Can Jasper Reports return a PDF viewable in landscape format? This sounds trivial but can anyone show that it can be done so that it opens Acrobat and prints in landscape orientation? For some reason even if I set the dimensions so that width is larger than height Acrobat will not assume it's landscape orientation. Any thoughts/help is appreciated!

More information...... so when I use the iReport Designer 4.5.1 and preview rendering the document and print, it comes out properly landscape. However, when rendered in java and streamed to Acrobat the default is portrait. Does this product even work in Acrobat as landscape? This would be a major bug if iReports can't even print automatically as landscape. Please advise.

Folks, I'm using iReport Designer 4.5.1 and its accompanying jar. So my jxrml is nicely marked up and set to orientation='landscape' <?xml version="1.0" encoding="UTF-8"?> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Day View" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="708" leftMargin="42" rightMargin="42" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.5"/> However, when the XML is filled and delivered to Acrobat it shows the data represented properly but appears in acrobat portrait! So, I tried one additional thing and also set orientation on the fill and that didn't work either, document still appears in acrobat portrait. JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, hm, connection); jasperPrint.setOrientation(OrientationEnum.LANDSCAPE); Please advise how to make this puppy come out in landscape orientation. What's going wrong? Thanks! Post Edited by markorocko at 04/12/2012 22:24

I had a user request the ability to dynamically choose which columns a PDF report is sorted by and just discovered that I CANNOT dynamically plug in parameters into an order by using iReport. It appears jasperforge uses a prepared statement to fill the report and you cannot plug in a param value ? in an order by clause. So, I was wondering what options I have at this point? Has anyone found a work around? Or is there a way server side to create a raw SQL statement and feed it in dynamically to Jasperforge? Please advise, thanks!