BOL Crystal form

Yahoo Archive
1
That did it. Thanks much!!!
KR


--- In vantage@yahoogroups.com, pjw@s... wrote:
> In the form it is already linked to the BOLDetail. The vbform field
is
> exported to the temp table for BOLDetail using the external name
you assign
> in the VBFORM. Verify the database and it should appear.
>
>
> Patrick Winter
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> krobertson4
> Sent: Wednesday, April 27, 2005 10:38 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BOL Crystal form
>
>
>
> Yes but I am having trouble linking the BOLDetail file. When I try
to link
> the company id I get a message:
>
> File link warning The specified ields may not link successfully due
to
> different type.
>
> but the link stays. When I try to link the BOLNUM, I get the error:
>
> Invalid file link. Not all fields in the same index expression.
>
> and the link disappears. I am trying to link the BOLDetail table
from our
> live account to the bolhead dbf in the working directory. Is this
correct or
> do I need to link the BOLHead table as an intermediate step?
>
> Thanks! KR
>
>
>
>
> --- In vantage@yahoogroups.com, pjw@s... wrote:
> > Did you in crystal under the "Database" drop down menu "Verify
> Database" to
> > pickup the new fields?
> >
> >
> > Patrick Winter
> > sSc Specialty Screw Corporation
> > Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal
> 8.5.3.975
> >
> >
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > krobertson4
> > Sent: Wednesday, April 27, 2005 10:10 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BOL Crystal form
> >
> >
> >
> > I have added a VB form user field to the Bill of Lading detail
> file. I would
> > like to print this field on the bill of lading but the user
defined
> fields
> > are not included in the dbf's created. Is there any way to link
the
> > BOLDetail table to the crystal report or has anyone found another
> way around
> > this problem?
> >
> > We are running Vantage 6.1. Thanks!
> >
> > KR
> >
> >
> >
> >
> >
> > 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
> > Yahoo! Groups Links
>
>
>
>
>
> 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
> Yahoo! Groups Links
2
I have added a VB form user field to the Bill of Lading detail file. I
would like to print this field on the bill of lading but the user
defined fields are not included in the dbf's created. Is there any way
to link the BOLDetail table to the crystal report or has anyone found
another way around this problem?

We are running Vantage 6.1. Thanks!

KR
3
Did you in crystal under the "Database" drop down menu "Verify Database" to
pickup the new fields?


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
krobertson4
Sent: Wednesday, April 27, 2005 10:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BOL Crystal form



I have added a VB form user field to the Bill of Lading detail file. I would
like to print this field on the bill of lading but the user defined fields
are not included in the dbf's created. Is there any way to link the
BOLDetail table to the crystal report or has anyone found another way around
this problem?

We are running Vantage 6.1. Thanks!

KR





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
Yahoo! Groups Links
4
Yes but I am having trouble linking the BOLDetail file. When I try to
link the company id I get a message:

File link warning The specified ields may not link successfully due
to different type.

but the link stays. When I try to link the BOLNUM, I get the error:

Invalid file link. Not all fields in the same index expression.

and the link disappears. I am trying to link the BOLDetail table from
our live account to the bolhead dbf in the working directory. Is this
correct or do I need to link the BOLHead table as an intermediate
step?

Thanks! KR




--- In vantage@yahoogroups.com, pjw@s... wrote:
> Did you in crystal under the "Database" drop down menu "Verify
Database" to
> pickup the new fields?
>
>
> Patrick Winter
> sSc Specialty Screw Corporation
> Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal
8.5.3.975
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> krobertson4
> Sent: Wednesday, April 27, 2005 10:10 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BOL Crystal form
>
>
>
> I have added a VB form user field to the Bill of Lading detail
file. I would
> like to print this field on the bill of lading but the user defined
fields
> are not included in the dbf's created. Is there any way to link the
> BOLDetail table to the crystal report or has anyone found another
way around
> this problem?
>
> We are running Vantage 6.1. Thanks!
>
> KR
>
>
>
>
>
> 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
> Yahoo! Groups Links
5
Don't forget to assign an external name to the vb field. That is what
triggers Vantage into downloading the fields.

Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of krobertson4
Sent: Wednesday, April 27, 2005 8:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BOL Crystal form



I have added a VB form user field to the Bill of Lading detail file. I
would like to print this field on the bill of lading but the user
defined fields are not included in the dbf's created. Is there any way
to link the BOLDetail table to the crystal report or has anyone found
another way around this problem?

We are running Vantage 6.1. Thanks!

KR





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



________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
6
In the form it is already linked to the BOLDetail. The vbform field is
exported to the temp table for BOLDetail using the external name you assign
in the VBFORM. Verify the database and it should appear.


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
krobertson4
Sent: Wednesday, April 27, 2005 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BOL Crystal form



Yes but I am having trouble linking the BOLDetail file. When I try to link
the company id I get a message:

File link warning The specified ields may not link successfully due to
different type.

but the link stays. When I try to link the BOLNUM, I get the error:

Invalid file link. Not all fields in the same index expression.

and the link disappears. I am trying to link the BOLDetail table from our
live account to the bolhead dbf in the working directory. Is this correct or
do I need to link the BOLHead table as an intermediate step?

Thanks! KR




--- In vantage@yahoogroups.com, pjw@s... wrote:
> Did you in crystal under the "Database" drop down menu "Verify
Database" to
> pickup the new fields?
>
>
> Patrick Winter
> sSc Specialty Screw Corporation
> Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal
8.5.3.975
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> krobertson4
> Sent: Wednesday, April 27, 2005 10:10 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BOL Crystal form
>
>
>
> I have added a VB form user field to the Bill of Lading detail
file. I would
> like to print this field on the bill of lading but the user defined
fields
> are not included in the dbf's created. Is there any way to link the
> BOLDetail table to the crystal report or has anyone found another
way around
> this problem?
>
> We are running Vantage 6.1. Thanks!
>
> KR
>
>
>
>
>
> 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
> Yahoo! Groups Links





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
Yahoo! Groups Links