How to impliment the photos ( which are not in the DB)?

[rajrev]

HI,
Pl. hlep me on this!

We have a problem with find a right photo for the right persion.
EX:
we don't have time to upload all the photos in the database.
But we have the photos in jpg file, the name of the file contains the empid. (for example, photo_E111.jpg, photo_E444.jpg. E111 and E444 are the empid.)

parameter for this report is Empid.
so if we enter : E111
we need the output as

Name :xxxx
EmpID :E111
DOB :11/11/1974
and print the photo - photo_E111.jpg

How to get the photo_E111.jpg for E111 as output? any suggestion /questions pl. let me know.

Thanks,
MK

 

[bdreed35]

Since they are not in the database, you would need to add all possible photos to the report, and then right the suppression formula for each one. Depending on how many employees you have, this could be a painful task. I would explore getting the photos added to the database so that you can accomlish this much easier. It also will save you on report maintenance every time a new employee starts.

~Brian

 

[yehong]

As far as I know you can only show photos on the report if they are stored in the database, not in the file system.
If you don't want to store them in the database, then you can buy a thirdpary tool that will help you in accessing photos from a file system.
Search

http://www.chelseatech.co.nz

for CrImage

 

[rajrev]

Thanks for your replay! You r right its really a painful.
if there is any way to compare the parameter value and the jpg file name (ie spilit the empid from the file name)
and write a formula for suppression...!!
Thanks!
MK

 

[bdreed35]

If you take the painful route, each individual photo will be suppressed until the current id matches it. There really isn't away to know the file name, and each photo is its own object, you will need to enter a suppression formula for each object.
When you enter the suppression formula, you will know which file it is, so you can suppress it accordingly.

~Brian

 

[dgillz]

See faq767-1988 for a discussion of alternatives on this issue.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[rajrev]

Thanks for your link. I try to con vinz my dba to store photos in database.
Thanks,
MK