Dear all,

I need your help to create this report

AQNO Jan Feb Mar Apr May Jun Jul......Dec. Total_paid
---- --- --- --- --- --- --- --- --- ----------
1001 2000 2000 2000 2000 8000
CHQNO 214 215 216 217


it will fill the amount(PAYMNT) in each month (PAYDATE) and its cheque number (CHQNO)






table structure is


CREATE TABLE RNTSTAT (
STATNO INTEGER NOT NULL,
RNTDUE DOUBLE PRECISION,
DUEDATE DATE,
PAYMNT DOUBLE PRECISION,
PAYTYP VARCHAR(30),
CHQNO VARCHAR(30),
PAYDATE DATE,
INVOICE VARCHAR(30),
EXPNS DOUBLE PRECISION,
XPNSDATE DATE,
XPENSTYP VARCHAR(30),
MENAINTYP VARCHAR(30),
CHRGVAL DOUBLE PRECISION,
CHRGTYP VARCHAR(30),
RNTNO INTEGER,
EXNSNO INTEGER,
AQNO INTEGER,
PANNO INTEGER,
CONTNO VARCHAR(30),
CHRGPER FLOAT,
FROM_DATE DATE,
TO_DATE DATE,
AWQAFNO NEW_DOMAIN
);


any hint will be helpful.

thanks & regards,

AHMAD