ibradien

I tried to make a report in odoo 8 using ireport, but there was an error... Odoo Warning Report Error Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: cannot assign instance of net.sf.jasperreports.engine.base.JRBaseStaticText to field net.sf.jasperreports.engine.base.JRBaseParagraph.paragraphContainer of type net.sf.jasperreports.engine.JRParagraphContainer in instance of net.sf.jasperreports.engine.base.JRBaseParagraph anyone can help me?

I use odoo 8 (formerly OpenERP), JasperReport from https://github.com/JayVora-SerpentCS/Jasperv8 and iReport 5.2.0. I try to make a report and find errors like this:

to all, how to change the numbers into characters using Jasper iReport Designer? for example: 1. Total Invoice : USD 1,250.00 - convert to character : " one thousand two hundred fifty dollars " (in English) 2. Total Invoice : IDR 2,450.00 - convert to character : " dua ribu empat ratus lima puluh rupiah " (in Bahasa - Indonesia) can anybody help me ? sorry, my english is not perfect :)

how to create report templates with row groups and column groups are static (static text) but the contents of the data retrieved from sql query. I mean this is like the example below. note: Group Description & Descriptions = Static Text; nominal / amount (numeric) = fields from sql query. is there any best solution for me ?

Hi aalexkun and bigteddo, I have a similar problem, but when I try to apply that idea ireport displays an error warning.>> first trial : Error:org.postgresql.util.PSQLException: ERROR: invalid input syntax for type boolean: ''''>> second trial : Error:org.postgresql.util.PSQLException: The column index is out of range: 18, number of columns: 17.Here I am using iReport Designer version 5.1.0 and PostgreSQL 9.1.I have tried to execute my query using pgAdmin III and produce the expected records. (but it is not successful in iReport)anyone can help find the solution? Thank you

I have a problem when setting the height for each sub report contents inside different. I have 1 main report and 2 sub report (A & B). how to set the height of each sub report different. anyone can help me find a solution?

I am creating a report using iReport Designer for OpenERP, with sql method and parameters ( $P{start_date} and $P{end_date} ). Report contains main report and sub reports (2), and sql methods applied in the sub reports. Main report was given 2 parameters : 1. $P{start_date}, Parameter Class --> java.util.Date, Use as a prompt : TRUE 2. $P{end_date}, Parameter Class --> java.util.Date, Use as a prompt : TRUE Sub Reports was given 2 parameters : 1. $P{start_date}, Parameter Class --> java.util.Date, Use as a prompt : TRUE 2. $P{end_date}, Parameter Class --> java.util.Date, Use as a prompt : TRUE sub reports execute the following SQL syntax: SELECT a.name AS kode_jb, a.deskripsi AS jns_blnja, b.tgl_transaksi, b.output FROM jenis_belanja a JOIN transaksi_bos b ON a.id=b.jns_belanja WHERE b.tgl_transaksi BETWEEN $P{start_date} AND $P{end_date}after I apply reports to OpenERP, result is that there is an error warning: " Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: Error evaluating expression : Source text : $P{end_date} "I do have an alternative way to add a third parameter ( $P{date_token}, Parameter Class --> java.util.String, Use as a prompt : FALSE and default value expression --> ($P{start_date} == null || $P{end_date} == null ? "AND 0=0" :"AND b.tgl_transaksi BETWEEN '" + new SimpleDateFormat("yyyy-MM-dd").format($P{start_date}) + "' AND '" + new SimpleDateFormat("yyyy-MM-dd").format($P{end_date}) +"'" ). )but the same error warning appears: Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: Error evaluating expression : Source text : $P{end_date}.anyone can help me find a solution ? ThanksBaim nb : sorry, my english is not perfect.

Hi Ankur Gupta, Thank you for your suggestion. Instability in the tag <detail>, or between <detail> and <summary>, please see attachment. Thanks Baim

Hi Ankur Gupta, I've set up all text fields in the tag <detail> </ detail>, but it does not work fine, because there is a problem of instability in the tag <detail> band height. Do you have any other solution to solve the problem of band height and wrap text ? Thanks,Baim

org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Premature end of file.at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1234)at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:525)at org.netbeans.core.xml.FileEntityResolver$DTDParser.parse(FileEntityResolver.java:430)Caused: java.io.IOException: Parsing MultiFileObject@407166[services/org-netbeans-modules-db-explorer-DatabaseOption.settings]: Premature end of file.at org.netbeans.core.xml.FileEntityResolver$DTDParser.parse(FileEntityResolver.java:443)at org.netbeans.core.xml.FileEntityResolver.getEnvForIDO(FileEntityResolver.java:171)at org.netbeans.core.xml.FileEntityResolver.getEnvironment(FileEntityResolver.java:164)at org.openide.loaders.Environment.findForOne(Environment.java:132)at org.openide.loaders.InstanceDataObject.getCookiesLookup(InstanceDataObject.java:635)at org.openide.loaders.InstanceDataObject.getCookiesLookup(InstanceDataObject.java:626)at org.openide.loaders.InstanceDataObject.getCookieFromEP(InstanceDataObject.java:557)at org.openide.loaders.InstanceDataObject.getCookie(InstanceDataObject.java:579)at org.openide.loaders.FolderInstance.acceptDataObject(FolderInstance.java:394)at org.openide.loaders.FolderInstance.defaultProcessObjects(FolderInstance.java:681)at org.openide.loaders.FolderInstance.access$000(FolderInstance.java:99)at org.openide.loaders.FolderInstance$2.run(FolderInstance.java:655)at org.openide.loaders.FolderLookup.postCreationTask(FolderLookup.java:257)at org.openide.loaders.FolderInstance.processObjects(FolderInstance.java:653)at org.openide.loaders.FolderInstance$Listener.finished(FolderInstance.java:934)at org.openide.loaders.FolderList.createBoth(FolderList.java:873)at org.openide.loaders.FolderList.getObjects(FolderList.java:562)at org.openide.loaders.FolderList.access$300(FolderList.java:74)at org.openide.loaders.FolderList$ListTask.computeResult(FolderList.java:955)at org.openide.loaders.FolderList$ListTask.run(FolderList.java:933)at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

Hi Ankur Gupta, thank you for your comment. The solution has been implemented, but doesn't solve the problem. because this problem has something to do with setting the height of the band ( ... ). this my code --> http://pastebin.com/m4HkYsQK Thanks,

Hi Sanda, please help me, I do not understand your solution. What this solution works well in ... Thanks

How to wrap text in a report with iReport Designer 5.1.0 ? I already did settings: - Set position type of the field to "float"- Set stretch type to "Relative to Tallest Object"- Turn stretch with overflow on (True) but results are not as expected. anyone know what the problem is?

what's wrong with my jasper report, every time I open the application iReport Designer, I see this as an error warning :A java.io.IOException exception has occurred.However, the system should continue working without further problems.Click Show Details for the stack trace.is there anything that can help me??