Need query for my report

[jmendpara]

Hi,
myself Jayesh and I am work as a crystal report developer and and I am working on one report but I am unable to find the solution so can anybody help me with this pls

MY PROBLEM:
I have 5 table :
1. RepInfo ( has key DTN, RepName , ext...)
2. C_OPP_EXT (Has key DTN, OppID ...ext)
3. OPPORTUNITY ( Has key OppID, ActualCloseDate,,,etc)
3. OPPORTUNITY_PRODUCT (has key OppID,OppProdID ,,etc)
4. C_OPPPROD_EXT ( Has key OppProdID, SalesAmt, SaleCreditAmt, SFResult, SaleType...etc)

in my Report what I want is :
I want each RepName wether they have any sale or not ,totalNoOfOpportunity(total count from Opportunity table for individual sales rep ) TotalSaleAmt(for individual sales rep), TotalCreditAmt(forIndividual sales rep) and if any sales rep has no data then in report row should be like : RepName , 0 (Total Opportunity) , 0(total salesamt) , 0 (total Credit amt)

for example :
repname total opportunity total sales total sales credit amt
abc 5 1500 1000 (if rep has data)
xyz 0 00 00 (if rep has no data)

and i want to put condition like : in where clause

(C_OPPPROD_EXT."SFRESULT" LIKE 'Closed%Wo%' OR
C_OPPPROD_EXT."SFRESULT" = 'Closed') AND
(C_OPPPROD_EXT."Salestype" NOT LIKE 'STP%' OR
C_OPPPROD_EXT."Salestype" NOT LIKE 'ARM%' OR
C_OPPPROD_EXT."Salestype" <> 'A.R.M.') AND
OPPORTUNITY."ACTUALCLOSEDATE" < {ts '2006-02-24 00:00:00.00'} and OPPORTUNITY."ACTUALCLOSEDATE" > {ts '2005-11-21 00:00: 00.00'}
=============================

I wrote query by using outer join but I dont' know why isn't not working

so reply me as soon as possible on my jmendpara@gmail.com

Thanks
-Jayesh