OraFAQ Forum: SQL & PL/SQL » How to write a Matrix report use SQL syntax ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to write a Matrix report use SQL syntax ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to write a Matrix report use SQL syntax ? [message #23673]

Tue, 24 December 2002 08:58

AnotherBlue
Messages: 28
Registered: July 2001

Junior Member

How to use SQL syntax to write a Matrix report ?

My default SQL syntax

select
ct.bill_to_customer_id, round(ps.due_date,'MONTH'),
sum(ps.amount_due_remaining)
from
ar_payment_schedules_all ps ,
ra_customer_trx_all ct
where ps.customer_trx_id=ct.customer_trx_id
and ps.due_date>=:trxdate
and ps.gl_date<=:trxdate
group by ct.bill_to_customer_id,
round(ps.due_date,'MONTH')

I want to report list like this

1 mon 2 mon 3 mon ...
------------------------------------------
cust_id1 sum(amount) ... ...
cust_id2 ... ... ...
cust_id3 ... ... ...

how can I do ?

Thx for your help

Report message to a moderator