Keith,
In Crystal link the files as you said then go to Database then Show SQL
Query. Find the link between ShipHead.ShipLog = BOLHead.BOLNum and change
it to ShipHead.ShipLog = string(BOLHead.BOLNum).
Michael Benedict
IS Manager
Crestview Aerospace Corp.
In Crystal link the files as you said then go to Database then Show SQL
Query. Find the link between ShipHead.ShipLog = BOLHead.BOLNum and change
it to ShipHead.ShipLog = string(BOLHead.BOLNum).
Michael Benedict
IS Manager
Crestview Aerospace Corp.
> -----Original Message-----
> From: Keith . Mailloux [mailto:kmailloux@...]
> Sent: Wednesday, December 05, 2001 11:21 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] BOL to Packing Slip Joins
>
>
> I realize this has been discussed but I was wondering if anyone
> has come up
> with a solution on how to create a join in RB or Crystal to link the BOL
> header to the Packing Slip header. Due to the wisdom of some unknown being
> the fields of BOL number and Log Number (which are part of the link) are
> different formats numeric and character respectively. Any
> insight, cheats or
> tricks would be appreciated.
>
> Thanks,
>
> Keith Mailloux
>
>
> 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/
>
>
>