Getting Image from Annotation Table in SSRS Report

(0) Share

Report

Posted on by Jagbir Singh

Hi,

We have saved signatures as images in the annotation table and need to display those as image in the SSRS report based on object Id. Can anyone please provide directions if something similar has been achieved.

Many Thanks,

Jagbir

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Charan Raju C R 7 Moderator on at

Like (1)

Report

1. Create a DataSet which contains SQL query to retrieve DocumentBody and MimeType fields from Annotation based on object id

2. Right click on the report design select Insert --> Image

3. Under General section, select below details.

Select the image source: Database

Use this field: DocumentBody column of the DataSet created at step 1

Use this MIME type: MimeType column of the DataSet created at step 1 (Expression: =First(Fields!MimeType.Value, "<DataSetName>"))

Was this reply helpful? Yes No