Pictures on reports

Yahoo Archive
1
We've been putting digital pictures of our parts on every Job
Traveler, except first run parts, since we've gone live with Vantage
in May '01. The shop loves seeing them instead of the old hand
sketch that used to be photocopied on to the Travelers back in the
DCD Classic days.

I know there have been discussions on this in the past were I've
described the method I've used but it has been quite a while and
there are lots of new names on board so I'll explain it again. It's
something I'm really proud of actually so I'm happy to pass it along.

Over time, I've made many improvements to the overall process of
managing the pics, to automate the steps and make it as efficient as
possible, I won't describe all of that now, we first need to get an
image on the traveler.

The basic thing you need is a table with a PN field and an image
field. I'm using Microsoft Access. For starters, create a table,
enter a Part Number and embed a picture as an OLE object.

Next you have to create an ODBC System DSN pointing to the Access DB
you created. Do this in the ODBC administrator.

Now go to Vantage, find a job for the PN you've entered. Print
Preview it and go into the Crystal Designer. Open the traveler rpt
and preview that. Now add a sub report. My subreport has the
JobHead table from Vantage and my PartPic table from Access joined by
PartNum, you may be able to use just the PartPic table from Access.
I'm doing some stuff with the PN from the Job Head table that is
exclusive to our company. Insert the pic field into the Subreport.
Join the sub report to the main report by PartNum to the
JobAsm.PartNum. Now you should be able to preview the report and see
the pic.

If you get that far, you need to think about managing you pics in the
Database and we can talk more about that later.

Let me know if you have questions.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "kfm1947" <kmonico@d...> wrote:
> One of my users wants to put pictures of parts on the travelers.
> Does anyone have any thoughts on how this could be done? The only
> thoughts I could pick up from the Crystal website was a rather
> complicated procedure using Visual Basic. Would appreciate any
help.
2
One of my users wants to put pictures of parts on the travelers.
Does anyone have any thoughts on how this could be done? The only
thoughts I could pick up from the Crystal website was a rather
complicated procedure using Visual Basic. Would appreciate any help.
3
Document association is the easiest way. This can be done in the master
or individual jobs. This is how I link all prints to jobs.

Thanks,

Daniel C. Spoerl
Estimator/MIS Manager
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: dans@...
WebSite: http://www.toledometalspinning.com

The information in this E-mail message is confidential and may be
legally privileged and is information intended only for the use of the
individual(s) named above. If you are not the appropriate recipient,
you are hereby notified that you should not further disseminate,
distribute, or forward this E-mail message. If you have received this
communication in error, please delete the original from your system,
destroy all paper copies, and notify us immediately so we might prevent
any recurrence.



We have taken reasonable steps to ensure that this message (and any
attachments or hyperlinks contained within it) are free from computer
viruses and the like. However, in accordance with good computing
practice, the recipient is responsible for ensuring that it is actually
virus free before opening it. Toledo Metal Spinning is under no duty to
cover any loss or damage caused by software viruses.



-----Original Message-----
From: kfm1947 [mailto:kmonico@...]
Sent: Thursday, May 13, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] pictures on reports

One of my users wants to put pictures of parts on the travelers.
Does anyone have any thoughts on how this could be done? The only
thoughts I could pick up from the Crystal website was a rather
complicated procedure using Visual Basic. Would appreciate any help.




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
As far as I know, it isn't possible to cause images to appear on job
travelers simply by associating a document with a part record or job
material requirement. I am assuming you mean you print related documents
ALONG WITH your job traveler. If this isn't what you mean, please describe
how you cause the images to appear on the job traveler per se.

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.506

-----Original Message-----
From: Dan C Spoerl [mailto:dans@...]
Sent: Thursday, May 13, 2004 10:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] pictures on reports

Document association is the easiest way. This can be done in the master
or individual jobs. This is how I link all prints to jobs.

Thanks,

Daniel C. Spoerl
Estimator/MIS Manager
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: dans@...
WebSite: http://www.toledometalspinning.com
<http://www.toledometalspinning.com>


-----Original Message-----
From: kfm1947 [mailto:kmonico@...]
Sent: Thursday, May 13, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] pictures on reports

One of my users wants to put pictures of parts on the travelers.
Does anyone have any thoughts on how this could be done? The only
thoughts I could pick up from the Crystal website was a rather
complicated procedure using Visual Basic. Would appreciate any help.




[Non-text portions of this message have been removed]
5
OK, this is NOT a practical solution except in very limited cases and would not apply to a lot of companies (ours included). But just for the sake of discussion.... if there were a case of an easily confused part where you really wanted to draw attention to a subtle difference from another part, for instance a left sided versus right sided part, this might help.

1. Create a subreport and link via the Partnum.
2. In the subreport insert a picture for each of the limited number of "special" parts
3. Lay each picture over the others (would help if all the same size)
4. Suppress printing each if the linked partnum is not a matching value
5. If no picture matches then the subreport would print blank

I do something similar directly on the main report for invoice form logos for our two company codes.

This limited solution is definitely hampered by the need to manually maintain the pictures in the subreport every time there is a new situation. But this could help certain quality control issues where there is a potential for an operator to confuse two parts.

I have a hunch CR 10 will have more capabilities in this area.

-Todd C.

-----Original Message-----
From: kfm1947 [mailto:kmonico@...]
Sent: Thursday, May 13, 2004 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] pictures on reports


One of my users wants to put pictures of parts on the travelers.
Does anyone have any thoughts on how this could be done? The only
thoughts I could pick up from the Crystal website was a rather
complicated procedure using Visual Basic. Would appreciate any help.



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 Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=129qi96nk/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1084543879/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=282238995>


_____

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
We place a small 3D image of the part in the upper corner of the traveler.
On Assemblies, I also have a 3D images of the components appear on the
assembly sections. In order to do this, I had to develop my own traveler
using Progress and Visual Basic (no Crystal at all).

-----Original Message-----
From: kfm1947 [mailto:kmonico@...]
Sent: Thursday, May 13, 2004 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] pictures on reports


One of my users wants to put pictures of parts on the travelers.
Does anyone have any thoughts on how this could be done? The only
thoughts I could pick up from the Crystal website was a rather
complicated procedure using Visual Basic. Would appreciate any help.
7
I hope someone has an answer for us on this one. We have some customers
that refuse to pay Net30 and require Net100. For those customers we want to
mark up their pricing. I'm thinking we can do this through quote entry, but
most of the orders are off the shelf and we just enter a sales order for
them. Is there any way to flag the customers so the Sales Person knows to
mark their orders up.

Any help would be appreciated.

Thanks
Paul Lipham
Alabama Specialty Products, Inc.
256-358-5230


[Non-text portions of this message have been removed]
8
Your technique works well if you want to automatically print signatures on
forms also.


Patrick Winter


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, May 13, 2004 9:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] pictures on reports

OK, this is NOT a practical solution except in very limited cases and would
not apply to a lot of companies (ours included). But just for the sake of
discussion.... if there were a case of an easily confused part where you
really wanted to draw attention to a subtle difference from another part,
for instance a left sided versus right sided part, this might help.

1. Create a subreport and link via the Partnum.
2. In the subreport insert a picture for each of the limited number of
"special" parts 3. Lay each picture over the others (would help if all the
same size) 4. Suppress printing each if the linked partnum is not a matching
value 5. If no picture matches then the subreport would print blank

I do something similar directly on the main report for invoice form logos
for our two company codes.

This limited solution is definitely hampered by the need to manually
maintain the pictures in the subreport every time there is a new situation.
But this could help certain quality control issues where there is a
potential for an operator to confuse two parts.

I have a hunch CR 10 will have more capabilities in this area.

-Todd C.

-----Original Message-----
From: kfm1947 [mailto:kmonico@...]
Sent: Thursday, May 13, 2004 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] pictures on reports


One of my users wants to put pictures of parts on the travelers.
Does anyone have any thoughts on how this could be done? The only thoughts
I could pick up from the Crystal website was a rather complicated procedure
using Visual Basic. Would appreciate any help.



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 Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=129qi96nk/M=295196.4901138.6071305.3001176/D=groups
/S=1705007183:HM/EXP=1084543879/A=2128215/R=0/SIG=10se96mf6/*http://companio
n.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=282238995>


_____

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]




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
9
If you could create an acceptable Job Traveler in Report Builder, Report
builder would allow you to print pictures of parts on the report. But
remember Report Builder is going away.


Patrick Winter


-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Thursday, May 13, 2004 9:37 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] pictures on reports

As far as I know, it isn't possible to cause images to appear on job
travelers simply by associating a document with a part record or job
material requirement. I am assuming you mean you print related documents
ALONG WITH your job traveler. If this isn't what you mean, please describe
how you cause the images to appear on the job traveler per se.

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.506

-----Original Message-----
From: Dan C Spoerl [mailto:dans@...]
Sent: Thursday, May 13, 2004 10:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] pictures on reports

Document association is the easiest way. This can be done in the master or
individual jobs. This is how I link all prints to jobs.

Thanks,

Daniel C. Spoerl
Estimator/MIS Manager
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: dans@...
WebSite: http://www.toledometalspinning.com
<http://www.toledometalspinning.com>


-----Original Message-----
From: kfm1947 [mailto:kmonico@...]
Sent: Thursday, May 13, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] pictures on reports

One of my users wants to put pictures of parts on the travelers.
Does anyone have any thoughts on how this could be done? The only thoughts
I could pick up from the Crystal website was a rather complicated procedure
using Visual Basic. Would appreciate any help.




[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
Yahoo! Groups Links
10
Todd,
I would love to see a copy of rpt file. I am going to come up with the same issues (Multicompany logos) in a few weeks.
Thanks
Jeremy Leonard
IT Manager
K-T corporation
jleonard@...



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, May 13, 2004 9:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] pictures on reports

OK, this is NOT a practical solution except in very limited cases and would
not apply to a lot of companies (ours included). But just for the sake of
discussion.... if there were a case of an easily confused part where you
really wanted to draw attention to a subtle difference from another part,
for instance a left sided versus right sided part, this might help.

1. Create a subreport and link via the Partnum.
2. In the subreport insert a picture for each of the limited number of
"special" parts 3. Lay each picture over the others (would help if all the
same size) 4. Suppress printing each if the linked partnum is not a matching
value 5. If no picture matches then the subreport would print blank

I do something similar directly on the main report for invoice form logos
for our two company codes.

This limited solution is definitely hampered by the need to manually
maintain the pictures in the subreport every time there is a new situation.
But this could help certain quality control issues where there is a
potential for an operator to confuse two parts.

I have a hunch CR 10 will have more capabilities in this area.

-Todd C.
11
Leonard,

Even though I have not done this. You might be able to do this by using
hyperlinks and changing them at runtime, you might have to run the report
from the Crystal web component (8.5), or Crystal Enterprise in later
versions. See
http://support.businessobjects.com/library/kbase/articles/c2007220.asp
<http://support.businessobjects.com/library/kbase/articles/c2007220.asp>
for additional info.

Good Luck
Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Thursday, May 13, 2004 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] pictures on reports


Todd,
I would love to see a copy of rpt file. I am going to come up with the same
issues (Multicompany logos) in a few weeks.
Thanks
Jeremy Leonard
IT Manager
K-T corporation
jleonard@...



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, May 13, 2004 9:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] pictures on reports

OK, this is NOT a practical solution except in very limited cases and would
not apply to a lot of companies (ours included). But just for the sake of
discussion.... if there were a case of an easily confused part where you
really wanted to draw attention to a subtle difference from another part,
for instance a left sided versus right sided part, this might help.

1. Create a subreport and link via the Partnum.
2. In the subreport insert a picture for each of the limited number of
"special" parts 3. Lay each picture over the others (would help if all the
same size) 4. Suppress printing each if the linked partnum is not a matching
value 5. If no picture matches then the subreport would print blank

I do something similar directly on the main report for invoice form logos
for our two company codes.

This limited solution is definitely hampered by the need to manually
maintain the pictures in the subreport every time there is a new situation.
But this could help certain quality control issues where there is a
potential for an operator to confuse two parts.

I have a hunch CR 10 will have more capabilities in this area.

-Todd C.


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=129gmqtq2/M=295196.4901138.6071305.3001176/D=groups
/S=1705007183:HM/EXP=1084557912/A=2128215/R=0/SIG=10se96mf6/*http://companio
n.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=931323379>


_____

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/> .




[Non-text portions of this message have been removed]
12
Paul,
If only a few parts are involved, set up a Price List for Net100 and link to the freeloaders.
If there are many parts and Price Lists become impractical, there is a procedure workaround you can try.

* Set the Customer default payment terms to Net100 in the Customer Master.
* Add an SOP on order entry to check the Terms in the order header before line detail entry. If this field shows Net100, the prices should be marked up.

If you're up to it, set list price to the Net100 level, then discount better payment terms from there.
It would be easier if Vantage allowed negative discounts (mark-ups/penalty) in the Terms set-up. You just have to set-up the penalty for that specific payment term.

Hope this helps,
Gil Amilbangsa
Australian Healthcare Equipment - Murphy Furniture
gil.amilbangsa@...

-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Friday, 14 May 2004 1:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Markups per customer


I hope someone has an answer for us on this one. We have some customers
that refuse to pay Net30 and require Net100. For those customers we want to
mark up their pricing. I'm thinking we can do this through quote entry, but
most of the orders are off the shelf and we just enter a sales order for
them. Is there any way to flag the customers so the Sales Person knows to
mark their orders up.

Any help would be appreciated.

Thanks
Paul Lipham
Alabama Specialty Products, Inc.
256-358-5230


[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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=1296s13od/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1084548767/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=302270838>


_____

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]