Solved

ReportSmith 3.0 Linking

Posted on 1997-04-29
1
271 Views
Last Modified: 2010-04-03
Please help...
 
I am using ReportSmith 3.0 and I am having problems
with a master/detail relationship.
 
I am using 3 Paradox tables:
 
BM - Broker Master file (Main table for report).
PT - Policy transaction (Detail file) - Index Broker Code.
PM - Policy Master file (Lookup File) - Index Policy Number.
 
I have linked the first two tables.
 
BM->Broker Code -------> PT->Broker Code
 
This works great, however I need to relate each PT record
to the last file PM to pick up names and addresses.
(The PM file is a large database +- 100 000 records!)
 
The link is a follows:
 
PT->Policy Number --------> PM->Policy Number
 
When I do this I have to wait for ages while it sorts
through what seems like the whole PM file (15-20mins)
this is unacceptable.  Do you know how I might
speed up the process or create a better link.
 
The PM file does have an index on the Policy Number field.
What I need is a one to one lookup on the Policy Number.
Some PT records may not have a Policy Number in which
case I want it to return a blank.
 
Thanking you in advance for your help.
 
Ian Hopewell
Hopewell and Associates
Business Information Systems.
 
e-mail: ianah@iaccess.za
Tel: 27-31-2075059
Fax: 27-31-2074868
0
Comment
Question by:Ianah
1 Comment
 
LVL 3

Accepted Solution

by:
hpierson earned 25 total points
ID: 1335785
If you are good with SQL, you could press the EDIT SQL button and try to improve on Reportsmith's SQL, perhaps using a nested SELECT statement.

Alternatively, if the PT table is relatively small (lets say a few hundred to even a couple of thousand records), you may obtain an improvement by changing the report to use only two tables, the first being BM, and the second a table which you populate before running the report, which includes the fields from the PT table, plus the fields you need from PM table. Set a tcursor on the PM table, set its index to Policy number. Build the new table record by record by going through the PT table, and use findkey on the indexed cursor on the PM table to find the right record in the PM table. The report should then have very little work to do, since it will not involve the PM table at all.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question