Hello,
Hoping someone may have experienced the same problem. When I run a SSRS report from Tessitura, it looks great. When I save it as a PDF, it inserts blank pages for every page of data.
I thought it was a margin issue, but I have reduced my page size to be very small and same thing happens.
Any suggestions,
Christian @ The Tech Museum
I haven't had exactly that issue, but I have had issues with pdfs of SSRS reports rendering in odd ways. I found that when I adjusted the margins and put things in boxes and did all sorts of tweaking to SSRS reports to try to make the pdf pretty, then saving to excel the formatting was way out of sorts. When I adjusted it to make the excel look normal, I'd end up with the pdf always putting one cell on a separate page all by itself, even though it was nowhere near exceeding the margin. I never resolved it, just resigned myself to making sure the reports look good in a browser. Sorry I don't have anything more helpful to add. I'd love to find a solution as well.
Amanda,
I'll keep playing with the margins and see if I get any different results.
Thanks,
Christian
Have you tried changing margins from the Report Properties/Layout tab?
Go to the Report menu and choose Report Properties.
Sorry if this is what you have already tried. I've had other questions like this where they confuse the "margins" built into their report layout with the actual margins set in the report properties.
Best of luck!
-ryan
Ryan,
Spent all day on this. Here's what I figured out. I was setting the margins correctly as you mentioned, but I did not understand that in SSRS you also have to set your layout space to the correct dimensions of your paper size.
Unlike Infomaker that you just need to make sure your elements fit within the boundaries, in SSRS you need to size the layout dimensions. Then it is not possible to put elements outside the boundaries. Learned something new.
Second problem I had had to do with pagination and page breaks. My report is a composite report calling 5 sub reports. When I ran the report from tessitura, each sub report section follows right underneath one another. However, when exporting it to PDF, if the entire section of 1 of the sub reports would not fit in the space left, it would force a page break and continue on the new page. This left alot of unwanted space on the pages.
Researched this online and apparently, there is a boolean property on your table called "Fit table on one page if possible". I set this to false so that it would just make the table data go as much as it could on 1 page and then continue on the next. Aye,there's the rub, this command is ommited when exported to a PDF. An oversight by Microsoft apparently.
My solution to this was to make my paper size bigger!
And that concludes my fun ordeals with SSRS pagination and page breaks!