Matt,
Create a formula field in the parent report and make the formula
ToNumber ({ShipDtl.PackLine }) (or whatever the table is called in the
DBF).
Then link using that field. For some reason many of the number fields
are converted to Text fields when they are exported to the DBF. I still
do not understand the logic, but I have learned to live with it.
Aaron Hoyt
Hittite Microwave Corporation
-----Original Message-----
From: Matt [mailto:mt2697@...]
Sent: Wednesday, March 24, 2004 6:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Pack Slip including Bin Numbers
I've tried modifying this in Crystal to include the Bin Number for
each line item. I've run into all kinds of problems. For one this
starts by requiring a subreport to draw the Bin Number onto the
Packing slip. I got that in there ok, but when I create the
SubReport and my links, I cannot get the table linking that I want.
PackLine is a record in the ShipDtl table which is where I'm drawing
the BinNum from, but when I try linking to it, it is not available.
Has anyone else created this successfully? If so please help.
Thank you
Matt Thompson
Montana Metal Products
Des Plaines, IL
(847) 803-6600 x217
mthompson@...
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
(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
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Create a formula field in the parent report and make the formula
ToNumber ({ShipDtl.PackLine }) (or whatever the table is called in the
DBF).
Then link using that field. For some reason many of the number fields
are converted to Text fields when they are exported to the DBF. I still
do not understand the logic, but I have learned to live with it.
Aaron Hoyt
Hittite Microwave Corporation
-----Original Message-----
From: Matt [mailto:mt2697@...]
Sent: Wednesday, March 24, 2004 6:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Pack Slip including Bin Numbers
I've tried modifying this in Crystal to include the Bin Number for
each line item. I've run into all kinds of problems. For one this
starts by requiring a subreport to draw the Bin Number onto the
Packing slip. I got that in there ok, but when I create the
SubReport and my links, I cannot get the table linking that I want.
PackLine is a record in the ShipDtl table which is where I'm drawing
the BinNum from, but when I try linking to it, it is not available.
Has anyone else created this successfully? If so please help.
Thank you
Matt Thompson
Montana Metal Products
Des Plaines, IL
(847) 803-6600 x217
mthompson@...
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
(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
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]