Photo in Part File

Troy: I did write a program that allows user to enter/choose a part,
preview the image, then call an RB report to print it. It's handy in
that user can browze drawings with up/down arrow. If you'd like to
see a snapshot let me know.

Todd: It's been about 6 months, but I remember even calling Crystal
for help - no luck. I think the key is "..based on data from a field
in your data source." If you can't change that field data based on
the current part, it probably won't work. But I really can't
remember whether I tried the hyperlink option. Whatever you get to
work, please let me know.

Dan: My problem is I don't know VB, and as I understand the
solution, it requires a VB program (?)... maybe Rick will have
better luck.



--- In vantage@y..., Dan Shallbetter <dans@s...> wrote:
> Found this on Crystal site. It might not provide the dynamic
functionality
> you are looking for. I have not tested this.
>
>
http://support.crystaldecisions.com/library/kbase/articles/c2005824.as
p
>
<http://support.crystaldecisions.com/library/kbase/articles/c2005824.a
sp>
>
> Dan Shallbetter
> States Electric Mfg.
>
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@e...]
> Sent: Monday, September 23, 2002 10:11 AM
> To: vantage@y...
> Subject: Re: [Vantage] Re: Photo in Part File...
>
>
> Report Builder has the unique ability to dynamically change a path
and
> filename. If you could design a workable traveller in RB, then you
could
> print Drawings with it. There is a working example using Employee
ID's and
> Employee photos to print badges that I have seen.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Lonnie Drew
> To: vantage@y...
> Sent: Monday, September 23, 2002 10:46 AM
> Subject: [Vantage] Re: Photo in Part File...
>
>
> I've tried to insert and associate a drawing in the traveller,
but
> failed. Couldn't find a statement or function that allows
Crystal to
> dynamically change the path and filename of an image object.
>
> If you figure it out please let me know.
>
> Lonnie
>
> --- In vantage@y..., "Winter, Patrick" <pjw@s...> wrote:
> > You can do this in document management on the PartRev table if
you
> have this
> > module.
> >
> > Patrick
> >
> > -----Original Message-----
> > From: Rick Gors [mailto:rgors@o...]
> > Sent: Friday, September 20, 2002 2:58 PM
> > To: Vantage (E-mail)
> > Subject: [Vantage] Photo in Part File...
> >
> >
> > Has anyone attached or associated a photo (bitmap, jpeg, etc.)
with
> a
> > specific part file?
> >
> > I am interested in printing an image on the traveler, pack
list,
> etc. but
> > don't know how.
> >
> > I tried the VB Form, but it only allows one photo for all items.
> >
> > TIA
> >
> > Rick Gors
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
>
>
> [Non-text portions of this message have been removed]
Has anyone attached or associated a photo (bitmap, jpeg, etc.) with a
specific part file?

I am interested in printing an image on the traveler, pack list, etc. but
don't know how.

I tried the VB Form, but it only allows one photo for all items.

TIA

Rick Gors


[Non-text portions of this message have been removed]
Rick,
Use crystal reports to modify your forms with bitmaps.
We have our company logo's on all our company forms.
I want each part to have its own image.

Rick
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, September 20, 2002 3:56 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Photo in Part File...


Rick,
Use crystal reports to modify your forms with bitmaps.
We have our company logo's on all our company forms.


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Rick,
have you considered using document control? You can link files
to specific part numbers. We are linking PDF, doc, DWG, etc. You
certainly could link a BMP or JPEG.
What I've done was to have our CAD operator generate a 3-D image, in JPG
format, of all our parts and save them to a directory with the filename
being that of the part master search word. I was then able to write my own
applications to use these images. They appear on our shop floor pan tags,
shelf inventory tags, shipping/packaging labels and I am currently
redesigning our traveler to also include these images. All of these
programs were written in visual basic which are launched from a progress
routine in Vantage. Vantage dumps all the data required to a text file
which is then read by Visual Basic and then printed out in a structured
format. It's also nice in that I have developed my own browsers/trackers
that display the 3-D image on the screen.

Michael Podlin

-----Original Message-----
From: Rick Gors [mailto:rgors@...]
Sent: Friday, September 20, 2002 2:58 PM
To: Vantage (E-mail)
Subject: [Vantage] Photo in Part File...


Has anyone attached or associated a photo (bitmap, jpeg, etc.) with a
specific part file?

I am interested in printing an image on the traveler, pack list, etc. but
don't know how.

I tried the VB Form, but it only allows one photo for all items.

TIA

Rick Gors


[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/.
(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/
Rick,

Yes, I have done it. I used a simple Access DB to store the PN and
Picture associated with it. I linked the table from that DB to the
Job Traveler.rpt in Crystal and inserted the picture as a subreport.
I know I had to experiment quite a bit to get the final result to be
what I wanted, and I don't remember why I ended up using a subreport,
but it works.

The bottom line is, the picture needs to be in a Database that you
can link to the existing reports somehow. Since Vantage doesn't have
a field to use for that purpose I created my own.

We started out wanting to use CAD drawings, but we ended up taking a
digital photo of each part. Each picture is saved out in a folder on
the network and inserted into the DB by Order Processing the day they
plan to print the Job Traveler. Due to Access 97 1GB size limit and
the # of parts we have, we could not permanently keep the pics in the
DB, instead I use a macro and delete query to clean out the records
each day so they start with an empty DB every morning. The black and
white pictures print out nicely with a laser printer.

Document Association on the other hand will allow you to view the
part picture inside of Vantage, but will not allow you to print the
picture on a document. We use this as well.

Let me know if you need more info.

Brian Stenglein
Clow Stamping Co.



--- In vantage@y..., "Rick Gors" <rgors@o...> wrote:
> Has anyone attached or associated a photo (bitmap, jpeg, etc.) with
a
> specific part file?
>
> I am interested in printing an image on the traveler, pack list,
etc. but
> don't know how.
>
> I tried the VB Form, but it only allows one photo for all items.
>
> TIA
>
> Rick Gors
>
>
> [Non-text portions of this message have been removed]
You can do this in document management on the PartRev table if you have this
module.

Patrick

-----Original Message-----
From: Rick Gors [mailto:rgors@...]
Sent: Friday, September 20, 2002 2:58 PM
To: Vantage (E-mail)
Subject: [Vantage] Photo in Part File...


Has anyone attached or associated a photo (bitmap, jpeg, etc.) with a
specific part file?

I am interested in printing an image on the traveler, pack list, etc. but
don't know how.

I tried the VB Form, but it only allows one photo for all items.

TIA

Rick Gors


[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/.
(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/
I've tried to insert and associate a drawing in the traveller, but
failed. Couldn't find a statement or function that allows Crystal to
dynamically change the path and filename of an image object.

If you figure it out please let me know.

Lonnie

--- In vantage@y..., "Winter, Patrick" <pjw@s...> wrote:
> You can do this in document management on the PartRev table if you
have this
> module.
>
> Patrick
>
> -----Original Message-----
> From: Rick Gors [mailto:rgors@o...]
> Sent: Friday, September 20, 2002 2:58 PM
> To: Vantage (E-mail)
> Subject: [Vantage] Photo in Part File...
>
>
> Has anyone attached or associated a photo (bitmap, jpeg, etc.) with
a
> specific part file?
>
> I am interested in printing an image on the traveler, pack list,
etc. but
> don't know how.
>
> I tried the VB Form, but it only allows one photo for all items.
>
> TIA
>
> Rick Gors
>
>
> [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/.
> (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/
Report Builder has the unique ability to dynamically change a path and filename. If you could design a workable traveller in RB, then you could print Drawings with it. There is a working example using Employee ID's and Employee photos to print badges that I have seen.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Lonnie Drew
To: vantage@yahoogroups.com
Sent: Monday, September 23, 2002 10:46 AM
Subject: [Vantage] Re: Photo in Part File...


I've tried to insert and associate a drawing in the traveller, but
failed. Couldn't find a statement or function that allows Crystal to
dynamically change the path and filename of an image object.

If you figure it out please let me know.

Lonnie

--- In vantage@y..., "Winter, Patrick" <pjw@s...> wrote:
> You can do this in document management on the PartRev table if you
have this
> module.
>
> Patrick
>
> -----Original Message-----
> From: Rick Gors [mailto:rgors@o...]
> Sent: Friday, September 20, 2002 2:58 PM
> To: Vantage (E-mail)
> Subject: [Vantage] Photo in Part File...
>
>
> Has anyone attached or associated a photo (bitmap, jpeg, etc.) with
a
> specific part file?
>
> I am interested in printing an image on the traveler, pack list,
etc. but
> don't know how.
>
> I tried the VB Form, but it only allows one photo for all items.
>
> TIA
>
> Rick Gors
>
>
> [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/.
> (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/


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
Just curious if you have tried to insert a graphic then format the graphic
and create a hyperlink to a file using data from a field in the database
(that is, to construct a link from the part number or whatever). The
instructions on the hyperlink tab in "Format Graphic" state:

"Use the formula button to choose a hyperlink based on data from a field in
your data source".

It appears it would be easy to create this formula and with string functions
point to a picture file. If you have tried this and it has not worked let
me know so I won't have to go down a dead end.
-Todd C.

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Monday, September 23, 2002 9:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Photo in Part File...


I've tried to insert and associate a drawing in the traveller, but
failed. Couldn't find a statement or function that allows Crystal to
dynamically change the path and filename of an image object.

If you figure it out please let me know.

Lonnie

--- In vantage@y..., "Winter, Patrick" <pjw@s...> wrote:
> You can do this in document management on the PartRev table if you
have this
> module.
>
> Patrick
>
> -----Original Message-----
> From: Rick Gors [mailto:rgors@o...]
> Sent: Friday, September 20, 2002 2:58 PM
> To: Vantage (E-mail)
> Subject: [Vantage] Photo in Part File...
>
>
> Has anyone attached or associated a photo (bitmap, jpeg, etc.) with
a
> specific part file?
>
> I am interested in printing an image on the traveler, pack list,
etc. but
> don't know how.
>
> I tried the VB Form, but it only allows one photo for all items.
>
> TIA
>
> Rick Gors
>
>
> [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>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=228862.2128520.3581629.1261774/D=egroupweb/S=17050071
83:HM/A=1182691/R=0/*http://adfarm.mediaplex.com/ad/ck/990-1736-1039-333>


<http://us.adserver.yahoo.com/l?M=228862.2128520.3581629.1261774/D=egroupmai
l/S=:HM/A=1182691/rand=707165497>

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>

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]
Found this on Crystal site. It might not provide the dynamic functionality
you are looking for. I have not tested this.

http://support.crystaldecisions.com/library/kbase/articles/c2005824.asp
<http://support.crystaldecisions.com/library/kbase/articles/c2005824.asp>

Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, September 23, 2002 10:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Photo in Part File...


Report Builder has the unique ability to dynamically change a path and
filename. If you could design a workable traveller in RB, then you could
print Drawings with it. There is a working example using Employee ID's and
Employee photos to print badges that I have seen.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Lonnie Drew
To: vantage@yahoogroups.com
Sent: Monday, September 23, 2002 10:46 AM
Subject: [Vantage] Re: Photo in Part File...


I've tried to insert and associate a drawing in the traveller, but
failed. Couldn't find a statement or function that allows Crystal to
dynamically change the path and filename of an image object.

If you figure it out please let me know.

Lonnie

--- In vantage@y..., "Winter, Patrick" <pjw@s...> wrote:
> You can do this in document management on the PartRev table if you
have this
> module.
>
> Patrick
>
> -----Original Message-----
> From: Rick Gors [mailto:rgors@o...]
> Sent: Friday, September 20, 2002 2:58 PM
> To: Vantage (E-mail)
> Subject: [Vantage] Photo in Part File...
>
>
> Has anyone attached or associated a photo (bitmap, jpeg, etc.) with
a
> specific part file?
>
> I am interested in printing an image on the traveler, pack list,
etc. but
> don't know how.
>
> I tried the VB Form, but it only allows one photo for all items.
>
> TIA
>
> Rick Gors
>
>
> [Non-text portions of this message have been removed]
>
>
>




[Non-text portions of this message have been removed]