Page 2 of 2

Re: sum up different bank account

Posted: Wed Jan 28, 2015 8:42 pm
by Renato
Hi Nikolay

Thanks, this is precisely the evaluation I needed.

However, I have in SQL
order by ACCOUNT NAME;
by
order by HELDAT,ACCOUNT NAME;
replaced.

And in html
<th class = "i18n"> Balance </th>
<th class = "i18n"> Conv rate </th>
<th class = "i18n"> Balance </th>
by
<th class = "text-right"> Balance </th>
<th class = "text-right"> Conv rate </th>
<th class = "text-right"> Balance </th>
replaced.

Re: sum up different bank account

Posted: Wed Jan 28, 2015 8:53 pm
by Renato
and a.accountname like 'CS%' or a.accountname like 'SG%' or a.accountname like '.%' or a.accountname like 'Spar%' or a.accountname like 'Post%'

Code: Select all

and a.accountname in( 'CS..', 'SG..' , 'Spar..', 'Post..')
list full names for all needed accounts