[Execute .jrxml file (iReport) in Odoo 8]

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?

 

 

[create reports with JasperReport and odoo 8]

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:

Traceback (most recent call last):
  File "/opt/openerp/server/openerp/netsvc.py", line 296, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 660, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 766, in exp_report_get
    return self._check_report(report_id)
  File "/opt/openerp/server/openerp/service/web_services.py", line 744, in _check_report
    netsvc.abort_response(exc, exc.message, 'warning', exc.traceback)
  File "/opt/openerp/server/openerp/netsvc.py", line 71, in abort_response
    raise openerp.osv.osv.except_osv(description, details)
except_osv: (u'Report Error', u'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: null')

1. I've tried to update the java libraries in JasperReport module using update-jasper-reports.sh file. With the command line: update-jasper-reports.sh
2. I've tried to install java openjdk-7-jdk and openjdk-7-jre in ubuntu server

But the error was always appear, if anyone could help me? Anyone know the solution?
 

[how to change the numbers into character]

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 :)

[create a static report templates with data retrieved from sql query]

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 ?

[Parameters as SQL list with iReport]

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

[height of the sub reports are not same in iReport]

 

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?

 

[Date Parameter with SQL Methode for OpenERP Report]

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 ?

 

Thanks

Baim

 

nb : sorry, my english is not perfect.

 

[wrap text in a report with iReport Designer 5.1.0]

 

Hi Ankur Gupta,

Thank you for your suggestion.

Instability in the tag <detail>, or between <detail> and <summary>, please see attachment.

Thanks

Baim

[wrap text in a report with iReport Designer 5.1.0]

 

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

 

[A java.io.IOException exception has occurred.]

 

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)

[wrap text in a report with iReport Designer 5.1.0]

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,

[How to make the report engine adjust band height to fit the real space occupied by content?]

Hi Sanda,

please help me, I do not understand your solution.

What this solution works well in ...

Thanks

[wrap text in a report with iReport Designer 5.1.0]

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?

[A java.io.IOException exception has occurred.]

 

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??