Report Server 2008 R2 Page Breaks

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?

Thanks,
Mark
MarkMahonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TempDBACommented:
See in the rdl properties, what is the page break value assigned.
0
MarkMahonAuthor Commented:
Thanks TempDBA ... the break is set to a Group level variable.  The problem is ( i guess) that there is too much information on a given page and the extra rows bleed over to the next page and then the break happens after last row of th group.  So essentially it needs two pages to present each year when i want it to use one page per year.

I just made the formating smaller (=font size and row height) until all the rows for a given year fit onto one printed page.  

I guess am spoiled by Excel which does alot of the page sizing work for me (e.g., Page Setup -> "Fit to: 1 page wide by 10 tall").

With SSRS I had to do alot of work to get there and, which is more problematic, I get different "looks" depending on what the report is being rendered in... excel, printer, web browser, pdf.

Thanks,
Mark
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TempDBACommented:
hmm... And group is based on year setting I guess.
0
MarkMahonAuthor Commented:
Would have liked a more complete discssion of the the SSRS formatting issues, i.e., ways to get the report to fit on a single page, and why the page rendering is different when sending it to different targets (web browser, printer, excel. pdf)

Thanks,
mark
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.