sum up different bank account

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: sum up different bank account

Post 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.
Renato Forum Administrator
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: sum up different bank account

Post 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
Renato Forum Administrator
Post Reply