18/02/2011
Emerson Nascimento
creio ser problema no seu agrupamento.
poste a instrução SQL para que possamos analisa-la.
é esse anexo.
SELECT r034fun.numcad, R038HLO.NumLoc, R044CAL.PerRef, SUM(R046VER.ValEve) AS Soma_ValEve
FROM R038HLO INNER JOIN
r034fun ON R038HLO.NumEmp = r034fun.numemp AND R038HLO.TipCol = r034fun.tipcol AND R038HLO.NumCad = r034fun.numcad INNER JOIN
R046VER ON r034fun.numemp = R046VER.NumEmp AND r034fun.tipcol = R046VER.TipCol AND r034fun.numcad = R046VER.NumCad INNER JOIN
R044CAL ON R046VER.NumEmp = R044CAL.NumEmp AND R046VER.CodCal = R044CAL.CodCal INNER JOIN
R008EVC ON R046VER.TabEve = R008EVC.CodTab AND R046VER.CodEve = R008EVC.CodEve
WHERE (r034fun.numcad = 1561) AND (R044CAL.PerRef BETWEEN '2010-01-01' AND '2010-03-01') AND (R008EVC.TipEve = 1) AND (R044CAL.TipCal = 11)
GROUP BY r034fun.numcad, R038HLO.NumLoc, R044CAL.PerRef
Sds.