如何组合报告？ [英] How do I combine reports?

问题描述

我有一份基于 qryAPDetails 的报告（ rptAPDetails ），显示所有发票付款的拨款费用。同样，我有一份基于 qryPayDetails 的报告（ rptPayDetails ），该报告显示了拨款的工资支出。


我想生成一份结合这两份报告的报告。我将能够按类型合并所有拨款的费用。例如，

I have a report (rptAPDetails) that is based on qryAPDetails shows grant expenses for all invoice payments. Similarly I have a report (rptPayDetails) that is based on qryPayDetails which shows payroll expenses for grants.

I would like to generate a report combining these two reports. Where I will be able to combine expenses for all grants by types. For example,

Grant 9500215

A / P费用$ xx，xxx.00

薪资费用$ xx， xxx.00

总计$ xx，xxx.00

Grant 9500215
A/P Expenses $xx,xxx.00
Payroll Expense $xx,xxx.00
TOTAL $xx,xxx.00

GRAND TOTAL（所有拨款）$ xxx，xxx.00


我制作了 rptAPDetails 的副本，并将其命名为 srptAP ，同样创建了 srptPay 。将这两个报告用作子报告。但我没有成功。我的主要表单是基于 tblECHO ，其中 ECHOID 是PK（自动）并绑定所有这些查询。


我如何合并这些报告？有人可以帮我指点一下吗？


谢谢。

GRAND TOTAL (All grants) $xxx,xxx.00

I made a copy of rptAPDetails and called it srptAP and similarly created srptPay. Used these two reports as sub reports. But I didn?t succeed. My main form is based on tblECHO where ECHOID is the PK (auto) and ties all these queries.

How do I combine these reports? Can someone please help me with directions?

Thanks.

推荐答案

xx，xxx.00

工资支出

xx,xxx.00
Payroll Expense

xx，xxx.00

TOTAL

xx,xxx.00
TOTAL

xx，xxx.00

xx,xxx.00

< b> GRAND TOTAL（所有拨款）

GRAND TOTAL (All grants)

这篇关于如何组合报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！