Regarding Displaying Image in List report

[dipstm]

Hi All,
I have a requirement of displaying image in list report.The image would be stored in database as binary object.Can anyone let me know how this can be done in report studio?

Thanx in advance

Regards,
Dipstm

[kattaviz]

Hi,

We have tried the following approach.

1) Create a web page (ASP or ASPX which will take a parameter and get the image from DB.
2) Insert a HTML item in the report where u want to display the image.
3) Create a data item using the following expression.
'<iframe src="http://xxx/Expand/ImagesCheck/WebForm1.aspx?r=' + [CustomerID]  + '"></iframe>'

This approach worked in Cognos 8 BI. I have never tried this in 8.1,8.2 or 8.3


Hope this helps

[dipstm]

Hi,
Thanx for ur reply.
Do you have any idea on how to insert image into database. I am  using SQL Server 2005.

Thanx,
Dipstm

[dipstm]

Hi All,
I have a table in which i have Image/Binary data.But when I am trying to display it in Cognos, I am not able to view that image.Report runs without error but image is not displayed instead a cross-mark is displayed in place of image.

Any suggestions?