Skip to Content
Menu
This question has been flagged
1885 Views

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???????????

Avatar
Discard