Anybody using FRx for their financials?
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Thursday, February 28, 2002 12:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Linking Tables
Troy,
Thanks! That works too!
Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Thursday, February 28, 2002 12:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Linking Tables
Troy,
Thanks! That works too!
Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Thursday, February 28, 2002 2:50 PM
Subject: Re: [Vantage] Linking Tables
To all,
One tool that has helped me learn the best way to link is using the
"Query Wizard" in the Export Utility. In the Query Wizard, when you pick
two Vantage tables, the Wizard will do all the linking for you. Then just
make note of how the tables were linked (ie. which fields were used) and go
back to Crystal or RB and create those identicle joins. I haven't had it
fail me yet.
Just a Tip.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Jim Stetter
To: vantage@yahoogroups.com
Sent: Thursday, February 28, 2002 2:36 PM
Subject: RE: [Vantage] Linking Tables
Wendy,
Linking header/details records is not a universal rule. However, I find
that
I usually will need info from both tables. Also, many times the header
table has fields in an index that don't appear in the detail table. For
example, InvcHead has an index called INVOICEDATE composed of Company
and
invoiceDate. InvoiceDate is contained in InvcHead but not InvcDtl. Also
note
that Company is part of the index - in fact, Company is the first
component
of almost all indices. That is why you should include the company code
as
the first element of your filter even if you only have one company.
Suppose
you wanted all the invoice details for a specific date range. Your joins
would be Company-->InvcHead-->InvcDtl. Your filter would be
Company.Company = "yourcompany", InvcHead.InvoiceDate in-range
1/1/2002,
2/28/2002. Use the Data Dictionary Viewer and look at the indices
defined
for the tables you intend to use in your report. This will enable you to
determine the most effecient means to get to the data you want. Remeber,
RB
will try to use the Vantage indices where possible. A poorly
constructed
join/filter could cause RB to examine EVERY possible record set as
described
by the link.
Good Luck
Jim Stetter
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Thursday, February 28, 2002 1:53 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Linking Tables
Jim,
Thanks! Sometimes I get the proper links confused. I didn't realize
that
I should link the corresponding header table first when linking a detail
table.
Thanks again!
Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
----- Original Message -----
From: Jim Stetter
To: vantage@yahoogroups.com
Sent: Thursday, February 28, 2002 11:56 AM
Subject: RE: [Vantage] Linking Tables
Wendy,
Here are a few pointers that usually work well for me:
1. I always start with Company as the master table. Also, include
Company.Company in the filter/select even if you only have one
company
in
your database.
2. When you use detail tables (OrderDtl, LaborDtl..), use the
coresponding
header table (OrderHed, LaborHed..) and join the detail table to the
Header
table. There are some situation where this doesn't apply. One that
come
to
mind would be the join between the PackDtl and OrderRel. (But you
might
have
joined PackDtl to PackHed!)
3. Avoid linking 2 or more tables at the same level (Empbasic and
Indirect
both to LaborDtl ). This causes the query to attempt to lookup both
dependent records and can slow you down.
4. Structure your links such that the tables with fewer records are
to
the
left (joins go left to right).
To demonstrate this technique, here is how I would create the joins
for
your
example:
Company
------->Empbasic------->LaborHed-------->LaborDtl--------->Indirect(
Left Outer)
by Company by Company by Company
byCompany
and EmpID and EmployeeNum
andIndirectCode
and LaborHedSeq
HTH
Jim Stetter
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Thursday, February 28, 2002 9:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Linking Tables
Okay, all you Crystal and RB gurus............what is the best way
to
link
these 3 tables together?
Labordtl
Indirect
Empbasic
I have them linked together for a Crystal report and the report
seems to
take longer to compile than it should. Granted, I have quite a few
fields
displayed on the report, but otherwise I don't think it should take
a
while
to compile. Right now I have the tables linked by:
Labordtl - Indirect: company, indirect code (left outer join) I
need
all
data, not just indirect
Labordtl - Empbasic: company, employee num/id (equal join)
Thanks!
Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/