当子报表在多个页面上呈现时,如何在每一页上显示主报表的列标题

发布于 2024-07-17 06:37:13 字数 778 浏览 4 评论 0原文

我使用 VS/SSRS 2008 在 sql 主报告(.rdl 文件)中几乎没有子报告。
子报告大约从主报告详细信息部分的页面中间开始。 我在主报告中有一组,显示标题信息并将一个参数 - ReportID 传递给每个子报告。
我还检查了以下两项:

  1. 行标题 - “在每个页面上重复标题行”和
  2. 列标题 - “在每个页面上重复标题列”

Tablix 属性的 General 选项卡上主要报告。
如果子报表中的详细信息行很少,以便所有内容都可以在第一页上呈现,则一切正常。
如果子报表中有更多详细信息行,因此无法将所有内容打印在一页上,则子报表将从第一页呈现,然后移至第二页、第三页,依此类推。

当我在子报表中有不止一页的数据时,它也会从第一页开始,并继续在第二页上呈现,依此类推...
但是,它不会在子报表的后续页面上显示主报表的列/行标题?
我注意到,当下一个项目/ReportID 在我的主报告组中启动时,它仅在第一页上打印列标题,而不在任何后续页面上打印,依此类推...

我也尝试仅检查一个,

  1. 主报告 Tablix 属性的常规选项卡上的行标题 – “在每页上重复标题行”或
  2. 列标题 – “在每页上重复标题列”,

但不起作用?

当子报表具有多页数据时,有什么想法如何在每页上打印标题信息?

I have few subreports in a sql main report(.rdl file) using VS/SSRS 2008.
The subreports start approximately on the middle of the page in the main report detail section. I have one group in main report, shows header information and pass one parameter - ReportID to each subreport.
I also have checked both:

  1. Row Headers – “Repeat header rows on each page” and
  2. Column Headers – “Repeat header columns on each page”

on General tab of Tablix properties of the main report.
If I have few detail lines in the subreport, so that all can be rendered on page one, everything is ok.
If I have more detail lines in the subreport so that it's not possible to print all on one page, the subreport renders from the fist page and moves on to page two, three and so on.

When I have more than one page of data in the subreport, it is also started on page one, and continues renders on second page and so on...
However, it doesn't show the main report's column/row headers on subsequent pages of the subreports?
I've noticed that when next item/ReportID starts in my main report group, it prints column header only on the first page but not any subsequent page and so on...

I also tried to check only ONE, either

  1. Row Headers – “Repeat header rows on each page” OR
  2. Column Headers – “Repeat header columns on each page”

on general tab of Tablix properties of the main report BUT didn’t work?

Any ideas how to print header info on each page when subreport has more than one page data?

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

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

发布评论

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

评论(3

一口甜 2024-07-24 06:37:13

SSRS 中的分页总是很有趣。

您查看过子报表的页面大小/交互吗? 这可能会停止子报表分页,但我不知道这是否是你想要的。

较旧的关于分页的文章

还有一个较新的

Pagination is always fun in SSRS.

Have you looked at the page size/interactive of the subreport? This may stop the subreport paging, but I don't know if it's what you want.

An older article on pagination

And a newer one

暮倦 2024-07-24 06:37:13

目前我遇到了同样的问题。 在之前的 SSRS 报告中,我们通过将 tablix 放入单单元格列表项中来使其工作,以便重复标题。 现在我正在编写不同的报告,当我尝试相同的操作时,我收到此错误:

[rsInvalidDetailDataGrouping] The tablix ‘tablixOpportunitySummary’ has a detail member with inner members. Detail members can only contain static inner members.

我已经进行了大量搜索,但这是指示 SSRS 中已知问题的唯一链接。 在本文发表时,它包含 4 个解决方法:

https://connect.microsoft.com/SQLServer/feedback/details/337720/katmai-reporting-services-2008-tablix-control-repeat-column-headers -不工作#

Presently I am encountering the same problem. In a previous SSRS report we got it to work by putting our tablix inside a single-cell list item so that the headers were repeated. Now I am working on a different report, and when I try the same thing I'm getting this error:

[rsInvalidDetailDataGrouping] The tablix ‘tablixOpportunitySummary’ has a detail member with inner members. Detail members can only contain static inner members.

I've searched extensively, but this is the only link which indicates an known problem in SSRS. At the time of this post it contained 4 workarounds:

https://connect.microsoft.com/SQLServer/feedback/details/337720/katmai-reporting-services-2008-tablix-control-repeat-column-headers-does-not-work#

灰色世界里的红玫瑰 2024-07-24 06:37:13

有点晚了,但我认为这就是您正在寻找的:

您需要转到 tablix Properties > 常规并选中选项滚动时保持标题可见。 然后转到高级模式中的列/行组,选择静态行并将固定数据模式设置为True在新页面上重复True与组保持一致After

这可能是最好的参考: 这里

A little late, but I think this is what you are looking for:

You need to go to tablix properties > General and check the option Keep header visible while scrolling. Then go to column/row groups in the advanced mode, chose your static row and set the Fixed Data mode to True, Repeat on new page to True and Keep with group to After.

Here is probably the best reference: Here

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