BorlandTalk.com

Luis Espinoza · Guest

Hi,
I am currently using Delphi 6 Enterprise Edition (with Update 2) and QR3
(included with Delphi) and when I try to use
one TQRExp in the summary band dont show any value or error message, just
dont show anything.

The QR access the database using one TSQLDataSet with the following command

select departamentom.cod_departamento,
departamentom.nombre,
count(captura.extension) as numllamadas,
sum(captura.duracion) as totduracion,
max(captura.duracion) as maxduracion,
min(captura.duracion) as minduracion,
avg(captura.duracion) as produracion,
sum(captura.monto) as montollamadas

from departamentom, departamentod, captura, extension, usrpbx
where departamentom.cod_departamento = departamentod.cod_departamento
and departamentod.detalle = extension.num_extension
and captura.usuario = usrpbx.cod_usrpbx
and captura.extension = extension.num_extension
group by departamentom.cod_departamento,
departamentom.nombre
order by departamentom.cod_departamento,
departamentom.nombre

and the QRExp use then following expression sum(montollamadas)

What's wrong? Any Idea?

TIA.

Luis Espinoza
[email]lcruz (AT) corp-ods (DOT) com[/email]