Monday, June 30, 2008

Date-Time and Table Heading in RML

Date-Time

Now, there is no need to write Date and Time explicitly in rml for reports,it can be done directly from .sxw file .One needs to add date/time field from the menu Insert->Fields->Date/Time of .sxw file and rml will take date/time report will be printed.

One can also change format for Date and Time fields , but Additional Formats are still not supported.

Add date and change format

Sxw File Report taken latter


Repeat Table Heading

repeatRows is a attribute of blockTables.It allows to repeat column headers of large table that splits over multiple pages.

For example :

First row of this table will be repeated ,if table will continue to next page.

Here,argument for repeatRows is number and it defines how many rows you want to repeat everytime.If you pass 3 ,it will repeat first 3 rows of table .

One can also defines this from sxw files,while creating new table ,check option for heading,Repeat Heading .


In following report , "Partner Name" is table heading which is repeated when table continue to next page.

Thursday, April 24, 2008

Patch for the Report Header

In TinyERP we have one custom file - corporate_rml_header.rml for rml report header and footer.While creating new company you can add text for header and footer which will be shown in every report with pre-formatted pattern.
Thanks to this patch you can now define your own template for the header and footer to show it on rml report.


As shown above,In res_company you'll find one text field - 'Report Header ' where you can write your template using rml.You can also select logo for the header using 'Logo' field in same form.

Before Applying patch(standard )


After Applying patch(Customized )