Photos on Badges

We have a db of the file names of the employees in the photo directory. We access this and the Vantage db using a mixed ODBC / normal db report which calls in the name of the pic, then loads it into the badge.

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

Phone: +61 8 8245 6789
Fax: +61 8 8245 6788
Direct Phone: +61 8 8245 6732
Postal Address: PO Box 1141, Marleston SA 5033
Site Address: 37 Belford Ave, Devon Pk SA 5008
================================
email: dsloan@...
Web: http://www.entechgroup.net
================================
----- Original Message -----
From: Steve Ashton
To: Vantage 4.0.904 Users
Sent: Monday, April 09, 2001 11:17 PM
Subject: [Vantage] Photos on Badges


Has anybody been able to make the employee photos that appear in Shop Employee Maintenance appear automatically on the Employee Badges as well?

The badges are printed using Crystal, and the photos are bitmaps in Vantage \ Empphoto \ company \ photo.bmp

Does this require the use of ODBC?


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



To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




[Non-text portions of this message have been removed]
Has anybody been able to make the employee photos that appear in Shop Employee Maintenance appear automatically on the Employee Badges as well?

The badges are printed using Crystal, and the photos are bitmaps in Vantage \ Empphoto \ company \ photo.bmp

Does this require the use of ODBC?


[Non-text portions of this message have been removed]
Steve,
No, you shouldn't need to use ODBC, but you do need a way to put them in a
database table for Crystal to be able to associate the name with the
picture. We use a third-party software package called EpiSuite that is
designed to work with a special badge printer, but you can use Microsoft
Access just as well. To use Access and Crystal Reports, create a table in
Access with a text field for the Employee Name and an OLE Object field for
the picture. Once you've created the table you can drag and drop the
pictures into the field. Then when you point your Badge report to that
database it should work the way you expect it to.
================
Steve Sanders
Delta Centrifugal Corp.

-----Original Message-----
From: Steve Ashton [mailto:steve_universal@...]
Sent: Monday, April 09, 2001 8:48 AM
To: Vantage 4.0.904 Users
Subject: [Vantage] Photos on Badges


Has anybody been able to make the employee photos that appear in Shop
Employee Maintenance appear automatically on the Employee Badges as well?

The badges are printed using Crystal, and the photos are bitmaps in
Vantage \ Empphoto \ company \ photo.bmp

Does this require the use of ODBC?


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


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
There is an RB report we made in the Advanced Report Builder class that does this. I have already uploaded it to the Yahoogroups files area. It uses a calculated field for the image, so the image name must match what is in this field. It has been a while since we did this, & we do not use the report, so you are on your own - but feel free to play with it!

Employee Badges.PRL

John Mueske
IS Manager
Hiatt Manufacturing, Inc.
SBS 4.5 - Vantage 3.00.632


----- Original Message -----
From: Steve Ashton
To: Vantage 4.0.904 Users
Sent: Monday, April 09, 2001 8:47 AM
Subject: [Vantage] Photos on Badges


Has anybody been able to make the employee photos that appear in Shop Employee Maintenance appear automatically on the Employee Badges as well?

The badges are printed using Crystal, and the photos are bitmaps in Vantage \ Empphoto \ company \ photo.bmp

Does this require the use of ODBC?


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


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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