Thank you, Aaron. I will try that.
Mario Aguirre
Lakin General
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Monday, May 03, 2004 11:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Tables to Standard Crystal Forms
Mario,
You want shared variables. I have played with these a couple of times.
They do work for what you are trying to do.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Monday, May 03, 2004 12:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Tables to Standard Crystal Forms
Peter,
You can bring information from an ODBC connection to your .dbf reports
but
you have to do the following:
1. Create a sub report to extract the information you want.
2. Modify your .vtg or .mfg file to include the ODBC statements so
you
will be able to run the report from Vantage
;MFGODBCpasswd=sysprogress
;MFGODBCUser=sysprogress
;MFGODBCDbse=mfgsys
;MFGODBCServer=Progress91D
If you have Epicor support, look at the video trainings they have. They
give
you specific samples on that. Something I could do was to bring the part
net
weight to the report using a sub report. Multiply the net weight in the
sub
report by the quantity to be picked for the particular job I could not
do.
Anybody knows how to make a calculation with sub report and report
fields in
Crystal?
Mario Aguirre
Lakin General
-----Original Message-----
From: halm180 [mailto:Mis@...]
Sent: Monday, May 03, 2004 10:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding Tables to Standard Crystal Forms
I am trying to determine if it is possible to add one or more tables
to a standard Vantage Crystal form. I need to add information to Job
Pick Lists and the information I need (Work Center) is not contained
in the DBF files created for Job Pick List generation. Are standard
Crystal reports strictly a hardcoded deal or can we modify the
tables/data that Vantages downloads into the DBF files? Thank you in
advance for any light that you can shed on this subject!
Peter Dunbar
Halm Industries Co., Inc.
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
<http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129kbbfog/M=295196.4901138.6050264.3001176/D=gr
<http://rd.yahoo.com/SIG=129kbbfog/M=295196.4901138.6050264.3001176/D=gr>
oups
/S=1705007183:HM/EXP=1083686165/A=1874383/R=2/id=noscript/SIG=118tuuldn/
*htt
p:/companion.yahoo.com/?.cpdl=srch>
<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/302_v1_pdt_lrec_
<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/302_v1_pdt_lrec_>
01.g
if>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group>
s/S=
:HM/A=1874383/rand=339757929>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<http://groups.yahoo.com/group/vantage/
<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
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129d1cmo4/M=295196.4901138.6050264.3001176/D=gr
<http://rd.yahoo.com/SIG=129d1cmo4/M=295196.4901138.6050264.3001176/D=gr>
oups/S=1705007183:HM/EXP=1083688859/A=1874382/R=2/id=noscript/SIG=118tuu
ldn/*http://companion.yahoo.com/?.cpdl=srch
<http://companion.yahoo.com/?.cpdl=srch> >
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group>
s/S=:HM/A=1874382/rand=263619502>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<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/
<http://docs.yahoo.com/info/terms/> > .
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129b41nb2/M=295196.4901138.6050264.3001176/D=groups
/S=1705007183:HM/EXP=1083689179/A=1894283/R=2/id=noscript/SIG=118tuuldn/*htt
p:/companion.yahoo.com/?.cpdl=srch>
<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/lrec.gif>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=groups/S=
:HM/A=1894283/rand=139143147>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<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
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Mario Aguirre
Lakin General
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Monday, May 03, 2004 11:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Tables to Standard Crystal Forms
Mario,
You want shared variables. I have played with these a couple of times.
They do work for what you are trying to do.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Monday, May 03, 2004 12:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Tables to Standard Crystal Forms
Peter,
You can bring information from an ODBC connection to your .dbf reports
but
you have to do the following:
1. Create a sub report to extract the information you want.
2. Modify your .vtg or .mfg file to include the ODBC statements so
you
will be able to run the report from Vantage
;MFGODBCpasswd=sysprogress
;MFGODBCUser=sysprogress
;MFGODBCDbse=mfgsys
;MFGODBCServer=Progress91D
If you have Epicor support, look at the video trainings they have. They
give
you specific samples on that. Something I could do was to bring the part
net
weight to the report using a sub report. Multiply the net weight in the
sub
report by the quantity to be picked for the particular job I could not
do.
Anybody knows how to make a calculation with sub report and report
fields in
Crystal?
Mario Aguirre
Lakin General
-----Original Message-----
From: halm180 [mailto:Mis@...]
Sent: Monday, May 03, 2004 10:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding Tables to Standard Crystal Forms
I am trying to determine if it is possible to add one or more tables
to a standard Vantage Crystal form. I need to add information to Job
Pick Lists and the information I need (Work Center) is not contained
in the DBF files created for Job Pick List generation. Are standard
Crystal reports strictly a hardcoded deal or can we modify the
tables/data that Vantages downloads into the DBF files? Thank you in
advance for any light that you can shed on this subject!
Peter Dunbar
Halm Industries Co., Inc.
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
<http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129kbbfog/M=295196.4901138.6050264.3001176/D=gr
<http://rd.yahoo.com/SIG=129kbbfog/M=295196.4901138.6050264.3001176/D=gr>
oups
/S=1705007183:HM/EXP=1083686165/A=1874383/R=2/id=noscript/SIG=118tuuldn/
*htt
p:/companion.yahoo.com/?.cpdl=srch>
<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/302_v1_pdt_lrec_
<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/302_v1_pdt_lrec_>
01.g
if>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group>
s/S=
:HM/A=1874383/rand=339757929>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<http://groups.yahoo.com/group/vantage/
<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
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129d1cmo4/M=295196.4901138.6050264.3001176/D=gr
<http://rd.yahoo.com/SIG=129d1cmo4/M=295196.4901138.6050264.3001176/D=gr>
oups/S=1705007183:HM/EXP=1083688859/A=1874382/R=2/id=noscript/SIG=118tuu
ldn/*http://companion.yahoo.com/?.cpdl=srch
<http://companion.yahoo.com/?.cpdl=srch> >
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=group>
s/S=:HM/A=1874382/rand=263619502>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<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/
<http://docs.yahoo.com/info/terms/> > .
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129b41nb2/M=295196.4901138.6050264.3001176/D=groups
/S=1705007183:HM/EXP=1083689179/A=1894283/R=2/id=noscript/SIG=118tuuldn/*htt
p:/companion.yahoo.com/?.cpdl=srch>
<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/lrec.gif>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6050264.3001176/D=groups/S=
:HM/A=1894283/rand=139143147>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<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
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]