来自MySql和C＃的水晶报告中的两个不同的组树结构 [英] Two different group tree structure in a crystal report from MySql with C#
本文介绍了来自MySql和C＃的水晶报告中的两个不同的组树结构的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
来自MySql和C＃的水晶报告中的两个不同的组树结构
以下在所有表中具有唯一字段的数据库是ACCYEAR，BILLNO，BILLDATE。 />
如何获得两种不同的树结构，如下所示。
数据库名称'结算'
表名：BillDetails
Two different group tree structure in a crystal report from MySql with C#
The following db having unique fields in all tables are ACCYEAR, BILLNO, BILLDATE.
How to get two different tree structure like the following.
database name 'billing'
table name: BillDetails
|**********************
|----------> fields (BILLNO: 1, AccYear: 13-14, BillDate : 03/04/2013, CUSTNAME_AND_ADDRESS: ZYXDD)
| |*********************************************************************************************************
| |
| |-------->table name: TransportDetails (record 1)
| | | fields(Bill # : 1
| | | Acc_Year: 13-14
| | | Bill Date : 03/04/2013
| | | Transport Sl# : 1
| | | Trailer # : TXT 4568
| | | Driver # : DRIVER1)
| | |
| | | |---------->table name: Cargo Details: (record 1)
| | | | fields(Bill # : 1
| | | | Acc_Year: 13-14
| | | | Bill Date : 03/04/2013
| | |-------------->| Transport Sl# : 1
| | | CargoSlNo:1
| | | CargoPkgs: 45 WoodenCrates)
| | |
| | |---------->table name: Cargo Details: (record 2)
| | fields(Bill # : 1
| | Acc_Year: 13-14
| | Bill Date : 03/04/2013
| | Transport Sl# : 1
| | CargoSlNo:2
| | CargoPkgs: 20 PLTS)
| |
| |-------->table name: TransportDetails (record 2)
| | fields(Bill # : 1
| | Acc_Year: 13-14
| | Bill Date : 03/04/2013
| | Transport Sl# : 2
| | Trailer # : TXZ 0541
| | Driver # : DRIVER2)
| |
| | |---------->table name: Cargo Details: (record 1)
| | | fields(Bill # : 1
| | | Acc_Year: 13-14
| | | Bill Date : 03/04/2013
| |-------------->| Transport Sl# : 1
| | CargoSlNo:1
| | CargoPkgs: 52 CTNS)
| |
| |---------->table name: Cargo Details: (record 2)
| fields(Bill # : 1
| Acc_Year: 13-14
| Bill Date : 03/04/2013
| Transport Sl# : 1
| CargoSlNo:2
| CargoPkgs: 10 BALES)
|
|--------------> table name: DocumentDetails (record 1) :
| | Document-details-1:
| |
| |
| |
| |---table name: ProductDetails:(record 1)------>| table name: ProductDetails:(record 1)
| | | | Name : ccc
| | | | Manufacturer: pppp
| | | | Price : 45000
| | | |
| | | |---->|---TABLENAME:PODETAILS(RECORD 1)
| | | |---TABLENAME:PODETAILS(RECORD 2)
| | |
| | |
| | |------>| table name: ProductDetails:(record 2)
| | | Name : GFFGH
| | | Manufacturer: NUGK
| | | Price : 1285000
| | |
| | |---->|---TABLENAME:PODETAILS(RECORD 1)
| | |---TABLENAME:PODETAILS(RECORD 2)
| |
| |
| |
| |---table name: ProductDetails:(record 2)-------|-------->| table name: ProductDetails:(record 2)
| | | Name : ccc
| | | Manufacturer: pppp
| | | Price : 840000
| | |
| | |---->|---TABLENAME:PODETAILS(RECORD 1)
| | |---TABLENAME:PODETAILS(RECORD 2)
| |
| |
| |-------->| table name: ProductDetails:(record 2)
| | Name : GFFGH
| | Manufacturer: NUGK
| | Price : 950000
| |
| |---->|---TABLENAME:PODETAILS(RECORD 1)
| |---TABLENAME:PODETAILS(RECORD 2)
|
|
|
|-----------------> PAYMTDETAILS(multi records)
推荐答案
我不确定我是否理解你，但在这种情况下我建议使用子报告。
将子报告添加到原始报告 [ ^ ]
如果我错了，请访问此链接：按层次分组数据 [ ^ ]并按照屏幕左侧提供的链接进行操作。
I'm not sure i understand you well, but in this case i'd suggest to use subreports.
Adding a Subreport to the Original Report[^]
If i'm wrong, please visit this link: Grouping Data Hierarchically[^] and follow the links provided on the left side of screen.
这篇关于来自MySql和C＃的水晶报告中的两个不同的组树结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
