So what gives with the page breaking in Reporting Services (2008 R2)?
When viewing the report in my web browser, the report breaks as expected (there are 10 years and there are 10 pages ... one year per page).
When it prints to the printer each year is broken into 2 pages so there are 20 pages in total.
When exported to excel and viewed in print preview, there are also 2 pages per year BUT the number of rows is different than the printed page. Also cell format changes such as font size, row width, padding, etc. are just different (maybe even ignored) when compared to the browser and printed views.
Do I have to target one of the areas (web browser, printer, excel print) and live with the other two?