Hi Guys,
I am at a client's office and they are using Crystal Report 7. I am having a problem getting CR to link more than 3 tables. It will successfuly link up to 3 tables, but when I add a fourth one, the data willl not show up and the links will not show in the query. I have four tables:
Patient_Status links to Patient on Statuscode
Patient links to Assoc_Client on Patient Number,
Assoc_Client links to Client on Client Number
Here is the sql query:
SELECT Client."ClientNumber", Client."ClientName", Assoc_Clients."HospAcctNumber", Assoc_Clients."AdmissionDate", Assoc_Clients."dischargeDate", Assoc_Clients."TotalAmountDue", Assoc_Clients."ReferralDate", patient."PatientNumber", patient."FirstName", patient."LastName", patient."SpecialistID", patient."StatusCode", patient."Terminated" FROM { oj ("CTSY2K"."dbo"."Client" Client INNER JOIN "CTSY2K"."dbo"."Assoc_Clients" Assoc_Clients ON Client."ClientNumber" = Assoc_Clients."ClientNumber") INNER JOIN "CTSY2K"."dbo"."patient" patient ON Assoc_Clients."PatientNumber" = patient."PatientNumber"} WHERE (patient."StatusCode" = '33' OR patient."StatusCode" = '291' OR patient."StatusCode" = '290' OR patient."StatusCode" = '289' OR patient."StatusCode" = '288' OR patient."StatusCode" = '126') AND patient."Terminated" = '0' ORDER BY Client."ClientName" ASC
It will not show the data from the Patient_Status table, but it will show data from the other three. Is there a limitation on how many tables you can link in this version? Can anyone offer a suggestion. Thanks
|