Crystal Reports-删除2个数据字段中的重复项

Question

我的Crystal Report中有两个基于两个xml文件的数据字段。

---

第一个数据字段是-EXP

TRANSID     EXPID    PAYMENT     MONTH
trans01     exp01    1,000.00   JANUARY
trans02     exp02    2,000.00   JANUARY

第二个数据字段是-FEE

TRANSID    FEEID    PAYMENT      MONTH
trans03    fee01    3,000.00    JANUARY
trans04    fee02    4,000.00    JANUARY
trans05    fee03    5,000.00    JANUARY

---

我的预期输出是：(我希望发生这种情况(

For the month of: January
EXP                                  FEE
TRANSID     EXPID    PAYMENT          TRANSID    FEEID     PAYMENT
trans01     exp01    1,000.00         trans03    fee01    3,000.00
trans02     exp02    2,000.00         trans04    fee02    4,000.00
trans05    fee03    5,000.00

这可能吗？提前感谢！

---

但输出是这样的：

For the month of: January
EXP                                  FEE
TRANSID     EXPID    PAYMENT          TRANSID    FEEID     PAYMENT
trans01     exp01    1,000.00         trans03    fee01    3,000.00
trans02     exp02    2,000.00         trans03    fee01    3,000.00
trans01     exp01    1,000.00         trans04    fee02    4,000.00
trans02     exp02    2,000.00         trans04    fee02    4,000.00
trans01     exp01    1,000.00         trans05    fee03    5,000.00
trans02     exp02    2,000.00         trans05    fee03    5,000.00

Answer 1

1. 插入指向"费用"表的子报表。拖放此子报表上"详细信息"部分所需的字段

2. 将此子报表放在报表标题上

3. 转到章节专家>选择报告标题>检查"Underlay following sections">

4. 将Exp表中所需的字段放在主报表的Details部分。