如何让另一份报告成为报告服务的最后一页?

发布于 2024-07-23 10:03:40 字数 290 浏览 7 评论 0原文

我有两份报告需要一起打印。

  • 第一个报告的页眉和页脚将在数据溢出时重复(如有必要)。
  • 最后一页,是要发回的表格。

我基本上需要一种方法来打印最后一页,而无需第一个报告中的重复页眉/页脚,并发送要在表单中使用的参数。

目前,我有一个在页脚前面放置分页符的矩形。 在矩形内有我的第二份报告(子报告)。 我没有选中最后一页上的页眉和页脚打印。

我可以把它减少到 3 页(左上、右上、右下减去页眉/页脚)。

I have 2 reports that need to be printed together.

  • The first report has a header and footer that will repeat (if necessary) on data overflow.
  • The last page, which is a form to be sent back.

I basically need a way to print the last page without the repeated header/footers from the first report, and send in parameters to be used in the form.

Currently I have a rectangle that does a page break placed before my footer. Inside the rectangle I have my second report (subreport). I have the header and footer unchecked for print on last page.

I can get it down to 3 pages (upper-left, upper-right, and lower-right minus the header/footer).

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

椵侞 2024-07-30 10:03:40

页眉和页脚有一个名为 PrintOnLastPage 的属性,

如果将其设置为 False,则不会在报表的最后一页上打印页眉和页脚。

There is a property for the Header and Footers, called PrintOnLastPage

If you set that to False, it will not print the header and footer on the very last page of the report.

温暖的光 2024-07-30 10:03:40

最近完成了此操作,以下是如何操作。 这个处理过程因 SSRS 严重缺乏功能而受到损害。 首先,您不能在页脚中插入分页符。 其次,为了打印最后一页,它不能位于子报表中,因为子报表没有页眉或页脚。

因此,我最终找到的解决方案是将最后一页(在我的例子中是条款和条件表)放在主报告的详细信息部分中,以及页眉和页脚(在各自的部分中)。 然后添加应该出现在第一页中的报告,作为最后一页上方的详细信息部分中的子报告,并用分页符与其分开,请记住,此报告中的任何页眉或页脚都不会显示(但将页眉和页脚复制/粘贴到新的“包装器”报告中应该不会有太大问题)。

至于任何多余的白页,请检查页边距。 如果您的报告比打印机可以支持的宽度(包括边距),则每页后都会出现一个空白页。 我通常做的是将顶部和左侧边距设置为 0,然后将右侧和底部边距设置为 0,然后从那里进行调整以使其居中。

Microsoft 真的应该咬紧牙关对 SSRS 进行一些更新...多年来,与许多第三方报告包相比,Vanilla SSRS 一直是一个低于标准的解决方案,没有充分的理由。 仅通过浏览器管理报告文件是一件非常痛苦的事情,没有基于批处理的工具......

Having done this recently, here is how to do it. This processed is marred by SSRS severely lacking in features. First, you cannot insert a page break into a footer. Second, in order to print your last page, it cannot be in a subreport since subreports do not have headers or footers.

So, the solution I found in the end is to put the last page (in my case it was a terms and conditions sheet) in your main report's detail section, along with your header and footer (in their respective sections). Then add in the report that should come up in the first page as a subreport inside the detail section, above the last page, and separated from it with a page break, keeping in mind that any header or footer in this report will not show up (but shouldn't be too much of a problem to copy/paste the header and footer into your new "wrapper" report).

As for any extra white pages, check your margins. If your report is wider than the printer can support (including margins), a blank page will come out after every page. What I usually do is set the Top and Left margins and leave the Right and Bottom margins to 0, and adjust from there to get it centered.

Microsoft should really bite the bullet and do some updating to SSRS... Vanilla SSRS for years has been a sub-par solution compared to any of the many third party reporting packages out there, for no good reason. Just managing report files via the browser is a total pain, with no batch-based tools...

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文