afaquecena

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

Hi Friends, I am stucked in a situation where with my SQL query I am getting an output such as-: FnameLnameEvent1Event2abcxyzNoYesabcxyzYesNoSo 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 LnameEvent1Event2 abcxyzYesYes

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

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

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.

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"

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

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

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

can you tell me that program ????

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

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.

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

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