hi
I defin a function in my .py file that return many rows in rml report.
my .py code is:
----------------------
def _getsalesdetail(self, fromDate, toDate):
sql = "select so.name,so.date_order,section.name,resu.name,resp.name,soline.id \
,lag(null,1,pp.name_template) over (partition by pp.name_template order by soline.price_unit) as product \
,soline.name,soline.price_unit,soline.product_uom_qty ,actax.amount ,soline.discount \
,((soline.price_unit - soline.price_unit*(soline.discount/100))*(1+actax.amount)) \
,soline.product_uom_qty*((soline.price_unit - soline.price_unit*(soline.discount/100))*(1+actax.amount)) \
from sale_order_line as soline \
full outer join sale_order_tax as soltax on soltax.order_line_id=soline.id \
full outer join account_tax as actax on actax.id=soltax.tax_id \
full outer join sale_order as so on so.id=soline.order_id \
full outer join product_product as pp on pp.id=soline.product_id \
full outer join res_partner as resp on resp.id=so.partner_id \
full outer join res_users as resu on resu.id=so.user_id \
full outer join crm_case_section as section on section.id=so.section_id \
where soline.type='make_to_order' and so.state !='draft' AND so.date_order BETWEEN \'%s\' AND \'%s\' \
group by pp.id,pp.name_template, so.name,so.date_order,section.name,resu.name,resp.name,soline.id,actax.amount" %(fromDate, toDate)
self.cr.execute(sql)
return self.cr.fetchall() or ['-']
----------------------------------------------
and my rml code is:
<blockTable colWidths="38.0,38.0,28.0,38.0,40.0,37.0,37.0,55.0,20.0,23.0,23.0,62.0,60.0" style="Table5">
<tr>
<td>
<para style="P9">[[ repeatIn(getsalesdetail(data['form']['fromDate'], data['form']['toDate']),'ho') ]]</para>
<para style="P8">[[ho[0] ]]</para>
</td>
<td>
<para style="P8">[[toJalali(ho[1]) ]]</para>
</td>
<td>
<para style="P8">[[ho[2] ]]</para>
</td>
<td>
<para style="P10">[[ho[3] ]]</para>
</td>
<td>
<para style="P8">[[ho[4] ]]</para>
</td>
<td>
<para style="P8">[[ho[6] ]]</para>
</td>
<td>
<para style="P8">[[ho[7] ]]</para>
</td>
<td>
<para style="P8">[[ formatLang(ho[8],currency_obj=company.currency_id) ]]</para>
</td>
<td>
<para style="P8">[[ho[9] ]]</para>
</td>
<td>
<para style="P8">[[ho[10] ]]</para>
</td>
<td>
<para style="P8">[[ho[11] ]]</para>
</td>
<td>
<para style="P8">[[ formatLang(ho[12],currency_obj=company.currency_id) ]]</para>
</td>
<td>
<para style="P8">[[ formatLang(ho[13],currency_obj=company.currency_id) ]]</para>
</td>
</tr>
</blockTable>
--------------------------------------------
but when I print report
I want between lines(row) add a black line. I don't know how can do it?
my openoffice version is : Libre Office3
Thank you
yes, The problem was solved.