Try creating a formula against the string field in the DBF
ToNumber(PoNum)
The reason you wouldn't want to link based on a ToText of the Ponum in the
Live Database, is that that formula would have to be evaluated for every po
entry in the database. Creating the formula based on the single (or at
least fewer) entries in the DBF would be the better choice.
However, linking based on a formula can create performance issues, and this
one might as well.
Hope this helps,
Thaddeus
<original msg>
Thad,
I gave this a quick shot, Its a no go because the dbf files have been
formated differently. For example, The PO number in the regular database
is
a numeric format, the exported PO has been converted to Alpha. The links
wont link with out going through some conversion.
Shirley
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, June 14, 2001 12:04 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Changing Vantage userforms (Pack Slip ...Etc)
with
Crystal Odbc forms.
You probably want to keep the master table based on the DBF export,
which
contains only one record, then link it to the ODBC connection for the
fields
not contained in the DBF using CompanyID, and Packing Slip Number.
Otherwise you have to prompt the user for the packing slip number using
a
parameter field
Of course, linking the DBD and ODBC will limit you to an inner join, but
I
believe that is not a problem in this case
Let me know if this works for you or not.
Best Regards,
Thaddeus Jacobs
Assistant LAN Technologist / Vantage Support
Kinematic Automation, Inc
mailto:tjacobs@...
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Thursday, June 14, 2001 10:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Changing Vantage userforms (Pack Slip ...Etc)
with Crystal Odbc forms.
I'm replacing the form in a major way. We are loosing a clerical person
who
did an assortment of documents related to shipping, and I've been
"requested" to automate those functions, additionally we have some
(major)
customers that demand their paperwork in a special way. IE: All
shipments
on one packing list regardless of different P.O.s, and a separate cert
document for each LOT number. I've got a Crystal form using the current
dbf
files that will produce a Cert if the appropriate VB forms checkboxes
are
checked and the right VB forms edit fields are filled in. But I need to
go
further with this. I have a couple of ideas if its not possible to
establish "CURRENT RECORD", a button in the VB forms area of the Packing
Slip header, or a compiled report in the Favorites area. Im just hoping
to
use the regular print button in the packing slip.
Shirley H. Graver
6597 West 130th St
Parma Heights, OH 44130
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, June 14, 2001 11:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Changing Vantage userforms (Pack Slip ...Etc)
with
Crystal Odbc forms.
Are you needing just one or two extra fields, or are you replacing the
whole form in major ways?
I have modified existing Userform reports by adding to the canned one
with
ODBC. I don't have any idea how to grab the data on the screen for a
report.
Troy
ToNumber(PoNum)
The reason you wouldn't want to link based on a ToText of the Ponum in the
Live Database, is that that formula would have to be evaluated for every po
entry in the database. Creating the formula based on the single (or at
least fewer) entries in the DBF would be the better choice.
However, linking based on a formula can create performance issues, and this
one might as well.
Hope this helps,
Thaddeus
<original msg>
Thad,
I gave this a quick shot, Its a no go because the dbf files have been
formated differently. For example, The PO number in the regular database
is
a numeric format, the exported PO has been converted to Alpha. The links
wont link with out going through some conversion.
Shirley
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, June 14, 2001 12:04 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Changing Vantage userforms (Pack Slip ...Etc)
with
Crystal Odbc forms.
You probably want to keep the master table based on the DBF export,
which
contains only one record, then link it to the ODBC connection for the
fields
not contained in the DBF using CompanyID, and Packing Slip Number.
Otherwise you have to prompt the user for the packing slip number using
a
parameter field
Of course, linking the DBD and ODBC will limit you to an inner join, but
I
believe that is not a problem in this case
Let me know if this works for you or not.
Best Regards,
Thaddeus Jacobs
Assistant LAN Technologist / Vantage Support
Kinematic Automation, Inc
mailto:tjacobs@...
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Thursday, June 14, 2001 10:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Changing Vantage userforms (Pack Slip ...Etc)
with Crystal Odbc forms.
I'm replacing the form in a major way. We are loosing a clerical person
who
did an assortment of documents related to shipping, and I've been
"requested" to automate those functions, additionally we have some
(major)
customers that demand their paperwork in a special way. IE: All
shipments
on one packing list regardless of different P.O.s, and a separate cert
document for each LOT number. I've got a Crystal form using the current
dbf
files that will produce a Cert if the appropriate VB forms checkboxes
are
checked and the right VB forms edit fields are filled in. But I need to
go
further with this. I have a couple of ideas if its not possible to
establish "CURRENT RECORD", a button in the VB forms area of the Packing
Slip header, or a compiled report in the Favorites area. Im just hoping
to
use the regular print button in the packing slip.
Shirley H. Graver
6597 West 130th St
Parma Heights, OH 44130
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, June 14, 2001 11:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Changing Vantage userforms (Pack Slip ...Etc)
with
Crystal Odbc forms.
Are you needing just one or two extra fields, or are you replacing the
whole form in major ways?
I have modified existing Userform reports by adding to the canned one
with
ODBC. I don't have any idea how to grab the data on the screen for a
report.
Troy
----- Original Message -----
From: Shirley Graver
To: vantage@yahoogroups.com
Sent: Thursday, June 14, 2001 11:22 AM
Subject: [Vantage] Changing Vantage userforms (Pack Slip ...Etc)
with
Crystal Odbc forms.
I've searched the archives, with no luck. I need to replace the
existing
Packing Slip form with one written in ODBC. What I'm looking for is
how
to
establish with the ODBC form to ONLY print the current record on the
screen.
The functions that I've gone through are'nt clear about how this is
done. I
certain someone has replaced the canned forms with their own. I
would
much
appreciate the help.
Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.
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
Select a
categorySpecialty-TechnologySpecialty-FinancialForeign StockLarge
GrowthMid-Cap BlendSmall Value
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
www.
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.
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
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/