Reply to comment

Hi Prajul T.
Thanks for your help.

I am working with ireport and crosstab and right now i have a issue with a final report.
I need see in each column, the months of year but in order, for example: january, february, march, and so on, but I can to display that columns but in disorder.

The query was written in postgres:

with client as
(

select codclient, sum(total) as totalc
from v_sales
group by codcliente
order by totalc desc

)

select
vc.*,
cp.name as periodname,

date_part('year',cp.enddate) as anio,
date_part('month',cp.enddate) as numeromes,

date_part('month',cp.enddate) || '-' || initcap(fnc_period(cp.startdate, 1000000) ) as namecomplet ,

cp.periodno,

tc.totalc,
cp.enddate

from v_sales vc

inner join c_period cp
on vc.c_period_id = cp.c_period_id

inner join client tc
on tc.codcliente = vc.codcliente

order by namecomplet asc, anio asc;

Thanks a lot...!
Omar