I'm producing a Statement of Account for a number of clients using SSRS.
My main report gathers the identifiers for each client I need to produce a report for. Within this report I have a table that consists of 2 sub reports . The first subreport displays the address for the client and takes up about a third of the page. The second subreport displays the statement detail listing all invoices the client needs to pay.
My issue is if the second subreport needs to display more lines than can be fitted in the remaining 2/3 of a page it takes everything and puts the whole subreport data on the 2nd page, leaving page 1 with just the address and 2.3 of blank page and then the rest of the data on page 2.
I need the subreport to start to display the invoice data just below the address and continue on a 2nd page where necessary.
I've been trying things like making sure that "Fit table on one page if possible" is not ticked and have been messing with page breaks (all are switched off) etc but have had no joy.
Any suggestions are welcome.
My main report gathers the identifiers for each client I need to produce a report for. Within this report I have a table that consists of 2 sub reports . The first subreport displays the address for the client and takes up about a third of the page. The second subreport displays the statement detail listing all invoices the client needs to pay.
My issue is if the second subreport needs to display more lines than can be fitted in the remaining 2/3 of a page it takes everything and puts the whole subreport data on the 2nd page, leaving page 1 with just the address and 2.3 of blank page and then the rest of the data on page 2.
I need the subreport to start to display the invoice data just below the address and continue on a 2nd page where necessary.
I've been trying things like making sure that "Fit table on one page if possible" is not ticked and have been messing with page breaks (all are switched off) etc but have had no joy.
Any suggestions are welcome.