Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Look up ID to run query

Status
Not open for further replies.
grom71

grom71

IS-IT--Management
Oct 23, 2003
56
GB
Hi,
I have a db which has a table called xdailyissues.
I create various reports using this table but find when I try to run a query using the patients hospital number it can be very slow (as its not a link field).
However there is a link field within the xdailyissues table called lnkpid which is a also string field but is not identical.

e.g pts hospital number L1234567
lnkpid field P152976

My question is whether the query can look up the Hospital number field and "pick" the corresponding link field from lnkpid and use this for the query as its much faster ?

I hope that makes sense...

BTW the hospital number and link field are also in another seperate table ...if that makes it easier.
Much thanks in anticipation...
Regards,
Steve
 
Sort by date Sort by votes
It sounds like you have a resolver/bridge table.

In general, try posting technical information rather than text descriptions:

Crystal version
Database/connectivity used
Example data
Expected output

"InterBase
Microsoft SQL Server: Programming
Microsoft SQL Server: Analysis Services (OLAP)
Microsoft SQL Server: Data Transformation Services
Microsoft SQL Server: Setup and Administration
Microsoft: Access Forms
Microsoft: Access Modules (VBA Coding)
Microsoft: Access Reports
Microsoft: Access Other topics
Microsoft: FoxPro (old versions 1 to 2.6)
Microsoft: VFP -General Coding Issues
Oracle: Oracle release - 5, 6, and 7
Oracle: Oracle release - 8 and 8i
Oracle: Oracle release - 9i
Pervasive: Pervasive.SQL
Sybase: Adaptive (SQL) Server
Borland (Inprise): Delphi
Microsoft: Visual InterDev
Microsoft: Visual SourceSafe
Oracle: Enterprise Developer Suite
Adobe: Acrobat
Adobe: Photoshop
Microsoft: Active Server Pages (ASP)
PHP
Quark: QuarkXPress
ANSI_SQL
Informix 4GL
Java (Sun)
Javascript
VBA Visual Basic for Applications (Microsoft)
Visual Basic(Microsoft) -VB.NET
Visual Basic(Microsoft) ActiveX Controls and DLLs
Visual Basic(Microsoft) Databases
Visual Basic(Microsoft) Win32API
Business Objects: Crystal Reports 1 Formulas
Business Objects: Crystal Reports 2 Data Access
Business Objects: Crystal Reports 3 Integrate
Business Objects: Crystal Reports 4 Other topics
Business Objects: Seagate Info
Business Objects:Crystal Analysis
Business Objects:Crystal Enterprise
Data Dynamics: ActiveReports
Oracle: Reports
Server Rack
-General Data Recovery discussion
Data Transmission
Remote access issues
Desktop Software
Microsoft: Windows Me
Microsoft: Windows XP Pro
Enterprise Applications
Epicor solutions
J.D. Edwards ERP Solutions
Lawson Software Solutions
Macola ERP solutions
Peachtree solutions
PeopleSoft ERP Solutions
SAP ERP Solutions
Project and Data Management
Data warehousing general discussion
ODBC
OLAP
Business Objects solutions
Cognos solutions
Hyperion Solutions (Arbor) solutions
Informix solutions
-Project Management general discussion
The Corporate Water Cooler
Overcoming Obstacles Getting My Work Done
Certification and Testing
Crystal Decisions certification and testing
Oracle certification and testing
Partners
"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)
Feedback
"...Praise should be given to the Forum managers or the Tipmasters - they are what make it work - give them extra recognition!!! They are timely (prompt - unlike ACTUAL support sites) and on the ball!!!..."
More...
Partners
TopXML
Planet Source Code
DevGuru
ASP Alliance
Programmers Heaven
VisualBuilder.com
Developer Fusion
Code Project
Zvon - Guide to XML
Resource Index
Tek-Tips Forums
Find A Forum Search Posts (Keyword) Thread Number Threads by Handle Search FAQs (Keyword) Search Links (Keyword) Find An Expert Advanced Search

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 1 Formulas Forum
Look up ID to run query
thread767-914924
Forum Search FAQs Links
Read
New Posts Reply To
This Thread
E-mail It
Print It Next
Thread

grom71 (IS/IT--Manageme) Sep 10, 2004
Hi,
I have a db which has a table called xdailyissues.
I create various reports using this table but find when I try to run a query using the patients hospital number it can be very slow (as its not a link field).
However there is a link field within the xdailyissues table called lnkpid which is a also string field but is not identical.

e.g pts hospital number L1234567
lnkpid field P152976

My question is whether the query can look up the Hospital number field and "pick" the corresponding link field from lnkpid and use this for the query as its much faster ?

I hope that makes sense...

"BTW the hospital number and link field are also in another seperate table ...if that makes it easier"

That's the ONLY way iot might happen.

Join your main table to the "BTW the hospital number and link field are also in another seperate table", and then join that table to whatever this other table is. I lose interest when technical information is buried within various paragraphs of text.

Your post is disjointed and confusing, try just posting:

Main table: fields
Other table: fields
Other table: fields

Example data
Expected output

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
403
jchewsmith
jchewsmith
Corinne30
  • Locked
  • Question
Running total based on beginning parameter value
Replies
0
Views
172
Corinne30
Corinne30
Corinne30
  • Locked
  • Question
Running total based on beginning parameter value
Replies
0
Views
171
Corinne30
Corinne30
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
676
mmck1964
mmck1964
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
792
doodledump
D

Part and Inventory Search

Sponsor

Back
Top