blocks|key|1670027|text|在与这个问题斗争了几个小时后，我偶然发现了一个对我有效的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1670028|在SSDT+(2012)中，我最初将页面设置/页面单位设置为厘米。当我将其更改为英寸时，奇怪的是，我可以将报告导出为PDF，而不会使其他所有页面都为空白。|1670029|​|1670030|📷|atomic|offset|length|1670031|1670032|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/c24654fdcdeabd41e854f66cfe267dbe.jpeg|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

After hours of struggling with this problem, I stumbled upon a solution that worked for me:

In SSDT (2012), I had originally had my Page Setup/Page units set to Centimeters. When I changed this to Inches, strangely enough, I was able to export my report to PDF without having every other page be blank.

<img src="https://i.stack.imgur.com/92QpW.jpg" alt="enter image description here">

blocks|key|1669964|text|如果来自SSRS的页面是空白的，则需要调整报告布局。这将比通过和post过程运行输出来修复布局问题的副作用要高效得多。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1669965|当涉及到突破边界时，SSRS是非常挑剔的。通过调整报表上的文本框或其他控件，很容易意外地加宽/加长报表。仔细检查报表表面的宽度和高度属性，并尽可能地挤压它们。注意大的页眉和页脚。|1669966|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If the pages are blank coming from SSRS, you need to tweak your report layout. This will be far more efficient than running the output through and post process to repair the side effects of a layout problem.

SSRS is very finicky when it comes to pushing the boundaries of the margins. It is easy to accidentally widen/lengthen the report just by adjusting text box or other control on the report. Check the width and height property of the report surface carefully and squeeze them as much as possible. Watch out for large headers and footers.

blocks|key|1670241|text|我使用SSRS已经有10多年了，上面的答案就是最好的答案。但。如果什么都不起作用，并且您将完全从报告中删除项目，直到问题消失。确定导致问题的行或报表项后，将其放入矩形容器中。就这样。帮了我们很多很多次了！额外的页面主要是由于报表项超出右边距造成的。当所有其他方法都失败时，将东西放在一个矩形内或一个项目右侧的空矩形内，可以阻止这种情况的发生。祝你好运！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1670242|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I have worked with SSRS for over 10 years and the answers above are the go to answers. BUT. If nothing works, and you are completely stuffed....remove items from the report until the problem goes away. Once you have identified which row or report item is causing the problem, put it inside a rectangle container. That's it. Has helped us many many times! Extra pages are mostly caused by report items flowing over the right margin. When all else fails, putting things inside a rectangle or an empty rectangle to the right of an item, can stop this from happening. Good luck out there!

blocks|key|1455075|text|您是否尝试过查看报表右侧是否有空格？如果是这样，您可以将其拖回到报表的末尾，然后将报表背景拖回到同一位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1455076|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Have you tried to see if there is any white space on the right of your report? If so you can drag it back to the end of your report and then drag the report background back to the same spot.

blocks|key|1455154|text|在报告(myReport.rdlc)的属性选项卡上，将"Keep+to“属性更改为False。我已经在这个问题上挣扎了一段时间，这似乎解决了我的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1455155|📷|atomic|offset|length|1455156|​|1455157|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/99e3eabd48e4b28aa04817b0ee5704a6.png|imageAlt^0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@$E|T|F|U|1|V]]|A|$]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P|Q|-4]]]]

On the properties tab of the report (myReport.rdlc), change the "Keep Together" attribute to False. I've been struggling with this issue for a while and this seems to have solved my issue.
<img src="https://i.stack.imgur.com/8eGZH.png" alt="enter image description here">

blocks|key|1670419|text|我最近继承了一份报告，我需要做一些修改。在遵循了上面的所有建议之后，它没有任何帮助。从历史上看，这份报告有额外的一页，没有人能找出原因。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1670420|我右击了tablix并选择了属性。有一个复选框被选中，上面写着在后面添加分页符。删除后，它现在打印在一页上。|1670421|​|1670422|📷|atomic|offset|length|1670423|1670424|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/8efc5e10d50e4d70b4a72f785c35f9a4.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

