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?
 
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
 
TempDBACommented:
See in the rdl properties, what is the page break value assigned.
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.