<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-8739069634774044748</id><updated>2011-04-21T22:29:31.511-07:00</updated><title type='text'>OpenERP reporting</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://shah-dhara.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8739069634774044748/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://shah-dhara.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Dhara</name><uri>http://www.blogger.com/profile/11876057110722988165</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='23' height='32' src='http://bp3.blogger.com/_lA1ZRxoXnAQ/SEkrSRmLkNI/AAAAAAAAALs/g8yYmMbWmXA/S220/Untitled.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>2</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8739069634774044748.post-127203895003990338</id><published>2008-06-30T01:36:00.000-07:00</published><updated>2008-06-30T02:19:29.614-07:00</updated><title type='text'>Date-Time and Table Heading in RML</title><content type='html'>&lt;div  style="text-align: center; font-weight: bold;font-family:times new roman;"&gt;&lt;span style="font-size:130%;"&gt;Date-Time&lt;/span&gt;&lt;/div&gt; &lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;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-&gt;Fields-&gt;Date/Time of .sxw file and rml will take date/time  report will be printed.&lt;br /&gt;&lt;/span&gt;&lt;/p&gt;&lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;One can also change format for Date and Time fields , but Additional Formats are still not supported.&lt;/span&gt;&lt;/p&gt;&lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;Add date and                                                                                                 change format&lt;br /&gt;&lt;/span&gt;&lt;/p&gt;&lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_lA1ZRxoXnAQ/SGid2HH-ZPI/AAAAAAAAAN4/Hxi2W04i9ks/s1600-h/menu.jpg"&gt;&lt;img style="cursor: pointer;" src="http://1.bp.blogspot.com/_lA1ZRxoXnAQ/SGid2HH-ZPI/AAAAAAAAAN4/Hxi2W04i9ks/s320/menu.jpg" alt="" id="BLOGGER_PHOTO_ID_5217593721259713778" border="0" /&gt;            &lt;/a&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_lA1ZRxoXnAQ/SGid10N-dCI/AAAAAAAAANw/2l81XbJEFzU/s1600-h/format.jpg"&gt;&lt;img style="cursor: pointer;" src="http://4.bp.blogspot.com/_lA1ZRxoXnAQ/SGid10N-dCI/AAAAAAAAANw/2l81XbJEFzU/s320/format.jpg" alt="" id="BLOGGER_PHOTO_ID_5217593716184609826" border="0" /&gt;&lt;/a&gt;&lt;/span&gt;&lt;/p&gt;&lt;p  style="margin-bottom: 0cm;font-family:times new roman;" align="left"&gt;&lt;span style="font-size:100%;"&gt;Sxw File                                                                                            &lt;/span&gt;&lt;span style="font-size:100%;"&gt;Report taken latter&lt;/span&gt;&lt;/p&gt;&lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_lA1ZRxoXnAQ/SGid2a8jAvI/AAAAAAAAAOA/3oXP1CRsW0E/s1600-h/pdfreport.jpg"&gt;&lt;img style="cursor: pointer;" src="http://3.bp.blogspot.com/_lA1ZRxoXnAQ/SGid2a8jAvI/AAAAAAAAAOA/3oXP1CRsW0E/s320/pdfreport.jpg" alt="" id="BLOGGER_PHOTO_ID_5217593726580490994" border="0" /&gt;                                                &lt;/a&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_lA1ZRxoXnAQ/SGieLZL6abI/AAAAAAAAAOY/q0NAOkRXAfY/s1600-h/sxwfile.jpg"&gt;&lt;img style="cursor: pointer;" src="http://2.bp.blogspot.com/_lA1ZRxoXnAQ/SGieLZL6abI/AAAAAAAAAOY/q0NAOkRXAfY/s320/sxwfile.jpg" alt="" id="BLOGGER_PHOTO_ID_5217594086885321138" border="0" /&gt;&lt;br /&gt;&lt;/a&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin-bottom: 0cm; font-family: times new roman;" align="left"&gt; &lt;/p&gt;&lt;p  style="margin-bottom: 0cm; font-weight: bold;font-family:times new roman;" align="center"&gt;&lt;span style="font-size:130%;"&gt;Repeat Table Heading&lt;/span&gt;&lt;/p&gt; &lt;p  style="margin-bottom: 0.02cm; text-align: left;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;repeatRows is a attribute of blockTables.It allows to repeat column headers of large table that splits over multiple pages.&lt;/span&gt;&lt;/p&gt; &lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;For example :&lt;/span&gt;&lt;/p&gt; &lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;&lt;blocktable colwidths="4cm,4cm" repeatrows="”1”"&gt; &lt;/blocktable&gt;&lt;/span&gt; &lt;/p&gt; &lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt; First row of this table will be repeated ,if table will continue to next page.&lt;/span&gt;&lt;/p&gt; &lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;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 .&lt;/span&gt;&lt;/p&gt; &lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;One can also defines this from sxw files,while creating new table ,check option for heading,Repeat Heading .&lt;/span&gt;&lt;/p&gt; &lt;p  style="margin-bottom: 0cm;font-family:times new roman;"&gt;&lt;span style="font-size:100%;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/p&gt;&lt;div style="text-align: center;"&gt;&lt;span style="font-size:100%;"&gt;&lt;a style="font-family: times new roman;" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_lA1ZRxoXnAQ/SGid2VJqSXI/AAAAAAAAAOI/VdC_y6Pf-sE/s1600-h/repeatheading.png"&gt;&lt;img style="cursor: pointer;" src="http://2.bp.blogspot.com/_lA1ZRxoXnAQ/SGid2VJqSXI/AAAAAAAAAOI/VdC_y6Pf-sE/s320/repeatheading.png" alt="" id="BLOGGER_PHOTO_ID_5217593725024881010" border="0" /&gt;&lt;/a&gt;  &lt;/span&gt;&lt;div style="text-align: left;"&gt;&lt;span style="font-size:100%;"&gt;&lt;span style="font-family:times new roman;"&gt;In following report , "Partner Name" is table heading which is repeated when table continue to next page.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt; &lt;p style="margin-bottom: 0cm; text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_lA1ZRxoXnAQ/SGifn2KoErI/AAAAAAAAAOg/CFG-yTkFoJI/s1600-h/repeatheading_final.png"&gt;&lt;img style="cursor: pointer;" src="http://2.bp.blogspot.com/_lA1ZRxoXnAQ/SGifn2KoErI/AAAAAAAAAOg/CFG-yTkFoJI/s320/repeatheading_final.png" alt="" id="BLOGGER_PHOTO_ID_5217595675212518066" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8739069634774044748-127203895003990338?l=shah-dhara.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://shah-dhara.blogspot.com/feeds/127203895003990338/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=8739069634774044748&amp;postID=127203895003990338' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8739069634774044748/posts/default/127203895003990338'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8739069634774044748/posts/default/127203895003990338'/><link rel='alternate' type='text/html' href='http://shah-dhara.blogspot.com/2008/06/support-for-few.html' title='Date-Time and Table Heading in RML'/><author><name>Dhara</name><uri>http://www.blogger.com/profile/11876057110722988165</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='23' height='32' src='http://bp3.blogger.com/_lA1ZRxoXnAQ/SEkrSRmLkNI/AAAAAAAAALs/g8yYmMbWmXA/S220/Untitled.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://1.bp.blogspot.com/_lA1ZRxoXnAQ/SGid2HH-ZPI/AAAAAAAAAN4/Hxi2W04i9ks/s72-c/menu.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8739069634774044748.post-90272025927480568</id><published>2008-04-24T23:58:00.000-07:00</published><updated>2008-04-25T05:11:14.221-07:00</updated><title type='text'>Patch for the Report Header</title><content type='html'>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.&lt;br /&gt;Thanks to this patch you can now define your own template for the header and footer to show it on rml report.&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_lA1ZRxoXnAQ/SBGeJPv_I0I/AAAAAAAAAKY/fnCdl-13-_0/s1600-h/res_company.png"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 259px; height: 149px;" src="http://3.bp.blogspot.com/_lA1ZRxoXnAQ/SBGeJPv_I0I/AAAAAAAAAKY/fnCdl-13-_0/s200/res_company.png" alt="" id="BLOGGER_PHOTO_ID_5193105727018705730" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;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.&lt;br /&gt;&lt;br /&gt;Before Applying patch(standard )   &lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_lA1ZRxoXnAQ/SBGewfv_I1I/AAAAAAAAAKg/JAMgo25sUQ0/s1600-h/report1.png"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 259px; height: 149px;" src="http://4.bp.blogspot.com/_lA1ZRxoXnAQ/SBGewfv_I1I/AAAAAAAAAKg/JAMgo25sUQ0/s320/report1.png" alt="" id="BLOGGER_PHOTO_ID_5193106401328571218" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;After Applying patch(Customized )&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_lA1ZRxoXnAQ/SBGe2fv_I2I/AAAAAAAAAKo/PGf-3qGK6WI/s1600-h/report2.png"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 259px; height: 149px;" src="http://4.bp.blogspot.com/_lA1ZRxoXnAQ/SBGe2fv_I2I/AAAAAAAAAKo/PGf-3qGK6WI/s320/report2.png" alt="" id="BLOGGER_PHOTO_ID_5193106504407786338" border="0" /&gt;&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8739069634774044748-90272025927480568?l=shah-dhara.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://shah-dhara.blogspot.com/feeds/90272025927480568/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=8739069634774044748&amp;postID=90272025927480568' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8739069634774044748/posts/default/90272025927480568'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8739069634774044748/posts/default/90272025927480568'/><link rel='alternate' type='text/html' href='http://shah-dhara.blogspot.com/2008/04/patch-for-report-header.html' title='Patch for the Report Header'/><author><name>Dhara</name><uri>http://www.blogger.com/profile/11876057110722988165</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='23' height='32' src='http://bp3.blogger.com/_lA1ZRxoXnAQ/SEkrSRmLkNI/AAAAAAAAALs/g8yYmMbWmXA/S220/Untitled.jpg'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_lA1ZRxoXnAQ/SBGeJPv_I0I/AAAAAAAAAKY/fnCdl-13-_0/s72-c/res_company.png' height='72' width='72'/><thr:total>4</thr:total></entry></feed>
