Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Entire Table is pushed to the next page when rendering a SSRS 2005 Report (as .pdf) in SSRS 2008

I have a SSRS 2005 report that I'm rendering in SSRS 2008 as a .pdf. The report contains (among other things) a table that's very simple: header row, details, no footer, no aggregation, no grouping, keep together = false, pageBreakAtStart = false, pageBreakAtEnd = false, repeatHeaderOnNewPage = true. I resized the table to be much narrower than the body of the report just to be sure it wasn't extending beyond the bounds of the report, pushing everything down. But, no matter what I try, if some of the detail rows in that table would need to be pushed to the next page, then the ENTIRE TABLE is pushed to the next page, not just the extra rows.

So my question is: Is there a workaround for this problem, is this a known issue, or is it even possible to get this 2005 report to render properly in 2008?

NOTE: this is related to a question that I previously asked here, and is based on this MSDN forum post started by a coworker. This question is not the same as my previous question, as I'd like to see things work properly in with a 2005 report. If it's not possible, that would be good to know, as it would indicate that we need to upgrade one of our servers to SQL 2008.

like image 217
Mark Carpenter Avatar asked Feb 10 '10 15:02

Mark Carpenter


People also ask

What are the six rendering extensions available in SSRS?

SQL Server Reporting Services includes seven rendering extensions: HTML, Excel, Word, CSV or Text, XML, Image, and PDF. You can create additional rendering extensions to generate reports in other formats.

How do I display an SSRS report on one page?

Solution : The default Interactive size is set to 11 inches and whatever records can fit into it that is what SSRS display to us. Let's change the Height to 0 Under InteractiveSize Property under Report properties and deploy our report and see if it is showing all records on one page.


2 Answers

Have you tried putting the table inside a rectangle (and check indeed that the table is a child of the rectangle using the Document Outline pane)

like image 91
adolf garlic Avatar answered Oct 22 '22 21:10

adolf garlic


Actually, I did exactly the opposite of what is suggested in the other answers here...My table was already inside the rectangle, and it was still shifting to next page. So I removed the rectangle, and it seems to be working without any issues now!

Weird..But may be it all depends on the over all layout of the report or something.

Thanks!

like image 1
VDevnani Avatar answered Oct 22 '22 20:10

VDevnani