>>
>>SELE NVL(Cfevents.ev_eventdesc,"") AS EVENTS, NVL(Cforderl.ol_quantity,0) AS QTY, ;
>>NVL(Cfpeople.pe_firstna,"") AS FIRST, ;
>>NVL(Cfpeople.pe_middlei,"") AS MIDDLE, NVL(Cfpeople.pe_lastnam,"") AS LAST, ;
>>NVL(Cfjobtyp.jo_jobdesc,"") AS JOB, NVL(Cfdistri.di_name,"") AS DISTRICT, ;
>>COUNT(Cforderh.oh_orderno) AS temp ;
>>FROM Confdata!cfevents ;
>> LEFT JOIN confdata!cforderl ;
>> ON Cforderl.ol_evcode = Cfevents.ev_code ;
>> LEFT JOIN confdata!cforderh ;
>> ON oh_orderno = ol_orderno ;
>> LEFT JOIN Confdata!Cfpeople ;
>> on pe_peoplid = oh_peoplid ;
>> LEFT JOIN confdata!cfjobtyp ;
>> ON Cfpeople.pe_jobid = Cfjobtyp.jo_jobid ;
>> LEFT JOIN confdata!cfdistri ;
>> ON Cfpeople.pe_distcode = Cfdistri.di_code ;
>> WHERE SUBSTR(Cfevents.ev_code,1,4) = ALLT(STR(YEAR(DATE()))) ;
>> ORDER BY ev_eventdesc, jo_jobdesc, pe_lastnam ;
>> INTO CURSOR Rptdata
>>
>><\PRE>
>>
>>Thanks!
>>
>>Sylvia
>
Rick -
Just a follow up to let you know that your GROUP BY comment caused me to pursue that angle a little more, and I found a very clever solution in a thread from two years ago, which uses the Group by idea in the report designer itself. It worked like a champ. Thanks for your input.
Sylvia
>I dont know if this solves your problem, but you are using COUNT() without a GROUP BY.