Display of renewed contracts and old contract rent based on some logic

Hi All,

My requirement is to show the straight line rent for a contract .

The scenarion is :

contract start date Renew Date End of term payement date Rent paid

C1 1/1/2005 1/1/2006 12/31/2007 1/1/2005 100

C1 1/1/2005 1/1/2006 12/31/2007 2/1/2005 100

C1 1/1/2005 1/1/2006 12/31/2007 3/1/2006 100

C1 1/1/2005 1/1/2006 12/31/2007 5/1/2006 100

C1 1/1/2005 1/1/2006 12/31/2007 6/1/2007 100

C1 1/1/2005 1/1/2006 12/31/2007 9/1/2007 100

C2 1/1/2004 1/1/2006 10/1/2004 100

C2 1/1/2004 1/1/2006 12/1/2004 100

In report when user entry a date on start date : 1/1/2004 to 12/31/2007

The report should be like this :

contract start date Renew Date End of term 2004 2005 2006 2007

SLRent SLRent SLRent SLRent

C1 1/1/2005 1/1/2006 12/31/2007 0 0 200 200

C2 1/1/2004 1/1/2006 200 0 0 0

Thus i should have sum of rent paid for the contracts from start date when there is no renew date , but if the contract have renew date the rent paid sould only be sum for the date after the renewal.