Posted: 8/31/2010
I have a report with six tables. Each has a table break after the table. When I view the report in the preview pane, it page breaks correctly. When I export to Excel, some of the tables are on separate sheets, but some are not. I've never had any trouble with this in the past, so I'm not sure what's different this time around. Suggestions?
I'm not sure why that would happen either. If you have the page break after each, then they all should go onto a different sheet. You could try putting them inside a rectangle and then put the page break after each of those?
Posted: 9/1/2010
I think I figured out the issue. I had stacked the tables all next to each other (up and down), and when the table had rows, it caused them to be connected in a sense. Kinda weird.. but anyways, it works now. Thanks!