多关联表分组报表问题(100分)

  • 主题发起人 主题发起人 nylx
  • 开始时间 开始时间
N

nylx

Unregistered / Unconfirmed
GUEST, unregistred user!
有3个关联表MOCTA, MOCTB, MOCTC ,其中TA001 = TB001 = TC001, TB002 = TC002, 表结构如下:<br>MOCTA(主表):<br>TA001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TA002 &nbsp; &nbsp; &nbsp; &nbsp; TA003<br>MC08090001 &nbsp; &nbsp; 2008-9-1 &nbsp; &nbsp; &nbsp; &nbsp; 0<br>MC08090002 &nbsp; &nbsp; 2008-9-3 &nbsp; &nbsp; &nbsp; &nbsp; 1<br>MC08090005 &nbsp; &nbsp; 2008-9-5 &nbsp; &nbsp; &nbsp; &nbsp; 5<br>……………………………………………<br>MOCTB(明细表):<br>TB001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TB002 &nbsp; &nbsp; &nbsp; &nbsp; TB003 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TB004<br>MC08090001 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MO08090012 &nbsp; &nbsp;1005-200-500<br>MC08090001 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MO08090008 &nbsp; &nbsp;2008-100-413<br>MC08090005 &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MO08090025 &nbsp; &nbsp;3000-250-520<br>……………………………………………………………………………<br>MOCTC(子明细表):<br>TC001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TC002 &nbsp; &nbsp; &nbsp; &nbsp; TC003 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TC004<br>MC08090001 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100-200-300 &nbsp; &nbsp; 20<br>MC08090001 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;102-205-301 &nbsp; &nbsp; 50<br>MC08090001 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;216-207-601 &nbsp; &nbsp; 10<br>MC08090001 &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500-200-100 &nbsp; &nbsp; 80<br>…………………………………………………………………………….<br>现在需要作一个报表,格式如下,请教在FASTREPORT里如何做,谢谢!<br><br>MC08090001 &nbsp; &nbsp; &nbsp; &nbsp; 2008-9-1 &nbsp; &nbsp; &nbsp; &nbsp; 0<br>-------------------------------------------------------------<br>MO08090012 &nbsp; &nbsp; &nbsp; &nbsp; 1005-200-500<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100-200-300 &nbsp; &nbsp;20<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;102-205-301 &nbsp; &nbsp;50<br>--------------------------------------------------------------<br>MO08090008 &nbsp; &nbsp; &nbsp; &nbsp; 2008-100-413<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;216-207-601 &nbsp; &nbsp;10<br>--------------------------------------------------------------<br>MO08090025 &nbsp; &nbsp; &nbsp; &nbsp; 3000-250-520 &nbsp; &nbsp; &nbsp;<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500-200-100 &nbsp; &nbsp;80<br>--------------------------------------------------------------
 
按TA001 分组,然后设置重复的不显示就OK了!
 
后退
顶部