Help with Data Report Query
I have write a query which works very fine in access but when i am trying to run it through Data Environment it through a runtime error:
Run-time error '-2147467259 (80004005)':
Relate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large.
Here is the Query;
SELECT PatientTbl.PatientId, PatientTbl.PatientName, PatientTbl.ADDRESS, PatientTbl.AGE, PatientTbl.Sex, TestGroupMasterTbl.GroupNo, TestMasterTbl.LabNo, TestMasterTbl.TestDate, TestMasterTbl.PatientType, TestMasterTbl.BedNo, TestMasterTbl.TokenAdNo, TestMasterTbl.DoctorId, TestMasterTbl.DepartmentId, TestMasterTbl.TimeOfCollection, TestMasterTbl.TimeOfTest, TestMasterTbl.ConsultantId, ConsultantTbl.Name, ConsultantTbl.Degree, TestListTbl.TestNo, TestListTbl.Test, TestListTbl.NormalRange, TestDetailGroupTbl.Specimen, TestDetailTbl.Value, TestGroupMasterTbl.CategoryNo, TestGroupDetailTbl.SubCategoryNo
FROM TestListTbl INNER JOIN ((TestGroupMasterTbl INNER JOIN (PatientTbl INNER JOIN ((ConsultantTbl INNER JOIN TestMasterTbl ON ConsultantTbl.ConsultantId = TestMasterTbl.ConsultantId) INNER JOIN (TestDetailTbl INNER JOIN TestDetailGroupTbl ON TestDetailTbl.GroupNo = TestDetailGroupTbl.GroupNo) ON (TestMasterTbl.LabNo = TestDetailTbl.LabNo) AND (TestMasterTbl.LabNo = TestDetailGroupTbl.LabNo)) ON PatientTbl.PatientId = TestMasterTbl.PatientId) ON TestGroupMasterTbl.GroupNo = TestDetailGroupTbl.GroupNo) INNER JOIN TestGroupDetailTbl ON TestGroupMasterTbl.GroupNo = TestGroupDetailTbl.GroupNo) ON (TestListTbl.TestNo = TestGroupDetailTbl.TestNo) AND (TestListTbl.TestNo = TestDetailTbl.TestNo)
WHERE (((TestMasterTbl.LabNo)=[?]));
Please help;
Wasim Zafar
Re: Help with Data Report Query
Maybe a problem in
TestMasterTbl.LabNo)=[?]))
with the "?" variable.
I had some problem when i wrote queries for SQL and Access in a dataset.
Now it's crystal reports, so i cannot be sure.
Re: Help with Data Report Query
Please if u can explain the where clause.