column report
I have 3 datasets: Master, Detail and one independent dataset.
The Master/Detail section is 2 columns. Each Master + Detail group must stay together (KeepTogether). If a group does not fit in the remaining space of column 1, it should move completely to column 2.
I also need the unused space in column 1 to be filled with empty bordered rows so both columns have the same visual height.
Below this, I have another independent section, also 2 columns with the same widths. For example, it should always show 10 rows total (5 left + 5 right). If there are only 3 records, the rest should be empty bordered rows.
Each section is designed on a separate report page, but the next page is configured to continue on the previous physical page when possible.
What is the best way to calculate empty rows using FreeSpace / RowCount without creating an unnecessary new page?