Attachment in Report

HCL Domino Domino Forum
1

Hi All, We have 2 modules Employee and Report.In the employee module we have information for each employee including their photographs as attachment.

Now in the report module we have to create a report in which we have to show photograph of each employee as well as their other information.

Report can be in any format : Word,Excel or HTML.

Please suggest how this can be done.

To be precise we have come to the point where we have a handle to the attachment through the following code:

While Not( doc Is Nothing)

	Dim vEval As Variant

	vEval = Evaluate("@AttachmentNames", doc)

	Forall v In vEval

		If v <> "" Then

			Msgbox("Found an attachment::" + doc.empname(0) + v )

			Set attch = doc.GetAttachment( v)

				Print |<tr>|

			Print |<td>|+attch.Name+ |/<td>|



			Print |</tr>|

		End If

	End Forall

However still not able to print image in the report.

Please help.Thanks in advance

2

Subject: Attachment in Report

If you want an image to show up in HTML, you’ll need to use an tag. The src attribute for the img will be the URL to the image (“/path/db.nsf/someview/documentUNID/$FILE/filename.ext”).

3

Subject: RE: Attachment in Report

Thanks Stan it worked!However I tried the same in Word document.I mean tried opening the report in word format instead of HTML.

In that case Photo does not appears.

Any clues.How it can be done.