我可以在 Crystal Reports 中进行两级链接吗？

发布于 2024-08-19 16:00:15 字数 1465 浏览 6 评论 0原文

假设我有三个列表：部门、部门和小组。部门由部门组成，部门又由小组组成。

部门将部门 ID 作为外键。组将部门 ID 作为外键。

我想制作一份如下所示的报告：

Department 1
    Division 1A
        Group 1A-i
        Group 1A-ii
        Group 1A-iii
    Division 1B
        Group 1B-i
        Group 1B-ii
        Group 1B-iii
    Division 1C
        Group 1C-i
        Group 1C-ii
        Group 1C-iii
Department 2
    Division 2A
        Group 2A-i
        Group 2A-ii
        Group 2A-iii
    Division 2B
        Group 2B-i
        Group 2B-ii
        Group 2B-iii
    Division 2C
        Group 2C-i
        Group 2C-ii
        Group 2C-iii
Department 3
    Division 3A
        Group 3A-i
        Group 3A-ii
        Group 3A-iii
    Division 3B
        Group 3B-i
        Group 3B-ii
        Group 3B-iii
    Division 3C
        Group 3C-i
        Group 3C-ii
        Group 3C-iii

我知道如何在 Crystal Reports（VB.NET 和 Visual Studio 2005）中使用子报表来让我达到部门级别：

Department 1
    Division 1A
    Division 1B
    Division 1C
Department 2
    Division 2A
    Division 2B
    Division 2C
Department 3
    Division 3A
    Division 3B
    Division 3C

但是自从我无法在子报表中包含子报表，我需要用其他方法来解决这个问题。有办法做到这一点吗？

提前致谢！

原文

Let's say I have three lists: Departments, Divisions, and Groups. A Department is made up of Divisions, which in turn is made up of Groups.

The Divisions have the Department ID as a foreign key. The Groups have the Division ID as a foreign key.

I'd like to produce a report that looks like this:

Department 1
    Division 1A
        Group 1A-i
        Group 1A-ii
        Group 1A-iii
    Division 1B
        Group 1B-i
        Group 1B-ii
        Group 1B-iii
    Division 1C
        Group 1C-i
        Group 1C-ii
        Group 1C-iii
Department 2
    Division 2A
        Group 2A-i
        Group 2A-ii
        Group 2A-iii
    Division 2B
        Group 2B-i
        Group 2B-ii
        Group 2B-iii
    Division 2C
        Group 2C-i
        Group 2C-ii
        Group 2C-iii
Department 3
    Division 3A
        Group 3A-i
        Group 3A-ii
        Group 3A-iii
    Division 3B
        Group 3B-i
        Group 3B-ii
        Group 3B-iii
    Division 3C
        Group 3C-i
        Group 3C-ii
        Group 3C-iii

I know how to use a subreport in Crystal Reports (VB.NET and Visual Studio 2005) to get me to the Division level:

Department 1
    Division 1A
    Division 1B
    Division 1C
Department 2
    Division 2A
    Division 2B
    Division 2C
Department 3
    Division 3A
    Division 3B
    Division 3C

But since I can't include a subreport within a subreport, I'll need to go about it some other way. Is there a way to do this?

Thanks in advance!

分享到QQ

分享到微博