I have to create a loan account statement in the main report.
In the footnote I need to show the rate of interest changes during the period of account statement as below.
From_date To_date Rate of Interest
1.4.2010 28.5.2010 16.5%
29.5..2010 9.9.2010 15.75
In the above report 'From_date' and 'ROI' are fetched from the table.
Please help to fetch to_date with value= next(from_date) -1