Paginated Report, two columns of data, weird page breaks
Hi New-ish to PowerBi and especially new to paginated reports. I have an existing report that scrolled vertically for several pages (~30 tables or so). I wanted to present the tables side-by-side. I copied the one table, pasted it beside, then filtered each table based based on a counter % 2, so that the left column would show table 1, 3, 5, etc, and the right would show tables 2, 4, 6, etc. The design view looks like this: The challenge that comes is that the repeating row, the row that starts with "[Labcode2]", may span more than one page. This would be consistent for the whole report. Stated another way, each table in a single report has the same number of lab codes. I set a page break on the row group around the top row (where it says TEST RESULTS). I do this on both tables. When viewing the results in the report designer, the report looks exactly as I would like. When viewing as a PDF, the first pair of tables show correctly: The [Labcode2] group repeats, wraps to the next page, and the summary bit shows, then page breaks. The next page does not follow this behaviour: For some reason, the last row of [Labcode2] does not span to the next page, and pulls the summary section up into the first page - honestly making it look weird: 😛 (pardon the size - it was hard to get both side-by-side and show the weird breaking). There is no page break defined on the [Labcode2] repeating group. The only page break I can find defined is on the repeating group around TEST RESULTS. This only happens when the output is generated as PDF. My inexperience with report builder starts to show up here .. I have no idea how to approach this to fix it 🙂 Any help or dierction is appreciated.
