Detect Picture/File Presence

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 28 Apr 2006 17:43 GMT

I am linking to photographs/pictures of employees. Some employees have a
picture.gif file while others do not have a physical file present (i.e. John
Doe has not "jdoe.gif" in the file share) depending on whether their picture
has been taken or not. Can I detect the presence/abscence of this picture
using vb code or a reporting services expression and change to a
"notavailable.gif" if the picture is not there. I'm trying to get rid of the
ugly X that appears when the file is not there.

Reply to this Message

Richard Wodabek - 28 Apr 2006 18:13 GMT

Scott:

This is what I've done to resolve this issue. I added a filename field to
the table to store the name of the image. I default it to none.gif which is
really a transparent nothing image. If I do have an image for an employee
then the name goes into the field and in the report I just display whatever
image is in the field.

HTH

Richard

>I am linking to photographs/pictures of employees. Some employees have a
> picture.gif file while others do not have a physical file present (i.e.
[quoted text clipped - 6 lines]
> the
> ugly X that appears when the file is not there.

Reply to this Message