?
Solved

ReportSmith 3.0 Linking

Posted on 1997-04-29
1
Medium Priority
?
282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
hpierson earned 50 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month13 days, 12 hours left to enroll

800 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