Crystal Reports Multiple data on Group Level

Message

   Hello, 

i hope someone can help me (or at least tell me I'm doing things the hard way!)

I am trying to build a report that will show customer unit sales based on sales on another account.

Let me explain,

each customer has 2 accounts. eg; 3OCEAN & 8ZZOCEAN

8ZZOCEAN is a stock holding account where we send stock into the customer, and when he sells units from this stock, he reorders them on his main account (3OCEAN)

I want a report to show which product codes the customer has on his 8ZZ account, 
then on the product code group level, show the sales from his Main account.

I want the report to look similar to this:

PH                                         8ZZ QTY         3OCEAN QTY FEB     3OCEAN QTY MAR

GH1 - 8ZZOCEAN
GH2 - PARTCODE123456b             4                           12                         3   
GH2 - PARTCODE123445b             4                           10                         2
GH2 - PARTCODE334223b             4                             3                         3
GH2 - PARTCODE566743b             4                             0                         8

Ive tried formulas using the 3OCEAN account number and then summarizing by stock code, but it just gives me the quanties from the 8ZZOCEAN account (obviously because this is the first group)

I have been doing this manually for a few months using 2 reports, and VLOOKUP in excel, but there is over 3000 accounts with 8ZZ accounts and I want all this to be automated in one report.

Please help,

Im confused :(

Thanks in advance

Edited by Robotacha - 05 Apr 2011 at 4:19am