Cita:
Me sale un error al ejecutarlo con iReport, pero en el aqua me lo reproduce perfectamente...SELECT
C.SERVICIO,
(select count(*) from cex_cita C1 where C1.servicio=C.SERVICIO AND C1.FORCITA IS NULL AND
C1.FECHA BETWEEN '01/12/2008' AND '20/12/2008' ),
(SELECT COUNT(*) FROM CEX_PETICITA P WHERE P.CODCITA IS NULL AND P.SERVICIO=C.SERVICIO)
from cex_cita C
WHERE
C.ESTADO='PRG' AND
C.FECHA BETWEEN '01/12/2008' AND '20/12/2008'
GROUP BY C.SERVICIO
order by servicio
C.SERVICIO,
(select count(*) from cex_cita C1 where C1.servicio=C.SERVICIO AND C1.FORCITA IS NULL AND
C1.FECHA BETWEEN '01/12/2008' AND '20/12/2008' ),
(SELECT COUNT(*) FROM CEX_PETICITA P WHERE P.CODCITA IS NULL AND P.SERVICIO=C.SERVICIO)
from cex_cita C
WHERE
C.ESTADO='PRG' AND
C.FECHA BETWEEN '01/12/2008' AND '20/12/2008'
GROUP BY C.SERVICIO
order by servicio
Espero ayuda porfavor... estoy desesperado ya... xD