2008-04-07 12:29:39 UTC
Hello, I am having the exact same problem. Using 2.35 MP1 with Oracle XE, iReports 2.05.
I can change the RptC_Invoice.jrxml and it will change, compile and execute fine when adding static text. However, when I modify the data query and add any other field i.e. C_INVOICE.POREFERENCE AS POREF. Then It will compile but create the mentioned error at execution time.
I have checked the field and it says in iReports that it is java.util.Date. However after compiling in iReports, the generated java file (RptC_Invoice.java) whenever it references the DATEINVOICED field it does by saying -- value= (java.util.Date)(((java.sql.Timestamp) ...getvalue....))) --
I then manually change that to -- value = (java.util.Date)(((java.util.Date) ...-- in the three statements of the code where it appears erroneously, but on execution it keeps saying "Error evaluating expression : Source text : $F{INVOICEDATE}"
I read somewhere else in the forum that this problem (using java.sql.Timestamp) should be fixed in the OB last version, but I am using 2.35 MP1.
Does any one keep having the same problem?