I recently inherited a report that I needed to make a few changes. After following all the recommendations above, it did not help. The report historically had this extra page, and nobody could figure out why.

I right clicked on the tablix and selected properties. There was a checkbox checked that said add a page break after. After removing this, it prints on one page now.

<a href="https://i.stack.imgur.com/ZRNE0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZRNE0.png" alt="enter image description here"></a>

blocks|key|1670352|text|如果您的报表包含子报表，并且允许子报表和层次结构增长，则子报表的宽度可能会超出正文的边界。我也遇到过类似的问题，因为子报表可以放在一个单元格中(跨越两列)。看起来span可以在设计器中包含它，并且它在winform或浏览器中呈现良好，最初，它可以生成打印机输出(或pdf文件)，而不会溢出到多余的页面上。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1670353|然后，在更改了一些其他列宽(并且没有超过正文宽度和页边距)之后，winform和浏览器的渲染效果看起来仍然很好，但是当生成输出(打印机或pdf)时，它会增长到超过页边距，并将每页的右侧写为第二页(第四页，等等)。页面。我可以通过增加子报告所在位置的colspan来解决这个问题。|1670354|无论你是否使用子报表，如果你有页面溢出，并且你的正文设计适合页面的边缘，寻找一些允许生长的东西来推动正文的宽度。|1670355|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

If your report includes a subreport, the width of the subreport could push the boundaries of the body if subreport and hierarchy are allowed to grow. 
I had a similar problem arise with a subreport that could be placed in a cell (spanning 2 columns). It looked like the span could contain it in the designer and it rendered fine in a winform or a browser and, originally, it could generate printer output (or pdf file) without spilling over onto excess pages. 
Then, after changing some other column widths (and without exceeding the body width plus margins), the winform and browser renderings looked still looked fine but when the output (printer or pdf) was generated, it grew past the margins and wrote the right side of each page as a 2nd (4th, etc.) page. I could eliminate my problem by increasing colspan where the subreport was placed. 
Whether or not you're using subreports, if you have page spillover and your body design fits within the margins of the page, look for something allowed to grow that pushes the width of the body out.

blocks|key|1455493|text|确保visual+studio中的设计器没有超出您的最大宽度。将鼠标悬停在页面右侧边框上并向左拖动，以确保页面不会超出所需的布局。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1455494|​|1455495|📷|atomic|offset|length|1455496|1455497|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/ea337231199e9a9993d7a9c2752b295e.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

Make sure the designer in visual studio is not going beyond your max width. Hover over the right page border and drag to the left to make sure the page does not go over your desired layout.
<a href="https://i.stack.imgur.com/ZccTf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZccTf.png" alt="enter image description here" /></a>

blocks|key|1670722|text|我通过执行以下操作修复了此问题。(使用最新版本的报表生成器)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1670723|第1步。)转到视图选项卡|1670724|第2步。)选中属性复选框|1670725|📷|atomic|offset|length|1670726|第3步。)在报告正文中单击(它将更新属性选项卡中的值)|1670727|1670728|第4步。)不要取这里的宽度|1670729|第5步。)右键单击报表外部的灰色区域，然后单击报表属性|1670730|1670731|第6步。)在你的身体宽度上加上你的左边距%2B右边距(如果等于10，那么你的宽度就是11)|1670732|1670733|第7步。)保存|1670734|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/a4b00c3e5b8df4dd1da8604a6a276cb6.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/1cb8d0f3eb79a07431f0825a68151faf.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/8ecb6dd416e4f9f93eac0e72067c21d0.png|3|https://ask.qcloudimg.com/http-save/yehe-900000/7ba472ef4952188a7f3c026dedffeaea.png^0|0|0|0|0|1|0|0|0|0|1|1|0|0|0|0|1|2|0|0|0|1|3|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1D|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1E|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1F|8|@]|9|@$I|1G|J|1H|1|1I]]|A|$]]|$1|K|3|L|5|6|7|1J|8|@]|9|@]|A|$]]|$1|M|3|G|5|H|7|1K|8|@]|9|@$I|1L|J|1M|1|1N]]|A|$]]|$1|N|3|O|5|6|7|1O|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1P|8|@]|9|@]|A|$]]|$1|R|3|G|5|H|7|1Q|8|@]|9|@$I|1R|J|1S|1|1T]]|A|$]]|$1|S|3|T|5|6|7|1U|8|@]|9|@]|A|$]]|$1|U|3|G|5|H|7|1V|8|@]|9|@$I|1W|J|1X|1|1Y]]|A|$]]|$1|V|3|W|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|20|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14|15|-4]]|16|$5|10|11|12|A|$13|17|15|-4]]|18|$5|10|11|12|A|$13|19|15|-4]]|1A|$5|10|11|12|A|$13|1B|15|-4]]]]

