Page break functionality workaround help

[gurpreet992]

hi ,
we are facing some challenges in the report we are trying to build.
the client needs the interest amount details and the settlements of the Interest amount in a report just one below the other.
we are getting interest amounts and settlements from different relatiohips
our requirement is
To show the Interest details for any account on quarter basis
for for those details for the same quarter whatever settlements are happening we need to show below the interest details list
.i have attached the screenshot of the report output we need.
for Q1 interest details
settlements happen in Q2 and for q2 interest details loan settlement happens in Q3 and so on,
we are able to show settlements below the Interest details but we are using a page break and its showin us each quarter interest details and then its settlements an so on
.In HTML and excel we are getting data for 1st quarter and settlements for that in 1 page and for 2nd quarter its going to 2nd page and so on.
our requirement is to show all quarters and their settlements in 1 page in excel
can you please help in this as how to achieve this.