【问题】
I have a query that returns some summary records. For instance,
loan amount, loan term, interest rate. Then I want to have a second row that builds out the detailed payment schedule. so the report would look like this:
Loan Amt Term Rate
100,000 05months 4.75
payment interest principal principlebalance
20,238.13 395.83 19,842.30 80,157.70
20,238.13 317.29 19,920.84 60,236.86
20,238.13 238.44 19,999.69 40,237.17
20,238.13 159.27 20,078.86 20,158.31
20,238.10 79.79 20,158.31 0
20,000 2months 5
payment interest principal remaining
10,062.55 83.33 9,979.22 10,020.78
10,062.53