« SSIS Error opening packages / MSXML corruption | Main | Forced Page break workaround in Reporting Services »
May 13, 2008
Forced Page break workaround in Reporting Services
A colleague of my mine recently noticed that the table property to 'Insert a page break after this table' appears to have no affect - neither on-screen or in print outs. This looks like a bug. So is there some other way to do this? Well, I've used listboxes to control layout issues before, so I thought I'd see if it helps here and sure enough, it does.So as a workaround, you can drag a List box onto the design surface, and then drag the table into the list box. In order to make the List happy, you need to open it's properties and point to the dataset (same one as the table) as well as define a grouping. You would then select the option to 'Insert a page break' after the listbox and ~ voila ~ it works!
As a note - you may have to play around with the headings so that they don't repeat inside the list (maybe create a header outside of the listbox?) but that's the nature of a workaround.
Hope this helps...
Posted by Steve Mann at May 13, 2008 10:03 AM
