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