report.py:
def _function(self, fromDate, toDate):
sql = "select round(sum(aml.credit) - sum(aml.debit)) \
from account_move_line as aml \
join account_account as aa on aml.account_id=aa.id and aa.user_type=8 \
where aml.date BETWEEN \'%s\' AND \'%s\'" %(fromDate, toDate)
self.cr.execute(sql)
return self.cr.fetchall()
report.rml:
<blockTable colWidths="186.0,94.0" style="Table12">
<tr>
<td>
<para style="P12">[[ repeatIn(function(data['form']['fromDate'], data['form']['toDate']),'p') ]]</para>
<para style="P13">[[p[0] ]]</para>
</td>
</tr>
</blockTable>
output: ( 1.28676738711e+11 )
why output???????????