Skip to Content
This question has been flagged
v6.1reporting
2 Replies
9200 Views
Avatar
Phil74

I have installed my test and development OpenERP v6.1 on Windows.

If I rename the file sale_order.rml to sale_order.old within the folder sale/report/, I can still print the quotation order from the sales module. The quotation order is based on the sale_order.rml file or template.

This means that OpenERP stores the rml somewhere else.

As a consequence, if I modify the rml file manually, this new version of the rml file doesn't get used by OpenERP.

However, on my production installation, I don't have the same problem and the latest rml file is always used.

I have tried to clean up the cache from my browser (Waterfox), but it hasn't helped anything.

Where could the rml file be cached?

Avatar
Discard
Avatar
Andreas Brueckl
Best Answer

After you have edited the report the first time in OpenOffice it will be stored in database table ir_act_report_xml in fields:

  • report_rml_content_data (RML) and
  • report_sxw_content_data (SXW)

The report is only taken from file if those fields are empty, which is the case after a fresh install.

Avatar
Discard
Phil74
Author

Andreas, you seem to know everything! If I set these two fields to null, will OE read from the physical rml file then?

Avatar
klacus
Best Answer

If you cannot see any change after the direct edition, you must clear the db by following.

1.Open pgAdmin. check your report id in ir_act_report_xml.

2.Open a query.

SELECT id FROM ir_act_report_xml WHERE model = 'sale.order';

3.put the id (ir_act_report_xml.id) result into place of your_id

update ir_act_report_xml SET report_rml_content_data = NULL WHERE id = your_id;

4.Run and enjoy the rml edition. :-)

Avatar
Discard
Related Posts Replies Views Activity
How do I remove a cell from a single row table?
v6.1 reporting
Avatar
Avatar
1
मार्च 15
7295
Reporting with WebKit? Solved
v6.1 reporting
Avatar
Avatar
Avatar
Avatar
Avatar
5
मार्च 15
21396
how to add two values involved in a loop while creating a report?
v6.1 reporting
Avatar
Avatar
1
मार्च 15
4871
is it possible to use more than one language while creating a report?
v6.1 reporting multilanguage
Avatar
Avatar
1
मार्च 15
6058
How to add new field on payslip?
v6.1 reporting payslip
Avatar
1
मार्च 15
5504