在报告中计算控制 [英] Calculated control in a report

问题描述

嗨：


我的报告基于查询。此报告有两个子报告，也基于两个单独的查询。


主要报告： rptECHO

子报告：< b> srptEchoAP & srptEchoPay

srptEchoAP 包含与所有ECHO的发票付款相关的所有数据。 （ECHO是一个过程，通过该过程可以获得补助金的报销。）同样， srptEchoPay 还有与薪资费用相关的数据。


我在各子报告中总计了AP和工资总额的子总数。我需要在 rptECHO 的底部显示总ECHO费用（AP +工资单）。


我该怎么办？任何帮助深表感谢。


谢谢。

Hi:

I have a report that''s based on a query. This report has two sub reports which are also based on two separate queries.

Main report: rptECHO
Sub reports: srptEchoAP & srptEchoPay

srptEchoAP has all data pertaining to invoice payments for all ECHOs. (ECHO is a process through which expenses for a grant get reimbursed.) Similarly, srptEchoPay has data pertaining to payroll expenses.

I have sub total of AP and sub total of Payroll expenses on the respective sub reports. I need to show the Total ECHO expenses (AP + Payroll) at the bottom of the rptECHO.

How do I do it? Any help is much appreciated.

Thanks.

推荐答案

子报告中控件的名称是什么？


主报表上的子报表控件的名称是什么（您已经提供了报表本身的名称，包含在内。这不是问题）？

What are the names of the controls on your subreports?

What are the names of your subreport controls on the main report (You''ve already supplied the names of the reports themselves, contained within. This is not the question)?

子报告：srptEchoPayDetail

控制名称：txtPayAmount


子报告：srptEchoAPDetail

控制名称：txtAPNet


我需要rptECHO上的总数（主要报告）

txtAPNet + txtPayAmount


我在报告页脚上尝试了这个。没工作也许某种程度上我需要将这些文本框引用到子报告中。这我不知道该怎么做。


谢谢。

Sub Report: srptEchoPayDetail
Control Name: txtPayAmount

Sub Report: srptEchoAPDetail
Control Name: txtAPNet

I need the total on rptECHO (main report)
txtAPNet + txtPayAmount

I tried this on the report footer. Didn''t work. Perhaps somehow I need to refer to these text boxes to the sub report. This I don''t know how to do.

Thanks.

在我有机会正确看待这个之前，你可能想要通过参考子表单上的项目来查看。如果你还记得大多数对子表单的引用应该对子报表的工作方式非常相似，那么你应该能够计算引用。


如果没有那么我会试着看一看稍后看我是否可以让它工作。

Before I get a chance to look at this properly, you may want to take a look through Referring to Items on a Sub-Form. If you remember that most references to subforms should work very similarly for subreports, you should be able to work out the referencing.

If not then I''ll try to take a proper look later to see if I can get it to work.

这篇关于在报告中计算控制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！