水晶报表子报表

发布于 2024-09-29 05:04:34 字数 300 浏览 6 评论 0原文

这是我需要帮助的场景

我有一份报告 - XYZ 摘要报告(带有嵌入的子报告)和 XYZ 详细信息报告(子报告)

要求是 XYZ 详细信息报告是 XYZ 的子报告摘要报告,也可通过参数作为独立报告使用。

报告信息:

1) 允许用户选择他们想要运行的报告的参数,XYZ 摘要报告或协议详细信息报告。

2) XYZ 详细报告还应该是 XYZ 摘要报告的子报告,这将允许用户通过选择链接的文档编号通过 XYZ 摘要报告启动 XYZ 详细报告。

不知道我讲清楚了没有。如果您需要更多信息,请告诉我

Here is the scenario where I need help

I ve got a report - XYZ Summary Report (with embedded sub-report) and the XYZ Details report (the sub-report)

The requirement is that the XYZ Details report be a sub-report to XYZ Summary Report and also be available as a Stand Alone report through a Parameter.

Report Information:

1) A Parameter allowing the user to select the report they would like to run, either the XYZ Summary Report or the Agreement Details Report.

2) The XYZ Details Report should also be a sub-report to XYZ Summary Report which would allow the user to launch the XYZ Details Report through the XYZ Summary Report by selecting the linked Document Number.

I dont know if I am clear here. Let me know if you need more informaion

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

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

发布评论

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

评论(1

花期渐远 2024-10-06 05:04:34

能够以交互方式深入了解协议详细信息,并且能够指定是在详细级别还是在摘要级别运行报告,这两者的结合使这变得非常棘手 - 前者是使用隐藏功能在 Crystal 中实现的,而后者则需要条件抑制。

如果可以避免的话,我建议不要在子报告中执行详细报告 - 我发现它们很难开发和维护。此外,由于需要交互地向下钻取或在初始运行时,您将需要链接到子报表两次 - 一次用于向下钻取,一次用于详细报告的参数化选择。请考虑将文档表链接到协议详细信息表。

如果您必须沿着子报表路线走下去,那么:

  • 使用适当的名称(例如ReportType)设置您的参数。
  • 按文档编号对主报告进行分组(如果尚未分组),并将详细信息项放在组页眉部分中,并抑制组页脚部分。
  • 将报告的详细信息部分分为两个小部分。
  • 将第一个详细信息子部分设置为隐藏(向下钻取确定)并向其中添加子报表,并在文档编号上添加适当的链接。
  • 根据参数值将第二个子部分设置为有条件抑制(在“部分专家”对话框中),并向其中添加子报表,并在文档编号上添加适当的链接。

或者,考虑 PowerUer 在评论中建议的方法。

The combination of being able to drill down to the agreement details interactively, and being able to specify whether to run the report at detail or summary level makes this quite tricky - the former is implemented in Crystal using Hide functionality, while the latter requires conditional Suppression.

I recommend not doing the detail report in a subreport if you can avoid it - I find them awkward to develop and maintain. Additionally, due to the need to drill down interactively or at initial run-time, you will need to link to the subreport twice - once for the drill down, and once for the parameterised selection of the detail report. Consider linking the Documents table to the Agreement Details table, instead.

If you have to go down the subreport route, then:

  • Set up your parameter with an appropriate name (eg ReportType).
  • Group the main report by Document Number (if it isn't already) and place the detail items in the group header section, with the group footer section suppressed.
  • Split the details section of the report into two subsections.
  • Set the first details sub-section to Hide (Drill-Down OK) and add the subreport to it, with appropriate links on Document Number.
  • Set the second sub-section to be conditionally suppressed (in the Section Expert dialog) based on the value of the parameter, and add the subreport to it, with appropriate links on Document Number.

Alternatively, consider the method suggested by PowerUer, in the comments.

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