Print Page | Close Window

Master file and 2 large detail files Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12312 Printed Date: 28 Apr 2024 at 6:12am Topic: Master file and 2 large detail files Posted By: joeyg13 Subject: Master file and 2 large detail files Date 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?

Print Page | Close Window