Hi Abu Ghufran
I have a full version 1.4.8 build 105-20130424
and cant show grid.
this my ->select_command = "SELECT
MAX(INTPAC.ORI) AS oPaciente,
MAX(INTPAC.PAC) AS nPaciente,
MAX(CLIPAC.NOM) AS Nombre,
MAX(CLIPAC.NDO) AS NroDocumento,
MAX(CLIPAC.FNA) AS FechaNac,
DATEDIFF(year,MAX(CLIPAC.FNA),GETDATE()) AS Edad,
MAX(CLINST.DES) AS Institucion,
MAX(INTSEC.NOM) AS Sector,
MAX(CLISER.NOM) AS Servicio,
MAX(CNSRPO.DES) AS Tipo,
MAX(CLIPRF.NOM) AS Profesional,
MAX(DGI.DES) AS Diagnostico_Ing,
MAX(DGE.DES) AS Diagnostico_Egr,
MAX(INTPAT.DES) AS Motivo,
MAX(CLIPAC.OBS) AS Observacion,
MAX(INTPAC.FIN) AS Fecha_ing,
MAX(INTPAC.FEG) AS Fecha_egr,
MAX(INTPAC.EGR) AS Egreso
FROM INTPAC
LEFT JOIN CLIPAC
ON INTPAC.ORI=CLIPAC.ORI
AND INTPAC.PAC=CLIPAC.PAC
LEFT JOIN CLINST
ON CLIPAC.INS = CLINST.INS
LEFT JOIN CLISER
ON INTPAC.SVP = CLISER.SER
LEFT JOIN CNSRSP
ON INTPAC.ORI=CNSRSP.ORI
AND INTPAC.PAC=CNSRSP.PAC
AND CLIPAC.HCL = CNSRSP.HCL
AND CNSRSP.PRG = '465'
LEFT JOIN CNSRPO
ON CNSRSP.PRG = CNSRPO.PRG
AND CNSRSP.RSP_NUM = CNSRPO.RSP
LEFT JOIN INTPAT
ON CLIPAC.MOT = INTPAT.PAT
LEFT JOIN INTPAT DGI
ON CLIPAC.DGI_P = DGI.PAT
LEFT JOIN INTPAT DGE
ON CLIPAC.DGE_P = DGE.PAT
LEFT JOIN INTSEC
ON INTPAC.SCP = INTSEC.SEC
LEFT JOIN CLIPRF
ON CNSRSP.PRF = CLIPRF.PRF
WHERE
INTPAC.SCP IN (SELECT SEC FROM INTSEC WHERE NOM LIKE '%PISO%' OR NOM LIKE '%UTI%' OR NOM LIKE '%UCE%' OR NOM LIKE '%LIMBO%')
AND INTPAC.FEG BETWEEN CONVERT(Datetime,'2017-12-01 00:00:00',120) AND CONVERT(Datetime, '2017-12-31 23:59:59', 120)
GROUP BY INTPAC.ORI, INTPAC.PAC, CLIPAC.NOM ";