Group Above Report ...Help ....

From: <agi_at_mail.taicom.com.tw>
Date: Wed, 28 Apr 1999 10:05:24 GMT
Message-ID: <7g6mh3$odr$1_at_nnrp1.dejanews.com>

Hi,theres,

     I'm new in Report 3.0. I have a problem about group above report.

  I have about 7 tables, one is customer table ( as the master ), the other 3 are summary tables and other 3 are detail tables. CUS S1, S2,S3 D1,D2,D3

  D1 is detail for S1, D2 is detail for S2, D3 is detail for S3 and all tables have a common key column cus_id.

     My goal is to get the report like this

  MASTER PARTS CUS.name CUS.zipcode CUS.address

  DETAIL PARTS1 S1.xxx S1.yyy S1.zzz S2.xxxxx S2.yyyyy S2.zzzzzz S3.xxxxxxx S3.xxxxxxx S3.xxxxxxx

  DETAIL PARTS2  ==  S1(D1) heading ==	D1.x_date  D1.b  D1.c  D1.d 
D1.x_date  D1.b  D1.c  D1.d  D1.x_date	D1.b  D1.c  D1.d




  ==  S2(D2) heading ==  D2.x_date  D2.b  D2.c	D2.d  D2.x_date  D2.b  D2.c 

D2.d D2.x_date D2.b D2.c D2.d

• S3(D3) heading == D3.x_date D3.b D3.c D3.d.. D3.x_date D3.b D3.c D3.d.. D3.x_date D3.b D3.c D3.d..

      How do I use multiple queries to achieve my goal ???

  PS. When I try 2 queries, why the detail parts always left to the first group ??? How to set the attributes to let the last group below the first group ??

 Rgds,
Agi

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 28 1999 - 12:05:24 CEST