[firebird-support] matrix report

[mahdoom_a]

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