Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Master file and 2 large detail files Post Reply Post New Topic
Author Message
joeyg13
Newbie
Newbie
Avatar

Joined: 21 Dec 2010
Online Status: Offline
Posts: 15
Quote joeyg13 Replybullet Topic: Master file and 2 large detail files
    Posted: 14 Feb 2011 at 7:15am
[I may have initially posted this in the wrong section.]

I have a master file of PATIENT.  I Have two other files that are both very large - one is DOCUMENT (every interaction) and the other is OBSERVATION (every detail observed).
So, how to best setup my links to allow this to flow efficiently. 
(1) I want to read every PATIENT record.
(2) Based on a common key field PID, I want to retrieve every DOCUMENT for the person.
(3) Based on a common key field PID, I want to retrieve every OBSERVATION for the person.
(4) I will then print certain things learned while reading these two activity files.

My problem is that I can't seem to configure the Data and Links so that this does no become a huge geometric lookup.  In other words, since there may be 20 DOCUMENTs for each person, and 200 OBSERVATIONs for each person, it seem like for each of 2500 PATIENTs, I am doing 4000 lookups (20x200).

Am I missing something simple so that for each of my 25000 PATIENTS there is only 220 (20+200) lookups?

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.016 seconds.