主报告中子报表需求的每周总和 [英] weekly sum from subreport need in main report

问题描述

你好，

我将遇到以下问题:

我目前有1个主要报告和2个子报告.在这两个子报表中，均会计算每周的销售总额，并通过图表显示出来.两个子报表使用不同的数据库表.

即:
子报表_1:tbl_Product_A
子报表_2:tbl_Product_B

在子报表1中，按周计算产品A的销售总额.

在子报表2中，产品B的总销售额是按周计算的.

现在，我需要主报表中的两个子报表的每周总和，以便按周计算产品A +产品B的总销售额.

不幸的是，我没有这样做.我试图将每周的总计汇总添加到共享数组中，以便在主报表中使用它，但是这导致我的主报表中有很多变量.

有什么方法可以轻松实现这一目标吗?

我希望我能尽可能清楚地表达自己的问题，希望有人能帮助我.

非常感谢.

Hello,

I would have the following problem:

I am currently having 1 main report and 2 subreports. In both subreports a weekly sum of sales is calculated and grafically displayed via a chart. Both subreports use different db tables.

ie:
SubReport_1: tbl_Product_A
Subreport_2: tbl_Product_B

In subreport 1 the total amount of sales of product A is calculated on a weekly base.

In subreport 2 the total amount of sales of product B is calculated on a weekly base.

Now I would need the weekly sums of both sub reports within my main report in order to calculate the amount of total sales of product A + product B on a weekly base.

Unfortunately, I fail on doing that. I tried to add the weekly sub totals to a shared array in order to use it in my main report, but this causes me to have loads of variables within my main report.

Is there any way of accomplishing this in an easy way?

I hope I expressed my prolem as clearly as possible and I hope someone can help me.

Thanks a lot, cheers.

推荐答案

感谢您的帮助，但我通过简单的"UNION"表格实现了所需！

thx，sam

Thanks for your help guys, but I achieved what was need with a simple "UNION" of the tables!

thx, sam

这篇关于主报告中子报表需求的每周总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！