[Heap Space Error]

Hi 

I am facing the below issue while printing my jasper report using Open ERP. In this report I am using sub report as well -:

 

 

2017-11-22 16:03:39,659 8764 DEBUG demo openerp.tools.translate: no translation language detected, skipping translation for "'Report Error'"
2017-11-22 16:03:39,659 8764 ERROR demo openerp.service.report: Exception: ('Report Error', 'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: Java heap space')
Traceback (most recent call last):
  File "/opt/bitnami/apps/openerp/lib/openerp/service/report.py", line 92, in go
    result, format = openerp.report.render_report(cr, uid, ids, object, datas, context)
  File "/opt/bitnami/apps/openerp/lib/openerp/report/__init__.py", line 40, in render_report
    return registry['ir.actions.report.xml'].render_report(cr, uid, ids, name, data, context)
  File "/opt/bitnami/apps/openerp/lib/openerp/addons/base/ir/ir_actions.py", line 129, in render_report
    return new_report.create(cr, uid, res_ids, data, context)
  File "/opt/bitnami/apps/openerp/lib/openerp/extra_addons/jasper_reports/jasper_report.py", line 272, in create
    return r.execute()
  File "/opt/bitnami/apps/openerp/lib/openerp/extra_addons/jasper_reports/jasper_report.py", line 155, in execute
    pages = self.executeReport( dataFile, outputFile, subreportDataFiles, data['report_rml_content_data'] )
  File "/opt/bitnami/apps/openerp/lib/openerp/extra_addons/jasper_reports/jasper_report.py", line 241, in executeReport
    return server.execute( connectionParameters, f.name, outputFile, parameters )
  File "/opt/bitnami/apps/openerp/lib/openerp/extra_addons/jasper_reports/JasperReports/JasperServer.py", line 107, in execute
    raise osv.except_osv(_('Report Error'), e.faultString)
except_orm: ('Report Error', 'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: Java heap space')
2017-11-22 16:03:39,902 8764 ERROR demo openerp.addons.web.http: An exception occured during an http request
Traceback (most recent call last):
  File "/opt/bitnami/apps/openerp/lib/openerp/addons/web/http.py", line 427, in dispatch
    r = self._call_function(**self.params)
  File "/opt/bitnami/apps/openerp/lib/openerp/addons/web/http.py", line 174, in _call_function
    return self.func(*args, **kwargs)
  File "/opt/bitnami/apps/openerp/lib/openerp/addons/web/http.py", line 1084, in nfunc
    return checked_call(request.db, args, *kwargs)
  File "/opt/bitnami/apps/openerp/lib/openerp/service/model.py", line 111, in wrapper
    return f(dbname, args, *kwargs)
  File "/opt/bitnami/apps/openerp/lib/openerp/addons/web/http.py", line 1076, in checked_call
    return func(*a, **kw)
  File "/opt/bitnami/apps/openerp/lib/openerp/addons/web/controllers/main.py", line 1741, in index
    request.session.db, request.session.uid, request.session.password, report_id)
  File "/opt/bitnami/apps/openerp/lib/openerp/addons/web/http.py", line 558, in proxy_method
    result = openerp.netsvc.dispatch_rpc(self.service_name, method, args)
  File "/opt/bitnami/apps/openerp/lib/openerp/netsvc.py", line 236, in dispatch_rpc
    result = dispatch(method, params)
  File "/opt/bitnami/apps/openerp/lib/openerp/service/report.py", line 34, in dispatch
    res = fn(db, uid, *params)
  File "/opt/bitnami/apps/openerp/lib/openerp/service/report.py", line 140, in exp_report_get
    return _check_report(report_id)
  File "/opt/bitnami/apps/openerp/lib/openerp/service/report.py", line 118, in _check_report
    raise openerp.osv.orm.except_orm(exc.message, exc.traceback)
except_orm: (u'Report Error', u'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: Java heap space')

[I want to merge 2 rows in I-Report]

Hi Friends,

I am stucked in a situation where with my SQL query I am getting an output such as-:

Fname	Lname	Event1	Event2
abc	xyz	No	Yes
abc	xyz	Yes	No

So this is the output which iam getting with my SQL query and I want my output to be of single row so that the end user have a glance at the report and can easily guess which are the event that guy has attended.

Fname	Lname	Event1	Event2
abc	xyz	Yes	Yes

 

 

 

 

[i want to print first 15% of the detail band value in green color. 30% of the remaining value in white color and rest in blue color.]

Can any one please help me out with it... with proper explanation

[i want to print first 15% of the detail band value in green color. 30% of the remaining value in white color and rest in blue color.]

Can i get a solution for this very specific problem. Means the condition i could apply in table field 

[i want to print first 15% of the detail band value in green color. 30% of the remaining value in white color and rest in blue color.]

Hi Friends its an urgent requirement 

I have a report where inside table i want to print first 15% of the detail band value in green color. 30% of the remaining value in white color and rest in blue color.

In report im using table can any one please help me out with itits too urgent.

[Excel grid line remove in whole document]

simply click on report name from report inspector

and then set the report property  name as "net.sf.jasperreports.export.xls.white.page.background"  and its value as "true"

[Alternate row background color]

11) Simply take a rectangle set its print when expression as $V{REPORT_COUNT}%2==0

2) keep all the fields inside that rectangle in detail band

3) choose appropriate backcolor for rectangle

[alternate row color]

1) Simply take a rectangle set its print when expression as $V{REPORT_COUNT}%2==0

2) keep all the fields inside that rectangle in detail band

3) choose appropriate backcolor for rectangle

[alternate row color using styles]

11) Simply take a rectangle set its print when expression as $V{REPORT_COUNT}%2==0

2) keep all the fields inside that rectangle in detail band

3) choose appropriate backcolor for rectangle

[To pass Two values in a single parameter and print two diffrent report for those parameter]

can you tell me that program ????

[To pass Two values in a single parameter and print two diffrent report for those parameter]

To pass Two values in a single parameter and print two diffrent report for those parameter,

i have a parameter named as value in my query where i have used it as $X{IN,<column-name>,<parameter-name>}

it is taking two diffrent value as a parameter and printing the data of those two parameter in a single report

i want to generate individual report for each and every... like if a passed the vale as 126,345,456

so i want 3 diffrent report to be generated for each parameter

[table inside a table data not getting displayed]

i have a table say it Table1 inside one cell of that very table i have created another table say it as Table2

and the number of rows Table1 fetches is 5 and what table2 does is it displays all of that every row data in

a single row means in first row and in the other remaining rows it does not display any data

where as in the first row there are 5 strings to come and in the remaining rows there has to be single strings in each row.

[to retreive dynamic image from databse in ireport]

the image stored in database is in 'bytea' datatype

im selecting the image from palllete and setting its property to java.awt.image

but than its not working, and if im selecting the property as java.lang.string that same very thing is happening

but when im running the query in i report that very coloumn datatype is shown as java.lang.string

can you please help me retrieve image

[to convert a number in words]

i have designed a report where the total sum of a product is displayed

i want to convert that number into words

for e.g. if the total sum is 215 so the output should be like the one below

total=215

in words =two hundred and fifteen

in backedn im using postgres