Tuesday 10 April 2012

How to Generate Report in OpenERP


Generate Report : Tiny ERP Gandhinagar...
                                                     By : Year – 2012 Trainee at Tiny ERP
                                            Pinakin Nayi ( nayi_pinakin@yahoo.in )

step 1 :
→ open open-office.org
→ tools menu
→ extension manager
→ go to - base_report_designer
→ plugin →openerp_report_designer.zip

step 2 :
→ restart open-office

step 3 :
→ open a new report
→ add a loop ( select your DB)
→ add loop as a repeat
→ add a field and make it customize look
→ save file as a .sxw or send to the server

step 4 :
→ convert .sxw to .rml
→ $> cd to base-report-designer/openerp_sxw2rml > python openerp_sxw2rml.py
../../exam/report/.sxw > ../../exam/report/.rml

step 5 :
→ ( in report folder )
→ exam.py or copy it from (http://doc.openerp.com/v6.0/developer/3_11_reports/11_1_openoffice_report.html)
import time
from report import report_sxw
class exam(report_sxw.rml_parse):
def __init__(self, cr, uid, name, context):
super(exam, self).__init__(cr, uid, name, context)
self.localcontext.update({
'time': time,
})
report_sxw.report_sxw('report.exam.student', 'exam.student',
'addons/exam/report/exam.rml', parser=exam, header=True)

→ (exam.py , exam.rml , exam.sxw , __init__.py )
→ __init__.py
import exam


step 6 :
( main exam folder )
→ exam_report.xml
<?xml version="1.0"?>
<openerp>
<data>
<report
id="exam_student"
string="Print Exam..."
model="exam.student"
name="exam.student"
rml="exam/report/exam.rml"
auto="False"
header="False"/>
</data>
</openerp>

→ __openerp__.py
in update → 'exam_report.xml'

→ __init__.py
import report

2 comments: