Hello,
I'm am quite new to iReports and am still trying to understand various techniques for creating reports. I have a specific question that is puzzling me; I have a query that runs in MS SQL, however when I run the same query in the iReport Query tool it fails silently. This is the query:
SELECT TOP (100) PERCENT dbo.tblCritCareAdmit.CC_ID, dbo.tblDemographic.PATNT_PASID,
dbo.tblDemographic.Pat_Given + ' ' + dbo.tblDemographic.Pat_Family AS Name, dbo.tblCritCareAdmit.Age, dbo.tblCritCareAdmit.CCDateAdmit,
dbo.tblCritCareAdmit.CCDateDis, dbo.tblHospEpisode.HosDateDis, dbo.tblHospEpisode.Disch_Loc, dbo.tblPhysiology.Ap2Score,
dbo.tblPhysiology.Ap2Rod, dbo.tblHospOutcome.HosOutcome, dbo.tblCCOutcome.CCOutcome,
DATEDIFF(day, dbo.tblCritCareAdmit.CCDateAdmit, dbo.tblCritCareAdmit.CCDateDis) AS DaysInICU
FROM dbo.tblDemographic INNER JOIN
dbo.tblHospEpisode ON dbo.tblDemographic.PATNT_PASID = dbo.tblHospEpisode.PATNT_PASID INNER JOIN
dbo.tblCritCareAdmit ON dbo.tblHospEpisode.HSPEP_ID = dbo.tblCritCareAdmit.HSPEP_ID LEFT OUTER JOIN
dbo.tblCCOutcome ON dbo.tblCritCareAdmit.CCOutcome = dbo.tblCCOutcome.CC_Out_Code LEFT OUTER JOIN
dbo.tblHospOutcome ON dbo.tblHospEpisode.HosOutcome = dbo.tblHospOutcome.Hos_Out_ID LEFT OUTER JOIN
dbo.tblPhysiology ON dbo.tblCritCareAdmit.CC_ID = dbo.tblPhysiology.CC_ID
WHERE dbo.tblCritCareAdmit.CCOutcome!='Died in ICU'
ORDER BY dbo.tblCritCareAdmit.CCDateAdmit DESC, Name;
The specific issue is the DATEDIFF Function. If I click the "Read Fields" button in the query designer, it fails to list "DaysInICU" as a field (although "Name" is listed). Equally, refreshing "Preview Data" fails to list the field although all others are listed as expected. The Query functions as expected in the MS Query tool against the same server.
Apologies, if I am missing something here, but any assistance would be much appreicated. I am using iReports 4.7.1.
