jimmo

We recently unpgraded to iReport Designer 4.0.1 (we have a software product that does not support 5.x). We have a couple dozens of reports each with multiple layers of subreports. We created these reports a couple of years ago using iReport 3.5.3, and they have been migrated to 4.0.1 and work correctly through the Jasper Server engine in the software product we use. However, when I run the report in iReport, I get any error like this: Error loading object from file : Y:ReportsMonatsreportiReport 4.0 Reportssub-monthly-availability-errors.jrxml When I change the file name to sub-monthly-availability-errors.jasper it runs correctly. I delete allof the .jasper-files, abd they are created when the report runs. My swiss-cheese memory says there is some switch or option somewhere to tell iReport to use .jasper- or .jrxml-files, but I cannot remember where. Any help is greatly appreaciated.

We have two systems, each recently installed and each running iReport 3.5.3. Yes, I know it is old, but our vendor insists that we use it as the application cannot handle reports in a newer format. The machines are Windows 2008 terminal servers and we installed iReport from the same executable(iReport-nb-3.5.3-windows-installer). The problem is that when loading one of several different reports on one maschine we are getting an error like this: Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@eeaf20 net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: No query executer factory class registered for xpath2 queries. at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:243) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.loadJasperDesign(IReportCompiler.java:1933) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:440) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) This is supposed to access a remote XLM datasource. The connection test works fine and I can load the URL in a browser and it works as expected. I have found several references to the "No query executer factory class registered for xpath2 queries" error in the forum, because the systems should be configured the same. I did not do the install, so I cannot say with certainty. I compared the configuration on both machines, including the Query Executors and data source configuration, and they look identical. I exported the datasource config on the working machine and tried to import it on the other machine. The other sources loaded find, but this one did not. Other reports with different datasources work fine. Any assistance would be greatly appreaciated.

Hi All! Has anyone created reports using data from Packeteer/BlueCoat Packetshaper? I have no clue where to start and the BlueCoat website is not every helpful. I would be appreaciate any help. regards, jimmo

I got it to work by placing the Oracle jar file (ojdbc14.jar) in Java\jre6\lib\ext. I had already added the file into iReports under Options->Classpath and the sub-reports worked when I started them individuall.y It also seems that I have to load the driver explicitely. A friend suggested I simply add a field to the report with Expression Class "java.lang.String": Class.forName('oracle.jdbc.driver.OracleDriver').getName() It does not make sense to me that if the class is already added that I have to go through all of this. Any ideas?

Does your database contain CLOBs? Ours does and we had to include the table name and column name in double quotes: select "column1","column2" from "tablename"

Hi All! I have a subreport which reads data from a different datasource which I configured like this: Paremeter: subConnTICKET Paremeter Class: java.sql.Connection Default Value Expression: java.sql.DriverManager.getConnection("jdbc:oracle:thin:@10.2.29.77:1521:ticket_pu", "ticket", "ticketpw") Subreport Properties: Connection Type: Use a connection expression Connection Expression: $P{subConnTICKET} In one master report it works fine and I believe this works because the master and the subreport are both using an oracle database. If I use the same sub-report with a different master, I get the following error: Error filling print... Error evaluating expression : Source text : java.sql.DriverManager.getConnection("jdbc:oracle:thin:@10.2.29.77:1521:topd_pu", "ticket", "ticketpw") Running against: http://10.2.29.180/slm/servlet/export/tmp.xml?user=USERNAME&pass=PASSWORD net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : java.sql.DriverManager.getConnection("jdbc:oracle:thin:@10.2.29.77:1521:ticket_pu", "ticket", "ticketpw") at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:197) ..... Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@10.2.29.77:1521:ticket_pu The "Running against: " line is from our monitoring server which is the datasource used by the master report and several other subreports. This is an XML datasource and works fine without the new subreport. What I am missing is how to tell iReport to user this other data source. In the master report I found a parameter REPORT_DATA_SOURCE, which is hard coded to "net.sf.jasperreports.engine.JRDataSource". My assumption is that this is passed from from iReports and this is where I run into the dead-end. Where and how do I set a completely different datasource type for the subreport. Any assistance is appreaciated. Regards, jimmo Post Edited by jimmo at 11/03/2010 08:19

Hi Carl! I really appreciate the time. I checked the other posts and this all seems to fit together. Using your info as a basis, I was able to find something in the 2007 APress book "The Definitive Guide to iReport" on "Counting Occurrences of a Group". This does it within iReport by by creating a "variable of calculation type Count, defining Group as the increment type, and then specifying the group to count." One of these method should get me where I need to go. Thanks! regards, jimmo

Hi All! We have trouble ticket system that we are using to create reports. I can access the database and generate blocks for specific tickets. What we would like to do is create a summary block which contains information like total number of open tickets, total opened within the given time period, and so forth. I'm a two-week old noob and I really don't know how to go about this? Would a create a subreport for each of the sums we need? Is there any other way of doing this? I thins point I don't really need the gory details as I (hope I can) figure them out. I am just looking for a kick in the right direction. All help is appreciated. Regards, jimmo

I learned something, so it is always a good thing. Switched the report language to Java (also learned how to do that!). However, now I am getting "Cannot cast from String to BigDecimal".

$F{afgemeld}==1?"Yes":"No" returns Error filling print... Error evaluating expression : Source text : $F{afgemeld}==1?”Yes”:”No” net. sf. jasperreports. engine. fill. JPExpressionEvalException: Error evaluating expression : Source text : ^$F{afgemeld}==1?’Yes’:”No” ... Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'Yes' with class 'java.lang.String' to class 'java.lang.Integer' at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToNumber(DefaultTypeTransformation.java:127)

Hi All! I am an iReport and Java newbie. I would like to display text depending on whether an integer is 0 or 1. (The field is defined as a NUMBE, although it is actually used as a boolean). What I would like to do is something like this: $F{afgemeld}.equals(1)?"Yes":"No" In the error output I get Source text : $F{afgemeld}.equals(1)?"Yes":"No" net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Then a few lines later: Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'No' with class 'java.lang.String' to class 'java.lang.Integer' at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToNumber(DefaultTypeTransformation.java:127) I understand it so far that iReport cannot cast a string to an interger, so I was trying to cast the original value "afgemeld" to a string. That is where I am getting stuck. I tired this: $F{afgemeld}.toString().equals("0")?"Yes":"No" This also gives me: Cannot cast object 'No' with class 'java.lang.String' to class 'java.lang.Integer' at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToNumber(DefaultTypeTransformation.java:127) Can someone give me a kick in the right direction? I would be very grateful!

It turns out the tables all contain CLOBs. There are several cases where there are no CLOBs and I can see the columns. However, when a CLOB is present, I don't. In the application itself, they provide a way to look at the data dictionary. So, I can figure out what columns are available that way. Not as easy as drag-n-drop, but it works.

Greetings! First, I am a iReport noob. My boss tossed me a project yesterday and I need to figure out iReport ASAP. We are running 3.7.4 and trying to connect to an oracle database. The database connection URL looks like this: jdbc:oracle:thin:@dc-db-11:1521:topd_pu. In the services window, I can connect to database and see the tables. However, I cannot see the columns. In a command window I run: select * from TOPDESK."incident" In the output window I get: Line 1, column 1 Execution finished after 0.031 s, 1 error(s) occurred. Unfortunately, I do not see what the error is. Where should I look to get more details of the error? regards, jimmo