SQL output

Page 1 of 1
6 posts
SQL output

TonyIT
Super MMEX User

Posts: 72
Joined: Thu Nov 24, 2011 2:51 am
There is a way to format the output of SQL reports?
I mean things like bold, italics, colour, alignment...

Ciao
Ciao,
Tony.
Re: SQL output

Nikolay
MMEX Developer

Posts: 2276
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Re: SQL output

TonyIT
Super MMEX User

Posts: 72
Joined: Thu Nov 24, 2011 2:51 am
Wow! :o

A little bit help.

If I format the amount with <b> to bold it and </b> to stop, I lose the format of the number. So if I have 123.456,90 (Italian way) I get 123456.9 With the dot as decimal separator and without the dot for the group separator.
The amounts come from this round((case when billsdeposits_v1.transcode in ('Withdrawal','Transfer') then billsdeposits_v1.transamount end),2)
Have you some tips about?


Thanks.
Ciao,
Tony.
Re: SQL output

Nikolay
MMEX Developer

Posts: 2276
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
no ideas.

In Oracle is to_char('123456.0', '999,999.99') function. But in SQLite sems no way to format numbers.

But may be.... try to use <b> in the end of previous column and </b> in begin of next column.

Code: Select all
select 'one<b>',123456.9,'</b>three'

it seems does not working
Re: SQL output

Nikolay
MMEX Developer

Posts: 2276
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
If you wish use same format for for whole column it may be implemeted in c++ code.
Dynamic thanges a bit more difficult to implement but possible.
Custom Sql reports is great tool to get some specific data from db but not for build nice formated reports.
Re: SQL output

Nikolay
MMEX Developer

Posts: 2276
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Now it possible to create more complex reports. See examples here:

viewtopic.php?f=12&t=3083
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 1 guest