I fixed this issue by doing the following. ( Using the latest version of Report Builder )
Step 1.) Go to View Tab 
Step 2.) Check the Properties checkbox <a href="https://i.stack.imgur.com/gxGBP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gxGBP.png" alt="enter image description here" /></a> 
Step 3.) Click inside the body of your report (it will update values in properties tab) <a href="https://i.stack.imgur.com/n5MVp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n5MVp.png" alt="enter image description here" /></a> 
Step 4.) Take not of the width here 
Step 5.) Right click in the gray area outside the report and click report properties <a href="https://i.stack.imgur.com/N3Ldd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N3Ldd.png" alt="enter image description here" /></a> 
Step 6.) Add your left + right margin to your body width ( if that equals 10 then make your width 11) <a href="https://i.stack.imgur.com/phjgz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/phjgz.png" alt="enter image description here" /></a> 
Step 7.) Save

blocks|key|1455823|text|我刚刚把鬼魂的所有元素都缩短到8英寸以内了，我用鼠标修改了一下，你的报表正文应该缩短到8英寸以内。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1455824|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I just reduced all elements Wight shorter than 8 inch and it corrected ,
I did that with mouse,
your report Body should be shorter than 8 inch.

blocks|key|1669900|text|我已经成功地使用pdftk删除了pdfs中不想要/不需要的页面。你可以下载程序here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1669901|您可以尝试下面这样的方法。取自here的examples下|1669902|从in1.pdf中删除'page+13‘以创建out1.pdf+pdftk+in.pdf+cat+1-12+14端输出out1.pdf|1669903|或者：|1669904|pdftk+A=in1.pdf+cat+A1-12+A14端输出输出1.pdf|1669905|entityMap|0|LINK|mutability|MUTABLE|url|http://www.pdfhacks.com/pdftk/#packages|1|http://pwet.fr/man/linux/commandes/pdftk^0|13|4|0|0|F|4|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|U]]]]

I've successfully used pdftk to remove pages I didn't want/need in pdfs. You can download the program <a href="http://www.pdfhacks.com/pdftk/#packages" rel="nofollow noreferrer">here</a>

You might try something like the following. Taken from <a href="http://pwet.fr/man/linux/commandes/pdftk" rel="nofollow noreferrer">here</a> under examples

Remove 'page 13' from in1.pdf to create out1.pdf 
pdftk in.pdf cat 1-12 14-end output out1.pdf 

or: 

pdftk A=in1.pdf cat A1-12 A14-end output out1.pdf

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the layout size in report properties as width=18in and height =8.5in.

It gave me the whole table in a single page of PDF, but I am still getting the 2nd and 4th pages blank. 

Is the way I am doing it incorrect? How else can I get rid of those blank pages?

How to get rid of blank pages in PDF exported from SSRS

容器

我有一份两页的SSRS报告。当我将它导出到PDF时，由于它的宽度，它需要4页，其中第2页和第4页显示了表中的一个字段。我尝试在报表属性中将布局大小设置为width=18in和height =8.5in。它给了我整个表格在一页的PDF，但我仍然得到第2页和第4页空白。我这样做是不是不对？我还能怎么摆脱那些空白页呢？

问如何去除SSRS导出PDF中的空白页
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何去除SSRS导出PDF中的空白页EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何去除SSRS导出PDF中的空白页
EN