Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Crystal Report 7 Linking tables Post Reply Post New Topic
Author Message
pellis
Newbie
Newbie


Joined: 09 Mar 2008
Online Status: Offline
Posts: 14
Quote pellis Replybullet Topic: Crystal Report 7 Linking tables
    Posted: 22 Oct 2008 at 11:01am
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
 
 
 
 
                                                         
                                                    
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.