User:Pinakin nayi/sandbox

'''Generate Report :  Tiny ERP Gandhinagar...                                                    By : Year – 2012 Trainee at Tiny ERP Pinakin Nayi ( nayi_pinakin@yahoo.in ) Paramjit Singh Sahota ( sahotaparamjitsingh@ymail.com ) Anand Patel (anand_it_indian@yahoo.in ) Hiral Patel ( hiralbca@gmail.com )

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 

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

→ __init__.py     import report