100分请解水晶报表问题?
我的表(table1与table2是一对多的关系,通过num相连)
table1:
num name ID Address
----------------------------------------------
0001 ZhangShang PC0001 ShangHai
0002 LiShi PC0002 BeiJing
table2:
num course
-------------------------------------------------
0001 Chinese
0001 English
0001 Maths
0002 Politics
0002 Physics
现在要打印的格式为:
num Name course Address
ID
----------------------------------------------------
0001 ZhangShang Chinese ShangHai
PC0001 English
Maths
0002 LiShi Politics BeiJing
PC0002 Physics
请问怎么解决?